Skip to content

Instantly share code, notes, and snippets.

@tkouba

tkouba/client_net_address.sql

Created January 12, 2017 08:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tkouba/08c522b6c9aad93898c0fe9d64aea578 to your computer and use it in GitHub Desktop.
Save tkouba/08c522b6c9aad93898c0fe9d64aea578 to your computer and use it in GitHub Desktop.
Download ZIP
Get connected client net addresses (T-SQL)
Raw
client_net_address.sql
select distinct
net_transport,
client_net_address,
hostname,
program_name,
db.name as database_name,
sp.loginame
from master.sys.dm_exec_connections ec
inner join master.dbo.sysprocesses sp
on sp.spid = ec.session_id
inner join master.sys.databases db
on db.database_id = sp.dbid
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment