How can I view a SQL Audit File on Linux?
-
I am in an all linux environment and I would really like to be able to view sql audit files from Linux. I tried opening the audit file with Azure Data Studio with no joy.
Does anyone know how I can view these audits in linux or if it is possible? MS says you need SSMS 2019 which isnt available for linux : /
-
Is this not possible using Azure Data Studio?
sys.fn_get_audit_file
https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-get-audit-file-transact-sql?view=sql-server-ver15 -
It looks like it may be possible if I connect to the DB servers, which isnt what I wanted. The binary audit file is being written to s3. I want someone just to be able to review it like that.
