Wednesday, June 3, 2026
type here...
DeploymentPatch Management

List all Servers with Maintenance Windows

By Haresh Hirani
0
701

Default report to show all servers that have collection maintenance windows:

for cross checking servers in multiple maintenance windows

Below is query help to find set Maintenance windows for all the server.

List Computers with Maintenance Window:

SELECT sw.Name AS [MW Name], sw.Description,

sw.StartTime,

sw.Duration AS Duration Minutes,

sw.IsEnabled AS MW Enabled,

sys.Name0 AS ServerName,

sys.Operating_System_Name_and0 AS OperatingSystem

FROM dbo.v_ServiceWindow AS sw INNER JOIN

dbo.v_FullCollectionMembership AS fcm ON sw.CollectionID = fcm.CollectionID

INNER JOIN dbo.v_R_System sys ON fcm.ResourceID = sys.ResourceID

WHERE (sys.Operating_System_Name_and0 LIKE server%)

ORDER BY [MW Name], sys.Name0

Output will be:

Happy Learning!!!

Thanks&regards,
Haresh Hirani
Email: [email protected], [email protected]
Facebook https://www.facebook.com/Hiraniconfigmgr-120189361980772/
Follow us: https://www.linkedin.com/in/hiraniconfigmgr 
Twitter: https://twitter.com/hiraniconfigmgr

Author

  • Hi, I’m Haresh Hirani the mind behind Hiraniconfigmgr.com. I’m a seasoned IT professional with deep expertise in Microsoft technologies, especially in Configuration Manager (ConfigMgr/SCCM). Over the years, I’ve expanded my skill set to cover a broader range of modern device management platforms like Microsoft Intune, Jamf Pro, ManageEngine Endpoint Central, and VMware AirWatch (Workspace ONE UEM), I use this blog to document real-world, tested, working fixes and walkthroughs from my daily technical experiences. The 💡idea is simple: if it helped me, it might help someone like you. My goal is to create a living repository of practical IT solutions for the community. If you find something useful, or if you want to collaborate, feel free to connect with me on LinkedIn or drop a message through the Contact page. Happy to help.

Previous article
All the system patches failed Failed to end search job Error 0x80244008
Next article
Deploying Store App on windows 10 using SCCM, Deployment is keep failing

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Search

Latest posts

I’m the person behind this webpage. Thank you for visiting the website and about me page! My website is all about Microsoft technologies. More about ConfigMgr and all other technologies which are interesting for me. However, larger percentage of my posts are related to SCCM. Normally, like to post the interesting issues which I came across in my day to day tech life. you will find only solutions which comes on my day to day life.

Hot Category

Popular Post

© COPYRIGHT Hiraniconfigmgr.com

Developed By : Deepcoder