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'
,'Check' = (
(case when UI.IsSuperseded = 1 then 'Superseded' else '' end)
+
(case when UI.IsSuperseded + UI.IsExpired = 2 then ' & ' else '' end)
+
(case when UI.IsExpired = 1 then 'Expired' else '' end)
)
,ui.Title
,ui.InfoURL
,stuff ((Select ', ' + UI2.Title
From v_CIRelation_All CR
left join v_UpdateInfo UI1 on UI1.CI_ID = CR.ReferencedCI_ID
left join v_UpdateInfo UI2 on UI2.CI_ID = CR.CI_ID
where RelationType=6
and UI1.IsSuperseded = 1
and UI1.CI_ID = UI.CI_ID
Order by UI2.ArticleID asc
for XML path ('')), 1, 2,'') as 'Superseeded by'
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
Check
System.String
Title
System.String
InfoURL
System.String
Superseeded by
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.65833in
5.5125in
2.42917in
4.26042in
0.25in
true
true
Name0
Textbox2
#4c68a2
2pt
2pt
2pt
2pt
true
true
KB Number
Textbox3
#4c68a2
2pt
2pt
2pt
2pt
true
true
Super or Exp Check
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
true
true
Superseeded by
Textbox11
#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!Check.Value
Check
2pt
2pt
2pt
2pt
true
=Fields!Title.Value
Title
2pt
2pt
2pt
2pt
true
=Fields!InfoURL.Value
InfoURL
=Fields!InfoURL.Value
2pt
2pt
2pt
2pt
true
=Fields!Superseeded_by.Value
Superseeded_by
2pt
2pt
2pt
2pt
After
Patches
0.4in
0.5in
17.36458in
true
true
Outstanding updates on a system
Title
ReportTitle
0.4in
10.675in
1
2pt
2pt
2pt
2pt
1in
17.36458in
0.45in
true
true
true
true
=Globals!ExecutionTime
ExecutionTime
0.2in
5.1625in
0.25in
5.5125in
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