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:

server-mw-output

Happy Learning!!!

Regards,

Haresh Hirani

 

Advertisements