Hi, Jruiz
You should be able to create a report with your query when combining it with a PowerShell runbook, to generate and email the report.
Or you can use a Azure Logic App to trigger the report on a schedule and send to email- https://learn.microsoft.com/en-us/azure/governance/resource-graph/tutorials/logic-app-calling-arg