Hey, here’s Martin again.
\nDid you ever wanted to know, what the effective next maintenance window for a specific Computer in System Center 2012 Configuration Manager is? There isn’t a built-in Report, that will give you the infomation you are looking for. And if you would like to calculate for yourself, have fun, when your maintenence window was starting a year ago…
\nAfter a bit googling, a found this blog post, which describes the prcedure for SCCM 2007:
\nhttp:\/\/social.technet.microsoft.com\/wiki\/contents\/articles\/7870.sccm-2007-create-report-of-upcoming-maintenance-windows-by-client.aspx<\/p>\n
It will work, when you Change the following on the Report Query: -- All Service Windows for every resource and collection<\/p>\n SELECT fcm.ResourceID<\/p>\n , c.Name AS Collection<\/p>\n , nsw.Duration<\/p>\n , nsw.NextServiceWindow<\/p>\n , ROW_NUMBER() OVER (PARTITION BY ResourceID ORDER BY nsw.NextServiceWindow) AS RowNumber<\/p>\n FROM vSMS_ServiceWindow AS sw<\/p>\n JOIN v_FullCollectionMembership AS fcm<\/p>\n ON sw.SiteID = fcm.CollectionID<\/p>\n JOIN v_Collection AS c<\/p>\n ON sw.SiteID = c.CollectionID<\/p>\n CROSS<\/p>\n APPLY dbo.SCCM_GetNextServiceWindow(sw.Schedules, sw.RecurrenceType) AS nsw<\/p>\n )<\/p>\n SELECT sys.Name0 AS [Computer Name]<\/p>\n , sys.Distinguished_Name0 AS [AD DN]<\/p>\n , asw.Collection AS [Collection]<\/p>\n , CONVERT(CHAR(5), DATEADD(MINUTE, asw.Duration, 0), 108) AS [Duration (HH:MM)]<\/p>\n , CONVERT(CHAR(16), asw.NextServiceWindow, 120) AS [Next Maintenance Window]<\/p>\n , DATENAME(WEEKDAY, asw.NextServiceWindow) AS [Day of Week]<\/p>\n FROM v_R_System as sys<\/p>\n LEFT<\/p>\n JOIN AllServiceWindows AS asw<\/p>\n ON sys.ResourceID = asw.ResourceID<\/p>\n WHERE sys.Client0 = 1<\/p>\n AND asw.RowNumber = 1<\/p>\n ORDER<\/p>\n BY asw.NextServiceWindow<\/p>\n , asw.Collection<\/p>\n , sys.Name0<\/code> Hope this helps \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":" Hey, here’s Martin again. Did you ever wanted to know, what the effective next maintenance window for a specific Computer in System Center 2012 Configuration Manager is? There isn’t a built-in Report, that will give you the infomation you are looking for. And if you would like to calculate for yourself, have fun, when your […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-900","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts\/900","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=900"}],"version-history":[{"count":0,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts\/900\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n;WITH AllServiceWindows AS (<\/p>\n
\nYou have to Change the line “sys.description0 AS [Description]” because description0 does not longer exist in SCCM 2012. I just choose to Show the distinguished Name of the Computer object.<\/p>\n