T-SQL CLR to query session hostname

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jason S Wong » T-SQL CLR to query session hostname

T-SQL CLR to query session hostname

Rate Topic

Display Mode

Topic Options

Author

Message

Repriser-991084

Posted Thursday, May 31, 2012 9:55 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 18, 2013 7:54 AM
Points: 142, Visits: 414

Comments posted to this topic are about the item T-SQL CLR to query session hostname

Post #1309477

Bill Galashan

Posted Saturday, June 02, 2012 11:12 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 14, 2013 2:57 AM
Points: 124, Visits: 203

a touch overkill to get the hostname for sessions on your server perhaps?

select s.host_name
from sys.dm_exec_connections C
join sys.dm_exec_sessions S on S.session_id = C.session_ID
where C.client_net_address = '127.0.0.1'

will provide the same information a lot simpler and safer than allowing a CLR on your system with External_Access

However as an approach to allow a dns lookup from within sql server this is effective. I wrote something very similar 6 years ago when i was analysing web server logs associated with identifying click fraud and needed to do a lookup and at times a reverse lookup to fill the gaps in the data as provided by the logs.

Post #1310108

« Prev Topic | Next Topic »

Permissions