SELECT * FROM sys.dm_exec_sessions WHERE host_name IS NOT NULL

SELECT login_name ,COUNT(session_id) AS session_count
FROM sys.dm_exec_sessions
GROUP BY login_name;