Post reply

SQL SERVER AUDIT LOG can scheduled job be placed and get file in .csv format

  • August 3, 2023 at 1:04 am

    #4251467

    Hi Team,

    SQL SERVER AUDIT LOG can scheduled job be placed and get file in .csv format

    we can see the audit logs using view logs rather than is there any way we can set the audit to run in frequency for every one hour and schedule it in a job where we can get the result in .csv file format instead of getting it in .sqlaudit format.

    Thanks
    Naga.Rohitkumar

  • August 3, 2023 at 8:17 am

    #4251727

    No unfortunately not.

    The file is encrypted in a rudimentary way so no easy way to get the contents, and it's also not in a nice format.

    Your best bet is to actually log the data to the application/security Windows log and have a syslog tool extract that information into itself (something like Azure Sentinel) then you can report from there instead.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply