The trusty “sp_who2” is a quick way to look at what’s happening on your SQL instance, but completely lacks the ability to filter using a WHERE clause. You may have to manually sift through hundreds of results to find what you need.
Never fear.
This quick script gives you the same basic output that sp_who2 gives, except you can throw a filter on the results with the WHERE clause.