0 /ConfigMgr_P01/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602} None e9a2e480-e03e-49f4-9139-104bff57b15f DataSource1 SELECT TOP 10 AL.CI_ID as ID ,AL.Title as Title --,* FROM v_AuthListInfo AL where AL.CreatedBy <> 'AutoUpdateRuleEngine' ID System.Int32 Title System.String DataSource1 =Parameters!UpdateGroup.Value select 'KB'+upd.ArticleID as ArticleID ,upd.BulletinID ,upd.DatePosted --,upd.DateRevised --,upd.IsExpired --,upd.IsSuperseded --,upd.Description ,upd.DisplayName ,upd.CIInformativeURL ,upd.Description ,(Select top 1 al.Title FROM v_AuthListInfo AL where AL.CreatedBy <> 'AutoUpdateRuleEngine' and al.CI_ID=cr.FromCIID ) as 'Update Group' from vSMS_CIRelation as cr,fn_ListUpdateCIs(1033) as upd where (( -- Servers 16871299 -- Workstation 16872908 -- cr.FromCIID = 16871299 cr.FromCIID = @UpdateGroup --cr.FromCIID = @CI_ID AND cr.RelationType = 1) AND upd.CI_ID = cr.ToCIID) order by upd.DatePosted desc, upd.ArticleID desc ArticleID System.String BulletinID System.String DatePosted System.DateTime DisplayName System.String CIInformativeURL System.String Description System.String Update Group System.String 1in 1in 1.25in 2.5in 2.32292in 6.14583in 0.25in true true Article ID #4c68a2 2pt 2pt 2pt 2pt true true Bulletin ID #4c68a2 2pt 2pt 2pt 2pt true true Date Posted #4c68a2 2pt 2pt 2pt 2pt true true Display Name #4c68a2 2pt 2pt 2pt 2pt true true Informative URL #4c68a2 2pt 2pt 2pt 2pt true true Description #4c68a2 2pt 2pt 2pt 2pt 0.25in true true =Fields!ArticleID.Value 2pt 2pt 2pt 2pt true true =Fields!BulletinID.Value 2pt 2pt 2pt 2pt true true =Fields!DatePosted.Value 2pt 2pt 2pt 2pt true =Fields!DisplayName.Value 2pt 2pt 2pt 2pt true =Fields!CIInformativeURL.Value 2pt 2pt 2pt 2pt true =Fields!Description.Value 2pt 2pt 2pt 2pt After Updates_in_group =Fields!DatePosted.Value Descending 0.4in 0.5in 14.21875in true true Updates in Update Group =First(Fields!Update_Group.Value, "Updates_in_group") 2pt 2pt 2pt 2pt 1.04167in 14.21875in 0.45in true true true true =Globals!ExecutionTime ExecutionTime 0.2in 2in 0.25in 3.75in 2pt 2pt 2pt 2pt 1in 1in 1in 1in