Skip to content

SCCM2007: Report for specific rollup installed

Featured Replies

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

 

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.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.