Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2015-02-20
2
Medium Priority
?
2,218 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 52

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
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 …
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

916 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