Maintenance Windows Reporting in SCCM

Sometimes you just need all maintenance windows in one place…

🚨🚨 IMPORTANT NOTICE🚨🚨

🦄 We moved to our brand new blog at MEM.Zone 🦄

🚨🚨 IMPORTANT NOTICE🚨🚨

Report release history

There comes a time when you need to cleanup or view all maintenance windows for your environment. I had this for a while but realized only today that there is no builtin report that can show you all maintenance windows in SCCM. Without further ado…

Import the SSRS Report

• Download the report file

## Maintenance windows report
SD Maintenance Windows by Collection and Type

• Start Internet Explorer on and navigate to http://YOUR_REPORT_SERVER_FQDN/Reports
• Choose a path and upload the previously downloaded report files
• Replace the DataSource in the reports
• If you don’t add a logo, delete the placeholder on the top left.

Notes
This report was created with SQL 2014 Reporting Services, you might need to remove some report elements if you use an older version.

Report Query

For reference only, since the report includes this query.

Maintenance window report query

Report Preview

Maintenance windows report by collection and type with filters

Please use Github for 🐛 reporting and feature requests 🌈