Tag: SU

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 […]