Query to Find Collections With Maintenance Windows

 Run this query against the SCCM site database using SQL Server Management Studio.

SELECT c.Name, c.Comment,SW.Description, SW.StartTime, SW.Duration FROM v_ServiceWindow SW JOIN v_Collection C ON C.CollectionID = SW.CollectionID ORDER BY c.Name