SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

Patch compliance progression report

select

      CS.Name0,

      CS.UserName0,

case

when (sum(case when UCS.status=2 then 1 else 0 end))>0 then ('Needs '+(cast(sum(case when UCS.status=2 then 1 else 0 end)as varchar(10))+ ' Patches'))

else 'Good Client'

end as 'Status',

      ws.lasthwscan as 'Last HW scan',

      FCM.collectionID--,

from

      v_UpdateComplianceStatus UCS

left outer join dbo.v_GS_COMPUTER_SYSTEM  CS on CS.ResourceID = UCS.ResourceID

join v_CICategories_All catall2 on catall2.CI_ID=UCS.CI_ID

join v_CategoryInfo catinfo2 on catall2.CategoryInstance_UniqueID = catinfo2.CategoryInstance_UniqueID and catinfo2.CategoryTypeName='UpdateClassification'

left join v_gs_workstation_status ws on ws.resourceid=CS.resourceid

left join v_fullcollectionmembership FCM on FCM.resourceid=CS.resourceid

Where

      UCS.Status = '2'

and FCM.collectionid = 'SMS00001'

Group by

      CS.Name0,

      CS.UserName0,

      ws.lasthwscan,

      FCM.collectionID

Order by

      CS.Name0,

      CS.UserName0,

      ws.lasthwscan,

      FCM.collectionID

Published Feb 25 2009, 03:07 PM by Garth
Filed under: , , ,

Comments

 

Garth Jones said:

Do you go to User Group event? Have you gone out for pints afterwards? Did you know some of the best

March 28, 2009 10:23 AM
 

Garth Jones at myITforum.com said:

Do you go to User Group event? Have you gone out for pints afterwards? Did you know some of the best

March 28, 2009 11:02 AM
 

Enhansoft said:

Patch compliance progression report

September 19, 2011 7:08 PM
 

SCCM – Security updates Compliance Overview report « Knowledge Is Power said:

Pingback from  SCCM – Security updates Compliance Overview report « Knowledge Is Power

March 14, 2012 1:13 PM
 

Sccm – Security updates compliance status by collection said:

Pingback from  Sccm – Security updates compliance status by collection

March 14, 2012 1:38 PM
 

Sccm – Security updates compliance status by collection said:

Pingback from  Sccm – Security updates compliance status by collection

March 14, 2012 1:38 PM

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems