0
/ConfigMgr_P01/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}
None
6c15f934-6507-4c5f-8ecb-f06cce02c3ed
DataSource1
SELECT
up.CI_ID
,'KB' + up.ArticleID as 'KB Article'
,up.BulletinID
,Product = stuff ((Select ', ' + d.CategoryInstanceName
From v_CICategoryInfo_All D
where CategoryTypeName = 'Product'
and D.CI_ID = up.CI_ID
for XML path ('')), 1, 2,''
)
,(Select top 1 d.CategoryInstanceName
From v_CICategoryInfo_All D
where CategoryTypeName = 'UpdateClassification'
and D.CI_ID = up.CI_ID
) as Classification
,Case when up.IsExpired = 0 then ''
Else 'Expired'
end as 'Expired'
,Case when up.IsSuperseded = 0 then ''
else 'Superseeded'
end as 'Superseeded'
,Case when up.CustomSeverity = 0 then ''
when up.CustomSeverity = 1 then '1'
when up.CustomSeverity = 2 then '2'
when up.CustomSeverity = 3 then '3'
end as 'Custom Severity'
,Case when up.CustomSeverity = 0 then ''
else 'Excluded'
end as 'Manual Exclusion'
,up.DateRevised as Date
,Comp.NumMissing as 'Required by Systems'
,'DM Collections' = stuff ((Select DISTINCT ', ' + cra.AssignmentName
from v_CIAssignmentToCI cr
Left Join vSMS_UpdateGroupAssignment cra on cra.AssignmentID = cr.AssignmentID
where cr.CI_ID = up.CI_ID
and cra.AssignmentName like 'DM Report %'
for XML path ('')), 1, 2,''
)
,up.Title
,up.InfoURL
,up.Description
FROM v_UpdateInfo UP
Left Join vUpdate_ComplianceSummary Comp on comp.CI_ID = UP.CI_ID
where CIType_ID <> '9'
--and up.ArticleID = '4013429'
order by Comp.NumMissing desc
true
CI_ID
System.Int32
KB Article
System.String
BulletinID
System.String
Expired
System.String
Product
System.String
Classification
System.String
Superseeded
System.String
Custom Severity
System.String
Manual Exclusion
System.String
Date
System.DateTime
Required by Systems
System.Int32
Title
System.String
DM Collections
System.String
InfoURL
System.String
Description
System.String
1in
1in
1.80208in
1.19792in
1in
1.14583in
0.85417in
0.88542in
1in
1in
3.13542in
2.25in
2.14583in
8.98958in
0.25in
true
true
KB Article
Textbox2
#4c68a2
2pt
2pt
2pt
2pt
true
true
Bulletin ID
Textbox3
#4c68a2
2pt
2pt
2pt
2pt
true
true
Product
Textbox25
#4c68a2
2pt
2pt
2pt
2pt
true
true
Classification
Textbox27
#4c68a2
2pt
2pt
2pt
2pt
true
true
Expired
Textbox5
#4c68a2
2pt
2pt
2pt
2pt
true
true
Superseeded
Textbox7
#4c68a2
2pt
2pt
2pt
2pt
true
true
Custom Severity
Textbox9
#4c68a2
2pt
2pt
2pt
2pt
true
true
Manual Exclusion
Textbox11
#4c68a2
2pt
2pt
2pt
2pt
true
true
Date
Textbox13
#4c68a2
2pt
2pt
2pt
2pt
true
true
System Requiring
Textbox15
#4c68a2
2pt
2pt
2pt
2pt
true
true
DM Deployments
Textbox23
#4c68a2
2pt
2pt
2pt
2pt
true
true
Title
Textbox17
#4c68a2
2pt
2pt
2pt
2pt
true
true
Info URL
Textbox19
#4c68a2
2pt
2pt
2pt
2pt
true
true
Description
Textbox21
#4c68a2
2pt
2pt
2pt
2pt
0.25in
true
true
=Fields!KB_Article.Value
KB_Article
2pt
2pt
2pt
2pt
true
true
=Fields!BulletinID.Value
BulletinID
2pt
2pt
2pt
2pt
true
=Fields!Product.Value
Product
2pt
2pt
2pt
2pt
true
=Fields!Classification.Value
Classification
2pt
2pt
2pt
2pt
true
true
=Fields!Expired.Value
Expired
2pt
2pt
2pt
2pt
true
true
=Fields!Superseeded.Value
Superseeded
2pt
2pt
2pt
2pt
true
true
=Fields!Custom_Severity.Value
Custom_Severity
2pt
2pt
2pt
2pt
true
true
=Fields!Manual_Exclusion.Value
Manual_Exclusion
2pt
2pt
2pt
2pt
true
true
=Fields!Date.Value
Date
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Required_by_Systems.Value)
Required_by_Systems
2pt
2pt
2pt
2pt
true
=Fields!DM_Collections.Value
DM_Collections
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!Description.Value
Description
2pt
2pt
2pt
2pt
After
All_Updates
=Fields!Required_by_Systems.Value
Descending
0.4in
0.5in
27.40625in
true
true
All Updates in SCCM system
Title
ReportTitle
0.4in
6in
1
2pt
2pt
2pt
2pt
0.97917in
27.40625in
0.45in
true
true
true
true
=Globals!ExecutionTime
ExecutionTime
0.2in
3.80208in
0.25in
2.19792in
2pt
2pt
2pt
2pt
1in
1in
1in
1in
Inch
http://zapdsqlsccm01/ReportServer
73568aa3-3926-4b68-9193-a1f67420bb3f