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.
Learn to query System Center Configuration Manager (SCCM) patch status using SQL.
December 16, 2013
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
You May Also Like