[SQL SERVER] 统计SQL用户连接情况(sp_who)
create table #t(spid int null, ecid int null, status nvarchar(100) null, loginname sysname null, hostname nvarchar(100) null, blk int null, dbname sysname null, cmd nvarchar(100) null,request_id int)
insert #t exec sp_who
select loginname, hostname ,dbname, count(1) from #t
where loginname not like '%Administrator'
group by loginname,hostname,dbname
order by dbname,hostname
drop table #t