Next Maintenance Dates from the Maintenace Configuration's Schedule using KQL

Hi Raghav Manchanda

Thanks for posting your question in Microsoft Q&A forum

Azure Resource Graph exposes maintenance events and update schedules through resources like microsoft.maintenance/updates and microsoft.maintenance/configurationassignments. These include key schedule details such as start and end times, status, impact type, and notification ID. You can query these with KQL and even join them with VM or other resource information.

No, it's not possible, there isn’t a direct table showing Next Maintenance Dates; instead, the dates are stored in the JSON properties of maintenance resources. Using KQL, you can filter events by status (like Pending or InProgress) and parse the start and end times to identify upcoming maintenance windows. For Azure Update Manager maintenance configurations, schedule details such as recurrence and start date are contained within these JSON property fields.

You can get next maintenance dates by querying microsoft.maintenance/* resources in Azure Resource Graph and parsing the schedule JSON, since no direct date column exists.

Resources
| where type == "microsoft.maintenance/configurationassignments"
| extend propertiesJson = parse_json(properties)
| mv-expand schedules = propertiesJson.schedules
| extend scheduleStart = todatetime(schedules.startTimeUtc),
         scheduleEnd   = todatetime(schedules.expiryTimeUtc)
| where isnotempty(scheduleStart) and scheduleStart > now()
| project name, scheduleStart, scheduleEnd
| order by scheduleStart asc

Referral documents

• Sample Query Logs and Results from Azure Update Manager | Microsoft Learn
• Query Resources with Azure Resource Graph in Azure Update Manager | Microsoft Learn

I hope the provided answer is helpful, do let me know if you have any further questions on this Please accept as Yes and upvote if the answer is helpful so that it can help others in the community.