Forum Discussion

olafhelper's avatar
olafhelper
Bronze Contributor
Feb 27, 2024

Re: OS User missing in fields of sys.fn_get_audit_file

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

2 Replies

  • akaraulli's avatar
    akaraulli
    Brass Contributor
    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
  • akaraulli's avatar
    akaraulli
    Brass Contributor
    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

Resources