April 5, 2010 at 1:29 pm
Hi folks,
Can anyone tell me where is the login user's ip address? can that be linked with principal_id in sys.server_principals or any where in trace file?
Thanks in advance.
April 5, 2010 at 1:54 pm
Start with this article.
http://technet.microsoft.com/en-us/library/bb326598.aspx
There it discusses logon events, DDL Triggers, and capturing IP address.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 4:20 pm
I didn't see that this question was a duplicate post.
Here is the other version of this question.
http://www.sqlservercentral.com/Forums/Topic896983-146-1.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 6, 2010 at 1:33 pm
halifaxdal (4/5/2010)
Can anyone tell me where is the login user's ip address? can that be linked with principal_id in sys.server_principals or any where in trace file?
The user's IP address (if they connected over TCP/IP) is associated with the connection - client net address on sys.dm_exec_connections. That DMV links to sys.dm_exec_sessions via the session_id column. The sessions DMV provides login credential information.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
April 6, 2010 at 1:37 pm
I have had to update this script. I found a couple of caveats related to the initial request.
There is a problem in linking the historical pieces of the trace file to the current activity that is present in sys.dm_exec_sessions and sys.dm_exec_connections (the SPID is reused).
I have blogged about this. It may be worth a read.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply