Default report to show all servers that have collection maintenance windows:

for cross checking servers in multiple maintenance windows

Below is query help to find set Maintenance windows for all the server.

List Computers with Maintenance Window:

SELECT sw.Name AS [MW Name], sw.Description,

sw.StartTime,

sw.Duration AS Duration Minutes,

sw.IsEnabled AS MW Enabled,

sys.Name0 AS ServerName,

sys.Operating_System_Name_and0 AS OperatingSystem

FROM dbo.v_ServiceWindow AS sw INNER JOIN

dbo.v_FullCollectionMembership AS fcm ON sw.CollectionID = fcm.CollectionID

INNER JOIN dbo.v_R_System sys ON fcm.ResourceID = sys.ResourceID

WHERE (sys.Operating_System_Name_and0 LIKE server%)

ORDER BY [MW Name], sys.Name0

Output will be:

Happy Learning!!!

Thanks&regards,
Haresh Hirani
Email: [email protected], [email protected]
Facebook https://www.facebook.com/Hiraniconfigmgr-120189361980772/
Follow us: https://www.linkedin.com/in/hiraniconfigmgr 
Twitter: https://twitter.com/hiraniconfigmgr