SP_WHO2 into a table to query

The following SQL will return the results of a SP_WHO2 query into a temporarty #SP_WHO2 table to allow querying of the table:

CREATE TABLE #sp_who2 (SPID INT,Status VARCHAR(255),

      Login  VARCHAR(255),HostName  VARCHAR(255),

      BlkBy  VARCHAR(255),DBName  VARCHAR(255),

      Command VARCHAR(255),CPUTime INT,

      DiskIO INT,LastBatch VARCHAR(255),

      ProgramName VARCHAR(255),SPID2 INT,

      REQUESTID INT)

INSERT INTO #sp_who2 EXEC sp_who2

SELECT      *

FROM        #sp_who2

-- Add any filtering of the results here :

WHERE       DBName <> 'master'

-- Add any sorting of the results here :

ORDER BY    DBName ASC

DROP TABLE #sp_who2