Jump to content


  • 0
JimmyJ

SCCM2007: Report for specific rollup installed

Question

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

 

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

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.

Share this post


Link to post
Share on other sites

Join the conversation

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

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.