SQL Command to Query System Center Configuration Manager

Learn to query System Center Configuration Manager (SCCM) patch status using SQL.

John Savill

December 16, 2013

1 Min Read
SQL Command to Query System Center Configuration Manager

Q: What SQL command can I use against the System Center Configuration Manager (SCCM) database to view all machines that require patches?

A: The SQL code below is based on the reports that are part of Configuration Manager, which will show machines that require patches.

 

selectb.Netbios_Name0 as Name,case a.Status when 2 then 'Required' when 3 then 'Installed' end as Status,c.ArticleID,c.daterevised as ReleasedDate,c.Titlefrom v_UpdateComplianceStatus as a, v_R_System as b, v_UpdateInfo as cwherea.ResourceID = b.ResourceID anda.CI_ID = c.CI_ID andc.ArticleID is not null anda.status = 2order by b.Netbios_Name0

 

About the Author

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like