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.
0 comments:
Post a Comment