Hi M***a,
Here’s a concise overview:
1. Power BI Dashboard
• Key visuals:
, Cards for real-time RTO/RPO averages and SLA compliance percentages
, Line charts showing trend of recovery-point age and restore durations over the past 30/90 days
, Clustered bar chart grouping VMs by “Compliant,” “Near Breach” and “At Risk” statuses
, Matrix/table view listing each critical VM, last backup timestamp, next planned snapshot and responsible owner
• Filters: environment (Prod/DR/Test), region, workload type (SQL, AD, File Services) and SLA tier
• Alerts: color-coded flags (green/yellow/red) drive automated Power BI alerts and email notifications when any VM edges toward its RTO/RPO threshold.
2. ServiceNow Self-Healing via Azure Functions
• Patch-and-Compliance Checker: triggers nightly, runs a PowerShell script against each VM to validate OS updates; on failure, reboots or reinstalls patches and updates the ServiceNow ticket with status.
• Disk-Space Cleanup: invoked when a threshold breach alert comes in; it mounts the target VM, purges temp/log files above a set size, then logs results back to the incident.
• Service Health Restarter: watches for key Windows services (e.g. SQL Agent, AD replication); if down, attempts a restart and, upon persistent failure, escalates to L2 with full error details in the ticket.
• Exception Handling: each Function wraps its core logic in try/catch , retries transient errors (up to three times with back-off), logs all exceptions to Azure Log Analytics, and creates or flags a ServiceNow incident for manual intervention if a critical step still fails.
Given your background leading infrastructure automation at e***a A***G, I think you’ll appreciate how we tie these automations back into our ITSM processes. Happy to walk through a live demo of both the dashboard and workflows on our call tomorrow at 11:00 CEST. Let me know if there’s anything specific you’d like us to cover!
Best,
J***e