SQL Server - Who

who.sql

DECLARE @sp_who2 TABLE(
        SPID INT,
        Status VARCHAR(MAX),
        LOGIN VARCHAR(MAX),
        HostName VARCHAR(MAX),
        BlkBy VARCHAR(MAX),
        DBName VARCHAR(MAX),
        Command VARCHAR(MAX),
        CPUTime INT,
        DiskIO INT,
        LastBatch VARCHAR(MAX),
        ProgramName VARCHAR(MAX),
        SPID_1 INT,
        REQUESTID INT
)
INSERT INTO @sp_who2 EXEC sp_who2
SELECT HostName, DBName, ProgramName, COUNT(*) AS Total
FROM @sp_who2
GROUP BY HostName, DBName, ProgramName