SCCM SQL query to report the number of updates installed on each machine

Posted on 2015-02-20
Last Modified: 2015-02-25
Hi guys, does anyone have a query that will count the number of windows updates installed on every machine?
Question by:amaru96
LVL 45

Accepted Solution

Vitor Montalvão earned 500 total points
ID: 40630872
I've found the following SELECT in this article:
SELECT COMP.Name0 AS 'Machine Name', COMP.UserName0 AS 'Username', COMP.Manufacturer0 AS 'Make', COMP.Model0 AS 'Model', 
COMP.SystemType0 AS 'Architecture', COMP.TotalPhysicalMemory0/1024 AS 'RAM', 
ARP.Publisher0 AS 'Publisher', ARP.DisplayName0 AS 'Program', ARP.Version0 AS 'Version', 
ARP.InstallDate0 AS 'Install Date', ARP.ProdID0 AS 'Product ID'
FROM v_Add_Remove_Programs ARP 

Open in new window


Author Comment

ID: 40632059
Thanks Vitor, I can make it work from that.

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Managing SQL log files, SQL Server 2014 6 56
Group by and order by clause 28 36
Slow SQL query 12 29
How toselect unique values 3 10
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now