Skip to content

Overall Patch summary report

Featured Replies

Hi All,

 

I have created the report for over all patch summary based on the below query.

 

select summ.ID,summ.title,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.Type='Microsoft Update')

group by summ.ID,summ.QNumbers,summ.title

order by summ.ID

 

 

The out put is

Update ID Title Q Number Requested Installed Success %

SQL Server 2005 Books Online (February 2007) 35 1 2.86

MS10-019 Security Update for Windows Server 2008 R2 x64 Edition (KB978601) 978601 131 81 61.83

 

 

 

 

My query is How to given the link based on the Requested and Installed PCs.For ex : how to given the link 35 ,1, 131 & 81.Given the all 35 requested PC if I click the 35.

post-9077-0-47215600-1301381741_thumb.jpg

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.