SCCM2007: Report for specific rollup installed

[JimmyJ]

I'm looking to get a report/query for all machines that have a specific KB installed. I've found a few that give me reports for updates, will those cover the rollups as well?

 

This is what I have so far - will QNumber give me a report on rollups as well? Specifically looking to report on "kb2992020"

 

select summ.ID,summ.QNumbers as 'Q Number',

COUNT(distinct ps.ResourceID) as 'Requested',

COUNT(distinct case when ps.LastState=107 or ps.laststate=102 or

ps.laststate=105 then ps.ResourceID else NULL End) as 'Installed',

ROUND(100.0*COUNT(distinct case when ps.LastState=107 or ps.laststate=102 or

ps.laststate=105 then ps.ResourceID else NULL End)

/count(distinct ps.ResourceID),2) as 'Success %'

from v_GS_PatchStatusEx ps

join v_ApplicableUpdatesSummaryEx summ on

ps.UpdateID=summ.UpdateID

where (summ.QNumbers like '%2992020%')

group by summ.ID,summ.QNumbers

order by summ.ID

 

[Peter van der Woude]

If it's not a "standard" update then you can get that information on a client via Win32_QuicFixEngeneering. To get that information you can extend your hardware inventory. In case you don't want all that information on your server you can also use DCM to run the check on the client and only report the results.

[GarthMJ]

So it is unclear to me does this query work for you or not?