Send weekly reports from log analytics and Azure monitor in email

Question

Hello,

I have installed Azure Monitor and Log Analytics workspace. I am also able to gather user data by configuring various queries in the workbook. However, along with the queries in Log Analytics workspace, client also needs a weekly email sent to them like a weekly report of , say all users logged in from a specific location. I can write the query to get that data. But how to send that as a report in email? Do we need a reporting tool like BI publisher etc?

Thanks.

Answer 1

You could use PowerShell to write the reports as HTML and send it via an email service like Sendgrid.

• https://4sysops.com/archives/building-html-reports-in-powershell-with-convertto-html/
• https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/convertto-html?view=powershell-7.3
• https://www.sharepointdiary.com/2015/06/send-mailmessage-powershell-body-html-format.html

Answer 2

There are various examples available for using a logic app to send reports. Here is one example. https://learn.microsoft.com/en-us/azure/azure-monitor/alerts/alerts-logic-apps?tabs=send-email