krishnamoorthy

Hi, Some computers compliance reports are empty and QFE part also shows SID. I uninstall and re install the SCCM client and rebuild the WMI repository also. please help.

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.