Logic App to email reports on backup policy adherence
This template deploys a Logic App that sends periodic reports on backup policy adherence to a specified set of email addresses. The Logic App runs a set of queries on a specified set of Log Analytics workspaces and exports the returned data as inline charts and CSV attachments.
The Policy Adherence views allow you to easily determine whether all your backup instances have had atleast one successful backup per day. There are 2 axes available for analysis:
Policy Adherence by Time Period
Using this view, you can identify the number of backup instances that had atleast one successful backup per day on each day/week/month, as well as the number of backup instances which did not have one successful backup per day. Separate views are displayed for items with daily backup policy and items with weekly backup policy.
Policy Adherence by Backup Instances
Using this view, you can identify the days/weeks on which each backup instance did not have a successful backup. A cell containing '0' indicates that the backup instance did not have a successful backup on that day/week (depending on whether the item is configured for daily backup/weekly backup), while a cell containing '1' indicates that the item had atleast one successful backup in that period. Separate views are displayed for items with daily backup policy, and items with weekly backup policy.
Learn more about Backup Reports
Tags: Microsoft.Web/connections, Microsoft.Logic/workflows, Recurrence, Foreach, AppendToStringVariable, If, ApiConnection, InitializeVariable, string, array, Scope, Table, SetVariable, Microsoft.OperationalInsights/workspaces