In Configuration Manager, a Maintenance Window allow client configuration changes at specific time defined in Maintenance Window. You can use Maintenance Window to define when Configuration Manager can deploy software update , applications or other configuration change tasks.
The below SQL query will provide the details of Maintenance Window with collection name for all members in given collection. The SQL query can be executed from SQL Server Management Studio.
Remember to replace CollectionID in bold with actual Collection ID.
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.Collection inner join v_Collection col on col.CollectionID = sw.CollectionID
where fcm.name in (select name from v_FullCollectionMembership where collectionID = 'CollectionID')
Related Posts:
- How to Create Dynamic Collection in SCCM
- Enclosure Chassis Types Value & Description | ConfigMgr | SCCM
- ConfigMgr: Maintenance Window for member of specific collection – SQL Query
- SCCM Dynamic Collection for Windows 10 / 11 Devices
- SCCM Device Collection Equivalents in Microsoft Intune for App Deployment
- SCCM Dynamic Collection Based on Device Type | Collection Queries
- SCCM Collection Based on Operating System Optional Features
- SCCM Device Collection Based on Installed Software Products & Inventoried Files
- SCCM Device Collection Based on Computer Hardware Details
- SCCM Collection Queries for Opearting System Attribute Class
- SCCM Collection Queries for System Resource (SMS_R_System) Attribute Class
- SCCM Dynamic Collection using Application Deployment Status