Sql Server | Get host address of the client connecting to server

SELECT client_net_address, COUNT(*) 
FROM sys.dm_exec_connections
GROUP BY client_net_address