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 White 2pt 2pt 2pt 2pt true true =Fields!SUGroupName.Value White 2pt 2pt 2pt 2pt true true =Fields!DepType.Value White 2pt 2pt 2pt 2pt true true =Fields!CollectionName.Value White 2pt 2pt 2pt 2pt true true =Fields!Purpose.Value White 2pt 2pt 2pt 2pt true true =Fields!AvailableTime.Value White 2pt 2pt 2pt 2pt true true =Fields!RequiredTime.Value White 2pt 2pt 2pt 2pt true true =Sum(Fields!Target.Value) White 2pt 2pt 2pt 2pt true true =Sum(Fields!Success.Value) White 2pt 2pt 2pt 2pt true true =Sum(Fields!Progress.Value) White 2pt 2pt 2pt 2pt true true =Sum(Fields!Errors.Value) White 2pt 2pt 2pt 2pt true true =Sum(Fields!Others.Value) White 2pt 2pt 2pt 2pt true true =Sum(Fields!Unknown.Value) White 2pt 2pt 2pt 2pt true true =Sum(Fields!Success_.Value) White 2pt 2pt 2pt 2pt true true =Sum(Fields!AvailableDays.Value) White 2pt 2pt 2pt 2pt true true =Sum(Fields!RequiredDays.Value) White 2pt 2pt 2pt 2pt true true =Sum(Fields!CreatedDays.Value) White 2pt 2pt 2pt 2pt true true =Fields!CreationTime.Value White 2pt 2pt 2pt 2pt true true =Fields!LastModifiedTime.Value White 2pt 2pt 2pt 2pt true true =Fields!LastModifiedBy.Value White 2pt 2pt 2pt 2pt After DataSet 0.5in 0.5in 20in true true 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