Send Azure Metrics chart by email - by any means

Question

I manually email out a screenshot of a line chart from the Azure portal (expressroute circuit / metrics / avg bitsinpersecond). Is there any way I can get this to email out automatically on a schedule, or if not, then use Powershell AzureRM or Az CLI to pull the data and produce a chart? From googling I see people recommend NPM but I think that's a bit heavy for my needs here.

Thanks in advance

Answer 1

While not using PowerShell or CLI, with Logic Apps you can get a chart from Azure Monitor using the Azure Monitor Logs Connector. For this I believe, you would have to first setup the Express Route related Solution to Azure Monitor.

Here is an awesome blog that covers creating a Logic App using these connectors. You would have to change the queries to fetch metrics for your express route resource.