SELECT dec.client_net_address ,
des.program_name ,
des.host_name ,
–des.login_name
COUNT(dec.session_id) AS connection_count
FROM sys.dm_exec_sessions AS des
INNER JOIN sys.dm_exec_connections AS dec
ON des.session_id = dec.session_id
— WHERE LEFT(des.host_name, 2) = ‘WK’
GROUP BY dec.client_net_address ,
des.program_name ,
des.host_name
— des.login_name
— HAVING COUNT(dec.session_id) > 1
ORDER BY des.program_name,
dec.client_net_address ;