0 /ConfigMgr_P01/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602} None 19c63d65-c292-4d14-892f-9a3c915323de DataSource1 =Parameters!SUGroup.Value =Parameters!SysName.Value select -- top 100 uc.ResourceID ,s.Name0 ,'KB' + ui.ArticleID 'KB Number' ,Superseded = (case when UI.IsSuperseded is not null then 'Superseded' else '' end) ,ui.Title ,ui.InfoURL from v_Update_ComplianceStatus UC inner join vSMS_CIRelation UR on UR.ToCIID = UC.CI_ID left join v_UpdateInfo UI on UI.CI_ID = UC.CI_ID left join v_CITargetedMachines TS on TS.CI_ID=UC.CI_ID and TS.ResourceID = UC.ResourceID join v_CICategories_All vnd on vnd.CI_ID=ui.CI_ID and vnd.CategoryTypeName='Company' join v_CICategories_All cls on cls.CI_ID=ui.CI_ID and cls.CategoryTypeName='UpdateClassification' left join v_R_System S on S.ResourceID = UC.ResourceID where -- UR.FromCIID = 16834166 UR.FromCIID = @SUGroup and UC.Status<>3 and UC.Status=2 -- and S.Name0 in ('ZA0001DVICTX401','ZA0001PDICTX501','ZA0001PDICTX551','ZA0001PDICTX601','ZA0001PDICTX602') and S.Name0 like @SysName Order by S.Name0, UI.ArticleID true ResourceID System.Int32 Name0 System.String KB Number System.String Superseded System.String Title System.String InfoURL System.String DataSource1 SELECT AL.CI_ID as ID ,AL.Title as Title --,* FROM v_AuthListInfo AL where AL.CreatedBy <> 'AutoUpdateRuleEngine' ID System.Int32 Title System.String 1.75208in 1.75208in 1.29375in 3.06458in 1.75208in 0.25in true true Name0 #4c68a2 2pt 2pt 2pt 2pt true true KB Number #4c68a2 2pt 2pt 2pt 2pt true true Superseded #4c68a2 2pt 2pt 2pt 2pt true true Title #4c68a2 2pt 2pt 2pt 2pt true true Info URL #4c68a2 2pt 2pt 2pt 2pt 0.25in true true =Fields!Name0.Value 2pt 2pt 2pt 2pt true true =Fields!KB_Number.Value 2pt 2pt 2pt 2pt true true =Fields!Superseded.Value 2pt 2pt 2pt 2pt true true =Fields!Title.Value 2pt 2pt 2pt 2pt true true =Fields!InfoURL.Value 2pt 2pt 2pt 2pt After Patches 0.4in 0.5in 9.61458in true true Outstanding updates on a system 2pt 2pt 2pt 2pt 2.25in 9.61458in 0.45in true true true true =Globals!ExecutionTime ExecutionTime 0.2in 4.79792in 0.25in 3.06458in 2pt 2pt 2pt 2pt 1in 1in 1in 1in