Configuration Manager ships with a built-in report showing maintenance windows for a single computer. I have just done a few modifications to that report (added a few columns and removed the prompt).
SELECT TOP (100) PERCENT sw.Name AS [MW Name], sw.Description, sw.StartTime, sw.Duration AS 'Duration Minutes', sw.IsEnabled AS 'MW Enabled',
dbo.v_R_System.Name0, dbo.v_R_System.Operating_System_Name_and0
FROM dbo.v_ServiceWindow AS sw INNER JOIN
dbo.v_FullCollectionMembership AS fcm ON sw.CollectionID = fcm.CollectionID INNER JOIN dbo.v_R_System ON fcm.ResourceID = dbo.v_R_System.ResourceID
WHERE (dbo.v_R_System.Operating_System_Name_and0 LIKE '%server%')
ORDER BY [MW Name], dbo.v_R_System.Name0

This post was originally posted to http://agerlund.spaces.live.com/blog/cns!3A51A2B50B5C1F51!646.entry May 19-2009
Posted
07-09-2009 21:11
by
Kent Agerlund