Count OS Versions by Servers and Workstations

Version: SCCM 2012 SP1 CU2 If you need to count the versions of operating systems without getting edition specific, use this SQL query. This will provide counts grouping the operating system by workstations and servers and then versions. This particular SQL query looks for versions ranging from XP/WS2003 Server to W8.1/WS2012R2. select TYPE, OS, Sum(Count) as…

Show Software Update Activity for a Computer

Version: SCCM 2012 SP1 CU2 This will generate a list of software update activity for a given computer. This may be helpful when troubleshooting and you need to know which software updates were recently installed. The results are displayed chronologically showing the most recent activity at the top. If you are running this in SQL Management Studio,…

Count Versions of Internet Explorer Browsers

Version: SCCM 2012 SP1 CU2 If you need to count the versions of Internet Explorer, this may be challenging. Native versions of Internet Explorer are not registered under Programs and Features because it was never installed. It came native with the operating system. As a result, you can’t run a report on installed programs which…

Count Software by Prompting for Display Name

Version: SCCM 2012 SP1 CU2 There may be times when you are asked to create a static report to count a specific software on workstations, servers, or both. You can create a dynamic report that will accept as input the display name. The following are SQL query examples to view software by specific display names (titles) using wildcards if necessary.…

Show “Pending System Restart” Clients for Software Updates

Version: SCCM 2012 SP1 CU2 Update as of July 6, 2014: A different report using a more reliable approach has been created using Compliance Settings -> Monitor for Pending Reboot These reports shows all SCCM clients running server or workstation operating systems and having atleast one software update deployment that indicates a status of “pending…