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
Textbox2
#4c68a2
2pt
2pt
2pt
2pt
true
true
KB Number
Textbox3
#4c68a2
2pt
2pt
2pt
2pt
true
true
Superseded
Textbox5
#4c68a2
2pt
2pt
2pt
2pt
true
true
Title
Textbox7
#4c68a2
2pt
2pt
2pt
2pt
true
true
Info URL
Textbox9
#4c68a2
2pt
2pt
2pt
2pt
0.25in
true
true
=Fields!Name0.Value
Name0
2pt
2pt
2pt
2pt
true
true
=Fields!KB_Number.Value
KB_Number
2pt
2pt
2pt
2pt
true
true
=Fields!Superseded.Value
Superseded
2pt
2pt
2pt
2pt
true
true
=Fields!Title.Value
Title
2pt
2pt
2pt
2pt
true
true
=Fields!InfoURL.Value
InfoURL
2pt
2pt
2pt
2pt
After
Patches
0.4in
0.5in
9.61458in
true
true
Outstanding updates on a system
Title
ReportTitle
0.4in
7.8625in
1
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
String
Update Group
UpdateGroups
ID
Title
String
System Name
Inch
http://zapdsqlsccm01/ReportServer
c69d1c04-dc4d-4044-a8c0-ea87cfc6d700