Is there a way to get an automated email with the report of an Azure Monitor Log query

Is there a possible way to get any automated way, say any integration of other Azure services are also fine - to get a downloaded report or something throught an email Say my log output looks like this, I want this to run everyday at a certain time and email me the results in a tabular form or something Sample Lof query

I havent got an idea regarding what to do, I can download it as an excel file, but I need some automated way of getting it in my mail as a report or something

You can use Logic apps for automation. Create a logic app with consumption plan.

You use "Schedule" connector's for "Recurrence" of the action automatically. You can add additional parameters to run at specific time.

From "Azure Monitor Logs" select "Run query and list results".

Select "Resource Type". I have selected Application Insights here. you can select as per your requirement where you want to run your KQL Query.

Sample log query

Select ** "Create HTML table"**. Next Action select "Compose".

Compose is used for styling the HTML table for sending in the mail

Compose:

<style>
Table {
  font-family: "Times New Roman", Times, serif;
  background-color: #ffffff;
  border-collapse: collapse;
  width: 100%;
}

Table td, Table th {
  border: 1px solid #ddd;
  padding: 4px 4px;
}

Table th {
  font-size: 16px;
  font-weight: bold;
  padding-top: 10px;
  padding-bottom: 10px;
  text-align: left;
  background-color: #4fb2f2;
  color: white;
}
</style>

Select "Send an Email v2": First Outputs value is from "Compose" and second Output is from "Create HTML table":

Result: You will get an email with the table in ascending order on timestamp.