Segoe UI
0
true
/ConfigMgr_CAS/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}
None
e23a8223-64e2-4b30-b002-4e82bfd40c81
DataSource
=Parameters!SUGroupName.Value
true
=Parameters!CollectionName.Value
Select
Vaa.AssignmentName as 'DeploymentName',
Right(Ds.CollectionName,3) as 'Stage',
Li.Title as 'SUGroupName',
CASE when Vaa.DesiredConfigType = 1 Then 'Install' when vaa.DesiredConfigType = 2 Then 'Uninstall' Else 'Others' End as 'DepType',
Ds.CollectionName as 'CollectionName',
CASE when Ds.DeploymentIntent = 1 Then 'Required' when Ds.DeploymentIntent = 2 Then 'Available' End as 'Purpose',
Ds.DeploymentTime as 'AvailableTime',
Ds.EnforcementDeadline as 'RequiredTime',
Ds.NumberTotal as 'Target',
Ds.NumberSuccess as 'Success',
Ds.NumberInProgress as 'Progress',
Ds.NumberErrors as 'Errors',
Ds.NumberOther as 'Others',
Ds.NumberUnknown as 'Unknown',
case when (Ds.NumberSuccess = 0) or (Ds.NumberSuccess is null) Then '0'
Else (round(Ds.NumberSuccess/ convert (float,Ds.NumberTotal)*100,2))
End as 'Success%',
DateDiff(D,Ds.DeploymentTime,
GetDate()) as 'AvailableDays',
DateDiff(D,Ds.EnforcementDeadline, GetDate()) as 'RequiredDays',
DateDiff(D,Ds.CreationTime, GetDate()) as 'CreatedDays',
Vaa.CreationTime as 'CreationTime',
Vaa.LastModificationTime as 'LastModifiedTime',
Vaa.LastModifiedBy as 'LastModifiedBy'
from v_DeploymentSummary Ds
left join v_CIAssignment Vaa on Ds.AssignmentID = Vaa.AssignmentID
left join v_AuthListInfo LI on LI.ModelID = Ds.ModelID
Where Ds.FeatureType = 5
and Li.Title = @SUGroupName and Ds.CollectionName = @CollectionName
order by Ds.DeploymentTime desc
true
DeploymentName
System.String
Stage
System.String
SUGroupName
System.String
DepType
System.String
CollectionName
System.String
Purpose
System.String
AvailableTime
System.DateTime
RequiredTime
System.DateTime
Target
System.Int32
Success
System.Int32
Progress
System.Int32
Errors
System.Int32
Others
System.Int32
Unknown
System.Int32
Success%
System.Double
AvailableDays
System.Int32
RequiredDays
System.Int32
CreatedDays
System.Int32
CreationTime
System.DateTime
LastModifiedTime
System.DateTime
LastModifiedBy
System.String
DataSource
select CI_ID,title
FROM
v_AuthListInfo
--where
--title like '%required%'
--and title not like '%office%'
--and title not like '%pilot%'
true
CI_ID
System.Int32
title
System.String
DataSource
select CollectionID, Name from v_Collection Order by Name
true
CollectionID
System.String
Name
System.String
1in
1in
1in
1in
1in
1in
1in
1in
1in
1in
1in
1in
1in
1in
1in
1in
1in
1in
1in
1in
0.25in
true
true
Deployment Name
Textbox2
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
SUGroup Name
Textbox3
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Dep Type
Textbox5
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Collection Name
Textbox7
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Purpose
Textbox9
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Available Time
Textbox11
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Required Time
Textbox13
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Target
Textbox15
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Success
Textbox17
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Progress
Textbox19
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Errors
Textbox21
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Others
Textbox23
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Unknown
Textbox25
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Success
Textbox27
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Available Days
Textbox29
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Required Days
Textbox31
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Created Days
Textbox33
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Creation Time
Textbox35
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Last Modified Time
Textbox37
LightGrey
1pt
White
2pt
2pt
2pt
2pt
true
true
Last Modified By
Textbox39
LightGrey
1pt
White
2pt
2pt
2pt
2pt
0.25in
true
true
=Fields!DeploymentName.Value
DeploymentName
White
2pt
2pt
2pt
2pt
true
true
=Fields!SUGroupName.Value
SUGroupName
White
2pt
2pt
2pt
2pt
true
true
=Fields!DepType.Value
DepType
White
2pt
2pt
2pt
2pt
true
true
=Fields!CollectionName.Value
CollectionName
White
2pt
2pt
2pt
2pt
true
true
=Fields!Purpose.Value
Purpose
White
2pt
2pt
2pt
2pt
true
true
=Fields!AvailableTime.Value
AvailableTime
White
2pt
2pt
2pt
2pt
true
true
=Fields!RequiredTime.Value
RequiredTime
White
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Target.Value)
Target
White
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Success.Value)
Success
White
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Progress.Value)
Progress
White
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Errors.Value)
Errors
White
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Others.Value)
Others
White
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Unknown.Value)
Unknown
White
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Success_.Value)
Success_
White
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!AvailableDays.Value)
AvailableDays
White
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!RequiredDays.Value)
RequiredDays
White
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!CreatedDays.Value)
CreatedDays
White
2pt
2pt
2pt
2pt
true
true
=Fields!CreationTime.Value
CreationTime
White
2pt
2pt
2pt
2pt
true
true
=Fields!LastModifiedTime.Value
LastModifiedTime
White
2pt
2pt
2pt
2pt
true
true
=Fields!LastModifiedBy.Value
LastModifiedBy
White
2pt
2pt
2pt
2pt
After
DataSet
0.5in
0.5in
20in
true
true
Title
ReportTitle
0.5in
5.5in
1
2pt
2pt
2pt
2pt
2.25in
20in
0.45in
true
true
true
true
=Globals!ExecutionTime
ExecutionTime
0.2in
4in
0.25in
2in
2pt
2pt
2pt
2pt
1in
1in
1in
1in
String
SUG Name
UpdateLists
CI_ID
title
String
Collection Name
CollectionList
CollectionID
Name
4
2
0
0
SUGroupName
1
0
CollectionName
Inch
http://site/ReportServer
7ac6f12a-75ba-4f47-b645-423187c38b13