Show Maintenance Windows for a Computer

The following SQL query displays a list of maintenance windows for a given computer (SCCM client). Computer name in this example is ‘Computer1’. SELECT FCM.Name AS ‘Client Name’, C.Name AS ‘Collection Name’, SW.CollectionID, SW.Name, SW.Description, SW.StartTime, SW.Duration, SW.IsEnabled FROM v_ServiceWindow SW JOIN v_Collection C ON C.CollectionID = SW.CollectionID JOIN v_FullCollectionMembership FCM ON FCM.CollectionID = C.CollectionID WHERE…

Show Windows Update Agent versions

This SQL query will count all WUA versions grouping by Server/Workstation platforms and WUA versions. WUA is the Windows Update Agent responsible for applying software updates on Windows systems. SELECT ‘Workstation’ as ‘Platform’, WUAV.Version0 as ‘Version’, count(sys.Netbios_Name0) as ‘Count’ FROM v_GS_WINDOWSUPDATEAGENTVERSION WUAV JOIN v_R_System Sys ON WUAV.ResourceID = Sys.ResourceID join v_GS_SYSTEM S on S.ResourceID=WUAV.ResourceID WHERE WUAV.Version0…

Enable Interactive Sorting in Reports

Using Report Builder 3.0, this is a way to enable interactive sorting. This allows the viewer of the report to interactively sort columns either in ascending or descending order. While in design mode, right-click the text box containing the column name and select “text box properties”. Once the property dialog window is open, click on “Interactive Sorting”. Place a…