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…

Show TPM Values

Version: SCCM 2012 R2 CU2 To create a report showing Trusted Platform Module Values or TPM Values, there are a few things that should be completed in advance. 1. Enable TPM in the BIOS – Machines should have the TPM values enabled in the BIOS either by doing this manually or using a vendor tool (for example…

Monitor for Pending Reboots

Version: SCCM 2012 R2 I recently came across an issue with an existing report that showed systems that were pending a reboot. I was using this report here -> “Show Pending System Restart Clients for Software Updates“. However, the issue I came across was after a synchronization of the SUP with Microsoft, the systems would go…

Show Disk Usage

Version: SCCM 2012 R2 I was recently asked to calculate disk usage for machines in our environment. By default, SCCM inventories (via Hardware Inventory) size for logical disks. However, it does not calculate disk usage. To obtain disk usage, simply enable the Free Space setting for Hardware Inventory. And then perform the necessary disk usage calculation…

Show Servers Ordered by Last Boot Up Time

Version: SCCM 2012 R2 This query will show machines running server operating systems ordered by the last boot up time. In addition, this will flag systems that have not rebooted in over 12 months, 6 months, and 3 months. This query can be revised easily to show any number of thresholds using the datediff function and…