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

Question

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

오혜원 46

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 .

SSingh-MSFT 16,296 Reputation points Moderator

2022-12-02T04:57:38.983+00:00

Hi @오혜원 ,

Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Accepted answer

0 additional answers

Your answer

SSingh-MSFT 16,296 Reputation points Moderator

2022-12-02T04:57:38.983+00:00

Hi @오혜원 ,

Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Answer 1

SSingh-MSFT 16,296 Moderator

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:

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.

오혜원 46 Reputation points

2022-11-29T06:53:39.87+00:00

hi
i want to see the logon error log only.
which column should i use for it?
SSingh-MSFT 16,296 Reputation points Moderator

2022-11-29T07:52:29.507+00:00

Hi @오혜원 ,

You can make use of sys.event_log which Returns successful Azure SQL Database database connections and connection failures. You can use this information to track or troubleshoot your database activity.

The query has to be executed in Master Database:

Let me know if this answers your question or the ask is different.

Share via

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

0 additional answers

Your answer