How can i check the mssql error log in blob storage for auditing?

오혜원 41 Reputation points
2022-11-29T01:33:26.26+00:00

hi i already made mssql audit policy for saving every log (SQL Insights,Automatic tuning,Query Store Runtime Statistics,Query Store Wait Statistics.Errors.../) connected with storage.
so i can check the blob file in that storage every day.
I use ssms to see the data and merge audit file. and i export this data to my onpromise mssql like that url.(https://www.sqlshack.com/getting-started-with-azure-sql-database-auditing-using-blob-storage/)
but i can only check the connection information. i want to see the more info .
264926-1.png

Azure SQL Database
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,616 questions
{count} votes

Accepted answer
  1. ShaktiSingh-MSFT 14,381 Reputation points Microsoft Employee
    2022-11-29T06:46:31.213+00:00

    Hi @오혜원 ,

    Welcome to Microsoft Q&A and thanks for using Azure services.

    As I understand your ask, you want to see more columns in Audit log file which is generated for your SQL Server using Storage Account and viewed through SSMS. Please correct me if I missed anything.

    I have tried the same scenario in a sql server and storage account and the audit file as .xel which looks like below:

    265047-image.png

    I have followed the steps mentioned in the standard documentation: Auditing for Azure SQL Database and Azure Synapse Analytics

    Hope this helps.

    Please let us know which columns particularly you are looking for and is missing in the audit file.


0 additional answers

Sort by: Most helpful