May 7, 2024 at 12:40 pm
My knowledge of Extended Events is limited, but I am trying to capture some login details with extended events and can see actions for:
sqlserver.client_app_name
sqlserver.client_hostname
sqlserver.database_name
sqlserver.username
etc
I would also like to find out the client interface (.Net SqlClient Data Provider, ODBC, OLEDB etc), which is client_interface_name in sys.dm_exec_sessions.
Does anyone know if it is possible to capture this in an extended event or will I have to use a Logon Trigger?
May 8, 2024 at 9:46 am
have you checked the extended events KBs for more detail
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
May 8, 2024 at 10:18 am
I could not find anything so I just went with a logon trigger.
May 8, 2024 at 11:33 am
using the login event from the session category and capturing the relevant global fileds i was able to connect via a sql acct and pull data and see the connections app name in the extended event log.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
May 8, 2024 at 12:12 pm
Thanks for the information although I do not understand the process. I will try and look at it sometime. The sessions I am actually interested in only last a second or two so I am not sure of the implications of connecting with a SQL account.
May 8, 2024 at 12:21 pm
I just used a SQL acct for demo purposes, you would need to filter the event trace or have the headache of searching through it, you may have a group of users for example that you want to track
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy