Configuration Manager - Maintenance Window for member of specific collection
The below SQL query will provide the details of Maintenance Window with collection name for all members in provided collection. select fcm.Name as 'Server Name',sw.CollectionID,col.Name as 'Collection Name',sw.Name as 'MW Name',sw.Description,sw.StartTime,sw.Duration,sw.IsEnabled from v_ServiceWindow SW inner join v_FullCollectionMembership fcm on fcm.CollectionID = sw.CollectionID inner join v_Collection col on col.CollectionID = sw.CollectionID where fcm.name in (select name from v_FullCollectionMembership where collectionID = ' CollectionID ')