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

Leave a Comment

Your email address will not be published. Required fields are marked *