Mark D
-
Posts
1 -
Joined
-
Last visited
Everything posted by Mark D
-
Collection Query to find No Maintenance Window
Mark D replied to Lagamorph's topic in Configuration Manager 2012
SELECT sys.Name0 'Name', sys.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