SQL query to get the activities or queries executed RRS feed

  • Question

  • Hello Team,

    Is there any SQL query for Azure SQL datawarehouse or Azure SQL database to get the audit logs:

    meaning the activities executed or the queries hit on the databases for last 10 days?

    We need to get the activities or queries that had failed on the database.

    Monday, June 3, 2019 1:24 PM

All replies

  • Hi Nandan,

    Azure SQL Database and Azure SQL Data Warehouse expose audit events through Azure Monitor logs (link). This will need to be set-up before these events can be captured. Do you already have this set-up?


    Thursday, June 6, 2019 6:55 PM