question

Venugopal-1631 avatar image
0 Votes"
Venugopal-1631 asked GeethaThatipatri-MSFT edited

How to send email if any changes made in audit logs in SQL Server Azure

Hi Folks,

I am Having AuditLog table in SQL Server.(Azure Pipeline). i have below table which having auditing info. Now every day my Auditlog table is recording mutliple events. i want to send an email on every load. i have loaded multiple file that info has to send it in email.

Please help me any best way other than triggers.

Thank you.



202372-image.png


sql-server-transact-sqlazure-purview
image.png (3.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

You can create a SQL query that should return the changes made to the Audit Log over the last (hour, minutes, day) and send the results as HTML using a Logic App. You can use this article to create your Logic App.

Here you will find how to schedule your Logic App using Azure Data Factory pipeline.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.