Show Maintenance Windows for a Computer

The following SQL query displays a list of maintenance windows for a given computer (SCCM client). Computer name in this example is ‘Computer1’.

SELECT FCM.Name AS 'Client Name', C.Name AS 'Collection Name', SW.CollectionID, SW.Name, SW.Description, SW.StartTime, SW.Duration, SW.IsEnabled 
FROM v_ServiceWindow SW
JOIN v_Collection C ON C.CollectionID = SW.CollectionID
JOIN v_FullCollectionMembership FCM ON FCM.CollectionID = C.CollectionID
WHERE FCM.Name IN ('Computer1')
ORDER BY FCM.Name 

Output will display the following output. Note, duration is displayed in terms of minutes.

maintwin1