SQL Query : All Updates for a Specific SUG

This query returns all updates in a specific Software Update Group (SUG)

select distinct
   upd.ArticleID,
   upd.BulletinID,
   upd.Severity
FROM vSMS_CIRelation as cr
   INNER JOIN fn_ListUpdateCIs(1033) upd ON upd.CI_ID = cr.ToCIID AND cr.RelationType = 1
   INNER JOIN v_CIToContent CC on cc.CI_ID=upd.CI_ID
   INNER JOIN v_AuthListInfo SUG ON SUG.CI_ID =cr.FromCIID
where SUG.title=''
order by ArticleID

 

Related posts

Leave a Comment