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
Textbox2
#4c68a2
2pt
2pt
2pt
2pt
true
true
Bulletin ID
Textbox3
#4c68a2
2pt
2pt
2pt
2pt
true
true
Date Posted
Textbox5
#4c68a2
2pt
2pt
2pt
2pt
true
true
Display Name
Textbox7
#4c68a2
2pt
2pt
2pt
2pt
true
true
Informative URL
Textbox9
#4c68a2
2pt
2pt
2pt
2pt
true
true
Description
Textbox11
#4c68a2
2pt
2pt
2pt
2pt
0.25in
true
true
=Fields!ArticleID.Value
ArticleID
2pt
2pt
2pt
2pt
true
true
=Fields!BulletinID.Value
BulletinID
2pt
2pt
2pt
2pt
true
true
=Fields!DatePosted.Value
DatePosted
2pt
2pt
2pt
2pt
true
=Fields!DisplayName.Value
DisplayName
2pt
2pt
2pt
2pt
true
=Fields!CIInformativeURL.Value
CIInformativeURL
=Fields!CIInformativeURL.Value
2pt
2pt
2pt
2pt
true
=Fields!Description.Value
Description
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")
Title
ReportTitle
0.4in
14.21875in
1
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
String
Update Group
UpdateGroups
ID
Title
True
Inch
http://zapdsqlsccm01/ReportServer
19e4da3b-8967-4da7-8151-5d7e70e69d17