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…