December 5, 2017 at 11:47 pm
I am looking for a way to fetch client application name in audit logs in SQL Server. As per the MSDN page, it should be available from SQL Server 2017 on-wards.
I have created a database level audit specification for select and insert and I want to determine which application is executing those queries.
Any help around this topic is appreciated.
December 8, 2017 at 10:37 am
ajeet.s.chouhan - Tuesday, December 5, 2017 11:47 PMI am looking for a way to fetch client application name in audit logs in SQL Server. As per the MSDN page, it should be available from SQL Server 2017 on-wards.I have created a database level audit specification for select and insert and I want to determine which application is executing those queries.
Any help around this topic is appreciated.
Are you querying the log using sys.fn_get_audit_file or are you trying to do the View Audit Logs in SSMS?
Use the query - using SSMS has different issues and can be problematic.
Sue
December 12, 2017 at 11:01 pm
Hello Sue
Yes, I was trying to view it in SSMS. The query works fine and it returns the correct data.
December 12, 2017 at 11:58 pm
Keep in mind that application name can be pretty easily spoofed. It's set by the connecting application.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 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