While a maintenance window is active, the maintenance metadata it adds to telemetry and events lets you filter views, refine automation, and audit what happened during planned work. This page shows you how to query maintenance data directly with DQL.
Query maintenance events and enriched telemetry directly in Grail with DQL to gather data for custom dashboards, availability reports, and audits.
View all executions from a recurring maintenance window:
fetch dt.maintenance.windows| filter dt.settings.object_id == "<MAINTENANCE_WINDOW_OBJECT_ID>"| sort timestamp desc
fetch dt.davis.problems| filter maintenance.is_under_maintenance == true
fetch dt.davis.events| filter maintenance.is_under_maintenance == true
timeseries avg_availability = avg(dt.host.maintenance), by:{host.name}, filter: maintenance.is_under_maintenance == true| summarize by:{host.name}, sum(1)