ssms audit for azure db

Anusha S Raj 21 Reputation points
2022-05-11T20:00:12.453+00:00

Hi,

I have an azure Database which did not have audit enabled. Is there any way I can get the user login history or audits from system views or tables?

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
710 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,380 questions
0 comments
Accepted answer
  1. GeethaThatipatri-MSFT 27,012 Reputation points Microsoft Employee
    2022-05-11T22:08:00.847+00:00

    Hi, @Anusha S Raj Welcome to Microsoft Q&A, Thanks for posting your query.
    Yes, you should be able to identify the specific query by providing the contains of the query in the 'statement' of Audit log fields by querying in log analytics.
    For more information on querying log analytics on where you can find sample codes, please go through the link below:

    AZURE SQL DB AND LOG ANALYTICS BETTER TOGETHER – PART #1 - Microsoft Tech Community

    To find more information regarding the Audit log fields please go through the link below:

    SQL Database audit log format - Azure SQL Database | Microsoft Learn

    Hope the above information helps.

    Please let me know if you are facing any issues,

    you can enable the option from the portal in server blade under security.

    201178-image.png

    Regards
    Geetha

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest