Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2015-02-20
2
Medium Priority
?
2,357 Views
Last Modified: 2015-02-25
Hi guys, does anyone have a query that will count the number of windows updates installed on every machine?
0
Comment
Question by:amaru96
2 Comments
 
LVL 53

Accepted Solution

by:
Vitor Montalvão earned 2000 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 
JOIN v_GS_COMPUTER_SYSTEM COMP on ARP.ResourceID = COMP.ResourceID

Open in new window

0
 
LVL 1

Author Comment

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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

581 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