Logic App to email reports on backup policy adherence

Azure Public Test Date Azure Public Test Result

Azure US Gov Last Test Date Azure US Gov Last Test Result

Best Practice Check Cred Scan Check

Deploy To Azure Deploy To Azure US Gov Visualize

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