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®ards,
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
X
0 Comments
No Comments