SQL DBA - Get a count of SQL connections by IP address

SELECT ec.client_net_address ,

es.[program_name] ,

es.[host_name] ,

es.login_name ,

COUNT(ec.session_id) AS [connection count]

FROM sys.dm_exec_sessions AS es

INNER JOIN sys.dm_exec_connections AS ec

ON es.session_id = ec.session_id

GROUP BY ec.client_net_address ,

es.[program_name] ,

es.[host_name] ,

es.login_name

ORDER BY ec.client_net_address ,

es.[program_name] ;