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:
- SCCM SQL Query to list Desktop & Laptop Devices
- SCCM SQL Query for Windows 10 / 11 Version Summary
- SQL Query to Get Maintenance Window for member of specific collection | SCCM
- Understanding SCCM SQL Views
- SCCM Collection Queries for System Resource (SMS_R_System) Attribute Class
Subscribe to Techuisitive Newsletter
Be the first to know about our new blog posts. Get our newsletters directly in your inbox and stay up to date about Modern Desktop Management technologies & news.
