Automation with KQL

[Jahirt_Ruiz_Vista]

Hello guys

I have a Function working that I need to run every 3 months, and send a Email with the result of the query...

How can I achieve that?, I read about Data Lake but it looks complicated. 

[#2 · Accepted solution]

Use a Logic App. Something similar to the following: https://azurecloudai.blog/2022/04/28/azure-sentinel-sending-an-email-each-morning-with-the-list-of-d...

[#3]

Thank you! I did something similar... with that base!

[#4]

I want to build the table in the body of the email but the query is dynamic, this leaves the use case. Is it necessary to send the result of the use case by mail, is this possible?