OS User missing in fields of sys.fn_get_audit_file

Question

HiOperating 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-server-ver16#tables-returned&nbsp;Any way to add it on an existing field - ex. field&nbsp;additional_information ?Will it be added in future versions ?best regardsAltin

olafhelper · Answer

What for a OS user do you expect? It's the SQL Server service account creating the audit files.

akaraulli · Answer

I am talking for the Client's OS user. The one that connects to the SQL Server via the SQL Server Client.

olafhelper · Answer

Again, SQL Server service account creating the audit files, not a user.

akaraulli · Answer

Is there any plan to introduce Client's OS User in future versions ?In other DBs - ex Oracle - its is there since long time ago

akaraulli · Answer

Hi OlafMay 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 regardsAltin

Forum Discussion

OS User missing in fields of sys.fn_get_audit_file

5 Replies

Resources