How to find clients with no Maintenance Window defined

Use the following query in ConfigMgr Report to find the list of clients that do not have any Maintenance Window defined.

SELECT sys.Name0 'Name', v_R_System.Operating_System_Name_and0 'Operating System'
FROM v_ServiceWindow AS sw
INNER JOIN v_FullCollectionMembership AS fcm ON sw.CollectionID = fcm.CollectionID
RIGHT JOIN v_R_System AS sys ON fcm.ResourceID = sys.ResourceID
WHERE sw.Name is NULL AND sys.Client0 = 1
ORDER BY sys.Name0


Post a Comment