Forum Discussion
OS User missing in fields of sys.fn_get_audit_file
Hi Operating system user is missing in fields of sys.fn_get_audit_file. https://learn.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-get-audit-file-transact-sql?view=sql-ser...
What for a OS user do you expect? It's the SQL Server service account creating the audit files.
- I am talking for the Client's OS user. The one that connects to the SQL Server via the SQL Server Client.
- Again, SQL Server service account creating the audit files, not a user.
- Hi Olaf
May be I was not clear enough.
Say one connects from a certain PC X, with an certain OS user, to a MS SQL Server - using SQL Server Client. CouldI be using SQL Studio or any other program that connects to SQL Server.
In the Audit Trail, which can be accessed by sys.fn_get_audit_file, I would like to see the OS User of the PC X. Just like I can see, ex., field application_name.
Seems this is missing on sys.fn_get_audit_file's result.
best regards
Altin
