[SQL Snippet]Query Connection Information

Okay I’m trying to improve my sql skills so I’ve opened up today a new category called SQL there I will try to post various stuff of course useful stuff ūüėČ

This is my first snippet for you guys this snippet show’s you the time when a connection has been established from which Inet or Local IP address.

SELECT  CONVERT(DATETIME, connect_time, 1) AS [Connection Time] ,        client_net_address AS [Client Internet Address] ,        local_net_address AS [Local IP Address]FROM    sys.dm_exec_connectionsORDER BY [Connection Time] DESC