Overall Patch summary report

[krishnamoorthy]

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.

[Eswar Koneti]

Take a look at this blog .It might help you http://eskonr.com/20...plified-manner/