Lists all maintenance windows by collection, type and name. For filtering wildcards "*" must be used. By default all maintenance windows will be displayed. Popovici Ioan @ SCCM-Zone.com 0 /ConfigMgr_A01/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602} None 33f94ec3-1e39-4466-a6ee-65619da20a87 DataSource =Parameters!UserSIDs.Value /* ********************************************************************************************************* * Requires | SQL, SCCM DB * * ===================================================================================================== * * Modified by | Date | Revision | Comments * * _____________________________________________________________________________________________________ * * Ioan Popovici | 2016-05-16 | First version * * Ioan Popovici | 2018-08-21 | Added localizations, interactive sorting, updated template * * Ioan Popovici | 2018-08-24 | Added filters for collection name and maintenance window name * * ===================================================================================================== * * * ********************************************************************************************************* .SYNOPSIS This SQL Query is used to get the Maintenance Windows. .DESCRIPTION This SQL Query is used to get the Maintenance Windows for the whole SCCM environment with Start Time and Duration. .NOTES Part of a report should not be run separately. .LINK https://SCCM-Zone.com https://github.com/Ioan-Popovici/SCCMZone */ /*##=============================================*/ /*## QUERY BODY */ /*##=============================================*/ SELECT Collection.Name AS Collection, ServiceWindow.Name, ServiceWindow.Description, CASE ServiceWindow.ServiceWindowType WHEN 1 THEN 'All Deployments' WHEN 2 THEN 'Programs' WHEN 3 THEN 'Reboot Required' WHEN 4 THEN 'Software Updates' WHEN 5 THEN 'Task Sequences' WHEN 6 THEN 'User Defined' END AS Type, ServiceWindow.StartTime, ServiceWindow.Duration, CASE ServiceWindow.IsEnabled WHEN 1 THEN 'Yes' ELSE 'No' END AS Enabled FROM dbo.fn_rbac_ServiceWindow(@UserSIDs) AS ServiceWindow JOIN v_Collection AS Collection ON Collection.CollectionID = ServiceWindow.CollectionID ORDER BY Name /*##=============================================*/ /*## END QUERY BODY */ /*##=============================================*/ true Collection System.String Name System.String Description System.String Type System.String StartTime System.DateTime Duration System.Int32 Enabled System.String DataSource =Parameters!UserTokenSIDs.Value /* Get UserSID */ SELECT dbo.fn_rbac_GetAdminIDsfromUserSIDs (@UserTokenSIDs) AS UserSIDs true UserSIDs System.String DataSource =Parameters!ReportName.Value /* ReportDescription Dataset */ SELECT DISTINCT Description FROM ReportServer.dbo.Catalog WHERE Name = @ReportName Description System.String 92.10864mm 72.76041mm 42.38625mm 27.35846mm 25.37992mm 19.31458mm 6.80433mm true =Fields!Name.Value true =SrsResources.Localization.GetString("Name", User!Language) #4c68a2 Middle 2pt 2pt 2pt 2pt true =Fields!Description.Value true =SrsResources.Localization.GetString("Description", User!Language) #4c68a2 Middle 2pt 2pt 2pt 2pt true =Fields!StartTime.Value true =SrsResources.Localization.GetString("StartTime", User!Language) #4c68a2 Middle 2pt 2pt 2pt 2pt true =Fields!Duration.Value true =SrsResources.Localization.GetString("Duration", User!Language) #4c68a2 Middle 2pt 2pt 2pt 2pt true =Fields!Enabled.Value true =SrsResources.Localization.GetString("Enabled", User!Language) #4c68a2 Middle 2pt 2pt 2pt 2pt true =Sum(Count(Fields!Name.Value)) Collection true =SrsResources.Localization.GetString("Total", User!Language) #4c68a2 Middle 2pt 2pt 2pt 2pt 6.80433mm true true =Fields!Name.Value #e6eefc Middle 2pt 2pt 2pt 2pt true true =Fields!Description.Value #e6eefc Middle 2pt 2pt 2pt 2pt true true =Fields!StartTime.Value #e6eefc Middle 2pt 2pt 2pt 2pt true true =Fields!Duration.Value #e6eefc Middle 2pt 2pt 2pt 2pt true true =Fields!Enabled.Value #e6eefc Middle 2pt 2pt 2pt 2pt true true Textbox8 #e6eefc Middle 2pt 2pt 2pt 2pt 6.80433mm true true #c6daf8 2pt 2pt 2pt 2pt true true #c6daf8 2pt 2pt 2pt 2pt true true #c6daf8 2pt 2pt 2pt 2pt 3 true true =Count(Fields!Name.Value) #c6daf8 2pt 2pt 2pt 2pt 6.35mm true true SkyBlue 2pt 2pt 2pt 2pt true true SkyBlue 2pt 2pt 2pt 2pt true true SkyBlue 2pt 2pt 2pt 2pt 3 true true =CountDistinct(Fields!Name.Value) SkyBlue 2pt 2pt 2pt 2pt 6.80433mm true true #7292cc Middle 2pt 2pt 2pt 2pt true true #7292cc Middle 2pt 2pt 2pt 2pt true true #7292cc Middle 2pt 2pt 2pt 2pt 3 true true =Count(Fields!Name.Value) #7292cc Middle 2pt 2pt 2pt 2pt 112.69088mm true =Fields!Collection.Value Collection true =SrsResources.Localization.GetString("Collection", User!Language) #4c68a2 Middle 2pt 2pt 2pt 2pt 39.42291mm true =Fields!Type.Value Type true =SrsResources.Localization.GetString("Type", User!Language) #4c68a2 Middle 2pt 2pt 2pt 2pt =Fields!Collection.Value =Fields!Collection.Value =Fields!Type.Value 112.69088mm true true =Fields!Collection.Value SkyBlue Top 2pt 2pt 2pt 2pt =Fields!Type.Value StartAndEnd =Fields!Type.Value 39.42291mm true true =Fields!Type.Value #c6daf8 Top 2pt 2pt 2pt 2pt =Fields!Name.Value =Fields!Description.Value =Fields!StartTime.Value =Fields!Duration.Value =Fields!Enabled.Value true TV_Type true TV_Collection 39.42291mm true true SkyBlue 2pt 2pt 2pt 2pt 112.69088mm true true Total #7292cc Middle 2pt 2pt 2pt 2pt 39.42291mm true true #7292cc Middle 2pt 2pt 2pt 2pt MaintenanceWindowData =Fields!Collection.Value Like =Parameters!FilterCollectionName.Value =Fields!Name.Value Like =Parameters!FilterMWName.Value 12.76107mm 0.9525mm 33.56732mm 431.42205mm 1.47018in 8.34071in 0.4in true true =SrsResources.Localization.GetString("Description", User!Language) 2pt 2pt 2pt 2pt true true =SrsResources.Localization.GetString(Fields!Description.Value, User!Language) 5pt 2pt 2pt 2pt ReportDescription 0.03157in 0.127cm 0.4in 9.81089in 1 0.45796in 0.0375in 0in 16.98512in 2 1.5pt White 1.5pt White 1.5pt White 1.5pt White 1.5pt 4.72533cm #6e7b8b 43.33153cm 2.5333cm true true Embedded Logo FitProportional 0.05723in 0.12701cm 0.49111in 1.47018in 0.6007in 0.0375in 0in 16.98512in 1 0.75pt White 0.75pt White 0.75pt White 0.75pt White 0.75pt true true =SrsResources.Localization.GetString(Globals!ReportName, User!Language) 1.63513cm 0.12701cm 0.89817cm 24.91965cm 2 Middle 2pt 2pt 2pt 2pt #6e7b8b 0.77603cm true true true true ="Page: " + Globals!PageNumber.ToString() + "of " + Globals!TotalPages.ToString() 0.03528cm 0.03175cm 0.63492cm 2.79292cm #6e7b8b 29.7cm 21cm 2.54cm 2.54cm 2.54cm 2.54cm 1.27cm