Report for software update article ID

SELECT

DISTINCT

UI

.BulletinID as ‘BulletinID’,

UI

.ArticleID as ‘ArticleID’,

UI

.Title as ‘Title’, ‘Deployed’ = (case when CTM.ResourceID is not null then ‘Yes’ else ‘No’ end),

UI

.InfoURL as ‘URL’,

UI

.CI_UniqueID as ‘Unique ID’

FROM

v_UpdateComplianceStatus UCS

join v_UpdateInfo UI on UI.CI_ID = UCS.CI_ID join v_R_System SYS on UCS.ResourceID = SYS.ResourceID join v_ClientCollectionMembers CCM on CCM.ResourceID = SYS.ResourceID left join v_CITargetedMachines CTM on CTM.CI_ID=UCS.CI_ID and CTM.ResourceID = UCS.ResourceID

WHERE

UCS

.Status=2 and SYS.Name0 = @ComputerName

ORDER

BY

UI

.BulletinID DESC

Leave a Reply

Your email address will not be published. Required fields are marked *