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…

SSRS Auditing

SQL 2008 R2 SSRS tracks report executions in the “ReportServer” database. Here a few queries that can be used on the “ReportServer” database to do auditing. This may be helpful if you need to collect auditing or reporting statistics. Who is using reports and how regularly? – This query counts the number of distinct executions by…

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…