SELECT sys.Name0 'Name', v_R_System.Operating_System_Name_and0 'Operating System'FROM v_ServiceWindow AS swINNER JOIN v_FullCollectionMembership AS fcm ON sw.CollectionID = fcm.CollectionIDRIGHT JOIN v_R_System AS sys ON fcm.ResourceID = sys.ResourceIDWHERE sw.Name is NULL AND sys.Client0 = 1ORDER BY sys.Name0
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.
2 comments:
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
change V_R_System.Op..... to sys.Operating_System_Name_and0
Post a Comment