Lists the application or package deployments for a device or user collection Ioan Popovici @https:\\SCCM.Zone 0 /ConfigMgr_HUB/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602} None 11111111-1111-1111-1111-111111111111 CMSQLDatabase =Parameters!UserTokenSIDs.Value /* Get AdminID */ SELECT dbo.fn_rbac_GetAdminIDsfromUserSIDs (@UserTokenSIDs) AS UserSIDs true UserSIDs System.String CMSQLDatabase =Parameters!UserSIDs.Value =Parameters!CollectionType.Value /* Get Collection info */ SELECT CollectionID, Name FROM dbo.fn_rbac_Collection(@UserSIDs) WHERE CollectionType = @CollectionType ORDER BY Name; true CollectionID System.String Name System.String CMSQLDatabase =Parameters!UserSIDs.Value =Parameters!CollectionID.Value =Parameters!CollectionType.Value /* .SYNOPSIS Lists the Application Deployments for a Collection. .DESCRIPTION Lists the Application Deployments for a Device or User Collection. .NOTES Created by Ioan Popovici Part of a report should not be run separately. .LINK https://SCCM.Zone/DE-Deployments-by-Device-or-User .LINK https://SCCM.Zone/DE-Deployments-by-Device-or-User-CHANGELOG .LINK https://SCCM.Zone/DE-Deployments-by-Device-or-User-GIT .LINK https://SCCM.Zone/Issues */ /*##=============================================*/ /*## QUERY BODY */ /*##=============================================*/ /* Testing variables !! Need to be commented for Production !! */ /* DECLARE @UserSIDs VARCHAR(16)= 'Disabled'; DECLARE @CollectionID VARCHAR(16)= 'HUB005A6'; --DECLARE @CollectionID VARCHAR(16)= 'HUB00744'; DECLARE @SelectBy VARCHAR(16); DECLARE @CollectionType VARCHAR(16); SELECT @SelectBy = ResourceID FROM fn_rbac_FullCollectionMembership(@UserSIDs) AS CollectionMembers WHERE CollectionMembers.CollectionID = @CollectionID AND CollectionMembers.ResourceType = 5; --Device collection IF @SelectBy > 0 SET @CollectionType = 2; ELSE SET @CollectionType = 1; */ /* Initialize CollectionMembers table */ DECLARE @CollectionMembers TABLE ( ResourceID INT , ResourceType INT , SMSID NVARCHAR(100) ) /* Populate CollectionMembers table */ INSERT INTO @CollectionMembers (ResourceID, ResourceType, SMSID) SELECT ResourceID, ResourceType, SMSID FROM fn_rbac_FullCollectionMembership(@UserSIDs) AS CollectionMembers WHERE CollectionMembers.CollectionID = @CollectionID AND CollectionMembers.ResourceType IN (4, 5); --Only Users or Devices /* User collection query */ IF @CollectionType = 1 BEGIN SELECT DISTINCT UserName = Users.Unique_User_Name0 , PrimaryUser = Devices.PrimaryUser , TopConsoleUser = Console.TopConsoleUser0 , SoftwareName = Deployments.SoftwareName , CollectionName = Deployments.CollectionName , Device = AssetData.MachineName , Manufacturer = Enclosure.Manufacturer0 , DeviceType = ( CASE WHEN Enclosure.ChassisTypes0 IN (8, 9, 10, 11, 12, 14, 18, 21, 31, 32) THEN 'Laptop' WHEN Enclosure.ChassisTypes0 IN (3, 4, 5, 6, 7, 15, 16) THEN 'Desktop' WHEN Enclosure.ChassisTypes0 IN (17, 23, 28, 29) THEN 'Servers' WHEN Enclosure.ChassisTypes0 = '30' THEN 'Tablet' ELSE 'Unknown' END ) , ChassisType = ( CASE Enclosure.ChassisTypes0 WHEN '1' THEN 'Other' WHEN '2' THEN 'Unknown' WHEN '3' THEN 'Desktop' WHEN '4' THEN 'Low Profile Desktop' WHEN '5' THEN 'Pizza Box' WHEN '6' THEN 'Mini Tower' WHEN '7' THEN 'Tower' WHEN '8' THEN 'Portable' WHEN '9' THEN 'Laptop' WHEN '10' THEN 'Notebook' WHEN '11' THEN 'Hand Held' WHEN '12' THEN 'Docking Station' WHEN '13' THEN 'All in One' WHEN '14' THEN 'Sub Notebook' WHEN '15' THEN 'Space-Saving' WHEN '16' THEN 'Lunch Box' WHEN '17' THEN 'Main System Chassis' WHEN '18' THEN 'Expansion Chassis' WHEN '19' THEN 'SubChassis' WHEN '20' THEN 'Bus Expansion Chassis' WHEN '21' THEN 'Peripheral Chassis' WHEN '22' THEN 'Storage Chassis' WHEN '23' THEN 'Rack Mount Chassis' WHEN '24' THEN 'Sealed-Case PC' WHEN '25' THEN 'Multi-system chassis' WHEN '26' THEN 'Compact PCI' WHEN '27' THEN 'Advanced TCA' WHEN '28' THEN 'Blade' WHEN '29' THEN 'Blade Enclosure' WHEN '30' THEN 'Tablet' WHEN '31' THEN 'Convertible' WHEN '32' THEN 'Detachable' ELSE 'Undefinded' END ) , SerialNumber = Enclosure.SerialNumber0 , Purpose = ( CASE WHEN Assignments.DesiredConfigType = 1 THEN 'Install' ELSE 'Remove' END ) , InstalledBy = Users.Unique_User_Name0 , EnforcementState = ( dbo.fn_GetAppState(AssetData.ComplianceState, AssetData.EnforcementState, Assignments.OfferTypeID, 1, AssetData.DesiredState, AssetData.IsApplicable) ) FROM fn_rbac_CollectionExpandedUserMembers(@UserSIDs) AS CollectionMembers INNER JOIN v_R_User AS Users ON Users.ResourceID = CollectionMembers.UserItemKey INNER JOIN v_DeploymentSummary AS Deployments ON Deployments.CollectionID = CollectionMembers.SiteID LEFT JOIN v_AppIntentAssetData AS AssetData ON AssetData.UserName = Users.Unique_User_Name0 AND AssetData.AssignmentID = Deployments.AssignmentID INNER JOIN v_CIAssignment AS Assignments ON Assignments.AssignmentID = Deployments.AssignmentID LEFT JOIN v_GS_SYSTEM_ENCLOSURE AS Enclosure ON Enclosure.ResourceID = AssetData.MachineID LEFT JOIN v_GS_SYSTEM_CONSOLE_USAGE AS Console ON Console.ResourceID = AssetData.MachineID LEFT JOIN v_CombinedDeviceResources AS Devices ON Devices.MachineID = AssetData.MachineID WHERE Deployments.FeatureType = 1 AND Users.Unique_User_Name0 IN ( SELECT SMSID FROM @CollectionMembers WHERE ResourceType = 4 --Ony Users ) END; /* Device collection query */ IF @CollectionType = 2 BEGIN SELECT DISTINCT Device = Devices.Name , PrimaryUser = Devices.PrimaryUser , TopConsoleUser = Console.TopConsoleUser0 , Manufacturer = Enclosure.Manufacturer0 , DeviceType = ( CASE WHEN Enclosure.ChassisTypes0 IN (8 , 9, 10, 11, 12, 14, 18, 21, 31, 32) THEN 'Laptop' WHEN Enclosure.ChassisTypes0 IN (3, 4, 5, 6, 7, 15, 16) THEN 'Desktop' WHEN Enclosure.ChassisTypes0 IN (17, 23, 28, 29) THEN 'Servers' WHEN Enclosure.ChassisTypes0 = '30' THEN 'Tablet' ELSE 'Unknown' END ) , ChassisType = ( CASE Enclosure.ChassisTypes0 WHEN '1' THEN 'Other' WHEN '2' THEN 'Unknown' WHEN '3' THEN 'Desktop' WHEN '4' THEN 'Low Profile Desktop' WHEN '5' THEN 'Pizza Box' WHEN '6' THEN 'Mini Tower' WHEN '7' THEN 'Tower' WHEN '8' THEN 'Portable' WHEN '9' THEN 'Laptop' WHEN '10' THEN 'Notebook' WHEN '11' THEN 'Hand Held' WHEN '12' THEN 'Docking Station' WHEN '13' THEN 'All in One' WHEN '14' THEN 'Sub Notebook' WHEN '15' THEN 'Space-Saving' WHEN '16' THEN 'Lunch Box' WHEN '17' THEN 'Main System Chassis' WHEN '18' THEN 'Expansion Chassis' WHEN '19' THEN 'SubChassis' WHEN '20' THEN 'Bus Expansion Chassis' WHEN '21' THEN 'Peripheral Chassis' WHEN '22' THEN 'Storage Chassis' WHEN '23' THEN 'Rack Mount Chassis' WHEN '24' THEN 'Sealed-Case PC' WHEN '25' THEN 'Multi-system chassis' WHEN '26' THEN 'Compact PCI' WHEN '27' THEN 'Advanced TCA' WHEN '28' THEN 'Blade' WHEN '29' THEN 'Blade Enclosure' WHEN '30' THEN 'Tablet' WHEN '31' THEN 'Convertible' WHEN '32' THEN 'Detachable' ELSE 'Undefinded' END ) , SerialNumber = Enclosure.SerialNumber0 , SoftwareName = Deployments.SoftwareName , CollectionName = Deployments.CollectionName , Purpose = ( CASE WHEN Assignments.DesiredConfigType = 1 THEN 'Install' ELSE 'Remove' END ) , InstalledBy = AssetData.UserName , EnforcementState = Dbo.fn_GetAppState(AssetData.ComplianceState, AssetData.EnforcementState, Assignments.OfferTypeID, 1, AssetData.DesiredState, AssetData.IsApplicable) FROM v_CombinedDeviceResources AS Devices INNER JOIN fn_rbac_FullCollectionMembership(@UserSIDs) AS CollectionMembers ON CollectionMembers.ResourceID = Devices.MachineID AND CollectionMembers.ResourceType = 5 --Only Devices INNER JOIN v_DeploymentSummary AS Deployments ON Deployments.CollectionID = CollectionMembers.CollectionID AND Deployments.FeatureType = 1 LEFT JOIN v_AppIntentAssetData AS AssetData ON AssetData.MachineID = CollectionMembers.ResourceID AND AssetData.AssignmentID = Deployments.AssignmentID INNER JOIN v_CIAssignment AS Assignments ON Assignments.AssignmentID = Deployments.AssignmentID LEFT JOIN v_GS_SYSTEM_ENCLOSURE AS Enclosure ON Enclosure.ResourceID = Devices.MachineID LEFT JOIN v_GS_SYSTEM_CONSOLE_USAGE AS Console ON Console.ResourceID = Devices.MachineID WHERE Devices.isClient = 1 AND Devices.MachineID IN ( SELECT ResourceID FROM @CollectionMembers WHERE ResourceType = 5 --Only Devices ) END; /*##=============================================*/ /*## END QUERY BODY */ /*##=============================================*/ true UserName System.String PrimaryUser System.String SoftwareName System.String TopConsoleUser System.String CollectionName System.String Device System.String Manufacturer System.String DeviceType System.String ChassisType System.String SerialNumber System.String Purpose System.String InstalledBy System.String EnforcementState System.Int16 CMSQLDatabase =Parameters!UserSIDs.Value =Parameters!CollectionID.Value =Parameters!CollectionType.Value /* .SYNOPSIS Lists the Package Deployments for a Collection. .DESCRIPTION Lists the Package Deployments for a Device or User Collection. .NOTES Created by Ioan Popovici Part of a report should not be run separately. .LINK https://SCCM.Zone/DE-Deployments-by-Device-or-User .LINK https://SCCM.Zone/DE-Deployments-by-Device-or-User-CHANGELOG .LINK https://SCCM.Zone/DE-Deployments-by-Device-or-User-GIT .LINK https://SCCM.Zone/Issues */ /*##=============================================*/ /*## QUERY BODY */ /*##=============================================*/ /* Testing variables !! Need to be commented for Production !! */ /* DECLARE @UserSIDs VARCHAR(16)= 'Disabled'; DECLARE @CollectionID VARCHAR(16)= 'PC100026'; --DECLARE @CollectionID VARCHAR(16)= 'PC100025'; DECLARE @SelectBy VARCHAR(16); DECLARE @CollectionType VARCHAR(16); SELECT @SelectBy = ResourceID FROM fn_rbac_FullCollectionMembership(@UserSIDs) AS CollectionMembers WHERE CollectionMembers.CollectionID = @CollectionID AND CollectionMembers.ResourceType = 5; --Device collection IF @SelectBy > 0 SET @CollectionType = 2; ELSE SET @CollectionType = 1; */ /* Initialize CollectionMembers table */ DECLARE @CollectionMembers TABLE ( ResourceID INT , ResourceType INT , SMSID NVARCHAR(100) ) /* Populate CollectionMembers table */ INSERT INTO @CollectionMembers (ResourceID, ResourceType, SMSID) SELECT ResourceID, ResourceType, SMSID FROM fn_rbac_FullCollectionMembership(@UserSIDs) AS CollectionMembers WHERE CollectionMembers.CollectionID = @CollectionID AND CollectionMembers.ResourceType IN (4, 5); --Only Users or Devices /* User collection query */ IF @CollectionType = 1 BEGIN SELECT DISTINCT UserName = CollectionMembership.SMSID , PackageName = Package.Name , ProgramName = Advertisment.ProgramName , CollectionName = Deployment.CollectionName , Purpose = ( CASE WHEN Advertisment.AssignedScheduleEnabled = 0 THEN 'Available' ELSE 'Required' END ) , LastStateName = AdvertismentStatus.LastStateName , Device = 'Device' -- Needed in order to be able to save the report. , Manufacturer = 'Manufacturer' -- Needed in order to be able to save the report. , DeviceType = 'DeviceType' -- Needed in order to be able to save the report. , ChassisType = 'ChassisType' -- Needed in order to be able to save the report. , SerialNumber = 'SerialNumber' -- Needed in order to be able to save the report. , PrimaryUser = 'PrimaryUser' -- Needed in order to be able to save the report. , TopConsoleUser = 'TopConsoleUser' -- Needed in order to be able to save the report. FROM v_Advertisement AS Advertisment INNER JOIN v_Package AS Package ON Package.PackageID = Advertisment.PackageID LEFT JOIN v_ClientAdvertisementStatus AS AdvertismentStatus ON AdvertismentStatus.AdvertisementID = Advertisment.AdvertisementID INNER JOIN vClassicDeployments AS Deployment ON Deployment.DeploymentID = Advertisment.AdvertisementID INNER JOIN fn_rbac_FullCollectionMembership(@UserSIDs) AS CollectionMembership ON CollectionMembership.CollectionID = Advertisment.CollectionID AND ResourceType = 4 -- Ony Users WHERE CollectionMembership.SMSID IN ( SELECT SMSID FROM @CollectionMembers WHERE ResourceType = 4 -- Ony Users ) END; /* Device collection query */ IF @CollectionType = 2 BEGIN SELECT DISTINCT Device = Devices.Name , PrimaryUser = Devices.PrimaryUser , TopConsoleUser = Console.TopConsoleUser0 , Manufacturer = Enclosure.Manufacturer0 , DeviceType = ( CASE WHEN Enclosure.ChassisTypes0 IN (8, 9, 10, 11, 12, 14, 18, 21, 31, 32) THEN 'Laptop' WHEN Enclosure.ChassisTypes0 IN (3, 4, 5, 6, 7, 15, 16) THEN 'Desktop' WHEN Enclosure.ChassisTypes0 IN (17, 23, 28, 29) THEN 'Servers' WHEN Enclosure.ChassisTypes0 = '30' THEN 'Tablet' ELSE 'Unknown' END ) , ChassisTypes = ( CASE Enclosure.ChassisTypes0 WHEN '1' THEN 'Other' WHEN '2' THEN 'Unknown' WHEN '3' THEN 'Desktop' WHEN '4' THEN 'Low Profile Desktop' WHEN '5' THEN 'Pizza Box' WHEN '6' THEN 'Mini Tower' WHEN '7' THEN 'Tower' WHEN '8' THEN 'Portable' WHEN '9' THEN 'Laptop' WHEN '10' THEN 'Notebook' WHEN '11' THEN 'Hand Held' WHEN '12' THEN 'Docking Station' WHEN '13' THEN 'All in One' WHEN '14' THEN 'Sub Notebook' WHEN '15' THEN 'Space-Saving' WHEN '16' THEN 'Lunch Box' WHEN '17' THEN 'Main System Chassis' WHEN '18' THEN 'Expansion Chassis' WHEN '19' THEN 'SubChassis' WHEN '20' THEN 'Bus Expansion Chassis' WHEN '21' THEN 'Peripheral Chassis' WHEN '22' THEN 'Storage Chassis' WHEN '23' THEN 'Rack Mount Chassis' WHEN '24' THEN 'Sealed-Case PC' WHEN '25' THEN 'Multi-system chassis' WHEN '26' THEN 'Compact PCI' WHEN '27' THEN 'Advanced TCA' WHEN '28' THEN 'Blade' WHEN '29' THEN 'Blade Enclosure' WHEN '30' THEN 'Tablet' WHEN '31' THEN 'Convertible' WHEN '32' THEN 'Detachable' ELSE 'Undefinded' END ) , SerialNumber = Enclosure.SerialNumber0 , PackageName = Package.Name , ProgramName = Advertisment.ProgramName , CollectionName = Deployment.CollectionName , Purpose = ( CASE WHEN Deployment.Purpose = 0 THEN 'Available' ELSE 'Required' END ) , LastStateName = AdvertismentStatus.LastStateName FROM v_Advertisement AS Advertisment JOIN v_Package AS Package ON Package.PackageID = Advertisment.PackageID JOIN v_ClientAdvertisementStatus AS AdvertismentStatus ON AdvertismentStatus.AdvertisementID = Advertisment.AdvertisementID JOIN v_CombinedDeviceResources AS Devices ON Devices.MachineID = AdvertismentStatus.ResourceID LEFT JOIN v_GS_SYSTEM_ENCLOSURE AS Enclosure ON Enclosure.ResourceID = Devices.MachineID LEFT JOIN v_GS_SYSTEM_CONSOLE_USAGE AS Console ON Console.ResourceID = Devices.MachineID JOIN vClassicDeployments AS Deployment ON Deployment.CollectionID = Advertisment.CollectionID AND Advertisment.ProgramName != '*' -- Only Programs WHERE Devices.isClient = 1 AND Devices.MachineID IN ( SELECT ResourceID FROM @CollectionMembers WHERE ResourceType = 5 -- Only Devices ) END; /*##=============================================*/ /*## END QUERY BODY */ /*##=============================================*/ true UserName System.String PackageName System.String ProgramName System.String CollectionName System.String Device System.String Manufacturer System.String LastStateName System.String DeviceType System.String SerialNumber System.String Purpose System.String ChassisType System.String PrimaryUser System.String TopConsoleUser System.String 1.47018in 8.35556in 0.4in true true =SrsResources.Localization.GetString("Description", User!Language) 2pt 2pt 2pt 2pt true true Lists the application or package deployments for a device or user collection 5pt 2pt 2pt 2pt CollectionInfo 0.03194in 0.12701cm 0.4in 9.82574in 0.46065in 0.05in 0in 21.67536in 1 1.5pt 1.5pt 1.5pt 1.5pt 1.5pt 1.75917cm 0.6cm true =Sum(CountDistinct(Fields!SoftwareName.Value)) ADD_Device true =SrsResources.Localization.GetString("Total", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!SoftwareName.Value) Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!CollectionName.Value) WhiteSmoke Middle 2pt 2pt 2pt 2pt 0.6cm true true Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!Device.Value) LightGrey Middle 2pt 2pt 2pt 2pt 4.15982cm true =Fields!Device.Value ADD_Device true =SrsResources.Localization.GetString("Device", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 3.67281cm true =Fields!Manufacturer.Value ADD_Device true =SrsResources.Localization.GetString("Manufacturer", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 2.963cm true =Fields!DeviceType.Value ADD_Device true =SrsResources.Localization.GetString("Type", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 3.16146cm true =Fields!ChassisType.Value ADD_Device true =SrsResources.Localization.GetString("Chassis", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 3.01642cm true =Fields!SerialNumber.Value ADD_Device true =SrsResources.Localization.GetString("SerialNumber", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 2.95713cm true =Fields!PrimaryUser.Value ADD_Device true =SrsResources.Localization.GetString("PrmaryUser", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 4.25917cm true =Fields!TopConsoleUser.Value ADD_Device true =SrsResources.Localization.GetString("TopConsoleUser", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 11.09923cm true =Fields!SoftwareName.Value ADD_SoftwareName true =SrsResources.Localization.GetString("Software", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 7.52983cm true =Fields!CollectionName.Value ADD_CollectionName true =SrsResources.Localization.GetString("Collection", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 2.5cm true =Fields!Purpose.Value true =SrsResources.Localization.GetString("Purpose", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.67343cm true =Fields!InstalledBy.Value true =SrsResources.Localization.GetString("Installed By", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 4.29114cm true =Fields!EnforcementState.Value true =SrsResources.Localization.GetString("EnforcementState", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt =Fields!Device.Value =Fields!Device.Value =Fields!Manufacturer.Value =Fields!ChassisType.Value =Fields!DeviceType.Value =Fields!SerialNumber.Value 4.15982cm true true =Fields!Device.Value Top 2pt 2pt 2pt 2pt 3.67281cm true true =Fields!Manufacturer.Value Top 2pt 2pt 2pt 2pt 2.963cm true true =Fields!DeviceType.Value Top 2pt 2pt 2pt 2pt 3.16146cm true true =Fields!ChassisType.Value Top 2pt 2pt 2pt 2pt 3.01642cm true true =Fields!SerialNumber.Value Top 2pt 2pt 2pt 2pt 2.95713cm true true =Fields!PrimaryUser.Value Top 2pt 2pt 2pt 2pt 4.25917cm true true =Fields!TopConsoleUser.Value Top 2pt 2pt 2pt 2pt 11.09923cm true true Top 2pt 2pt 2pt 2pt 7.52983cm true true Top 2pt 2pt 2pt 2pt 2.5cm true true Textbox19 Middle 2pt 2pt 2pt 2pt 3.67343cm true true Top 2pt 2pt 2pt 2pt 4.29114cm true true Textbox928 Middle 2pt 2pt 2pt 2pt After =Fields!SoftwareName.Value =Fields!SoftwareName.Value 11.09923cm true true =Fields!SoftwareName.Value WhiteSmoke Top 2pt 2pt 2pt 2pt 7.52983cm true true Textbox30 WhiteSmoke Middle 2pt 2pt 2pt 2pt 2.5cm true true Textbox20 WhiteSmoke Middle 2pt 2pt 2pt 2pt 3.67343cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 4.29114cm true true Textbox929 WhiteSmoke Middle 2pt 2pt 2pt 2pt After =Fields!CollectionName.Value =Fields!CollectionName.Value 7.52983cm true true =Fields!CollectionName.Value Top 2pt 2pt 2pt 2pt =Fields!Purpose.Value 2.5cm true true =Fields!Purpose.Value Middle 2pt 2pt 2pt 2pt 3.67343cm true true =Fields!InstalledBy.Value Top 2pt 2pt 2pt 2pt 4.29114cm true true =SrsResources.Localization.GetStateMessage(1702, Fields!EnforcementState.Value, User!Language) Middle 2pt 2pt 2pt 2pt true ADD_TV_SoftwareName true ADD_TV_Device 4.15982cm true true Total LightGrey Middle 2pt 2pt 2pt 2pt 3.67281cm true true LightGrey Middle 2pt 2pt 2pt 2pt 2.963cm true true LightGrey Middle 2pt 2pt 2pt 2pt 3.16146cm true true LightGrey Middle 2pt 2pt 2pt 2pt 3.01642cm true true LightGrey Middle 2pt 2pt 2pt 2pt 2.95713cm true true LightGrey Middle 2pt 2pt 2pt 2pt 4.25917cm true true LightGrey Middle 2pt 2pt 2pt 2pt 11.09923cm true true LightGrey Middle 2pt 2pt 2pt 2pt 7.52983cm true true LightGrey Middle 2pt 2pt 2pt 2pt 2.5cm true true Textbox23 LightGrey Middle 2pt 2pt 2pt 2pt 3.67343cm true true LightGrey Middle 2pt 2pt 2pt 2pt 4.29114cm true true Textbox932 LightGrey Middle 2pt 2pt 2pt 2pt Before ApplicationDeployments 4.2836cm 0.13981cm 3cm 55.04261cm 2 =IIF((Parameters!CollectionType.Value = 2 AND Parameters!DeploymentType.Value = 1 ), False, True) 1.75917cm 0.6cm true =Sum(CountDistinct(Fields!SoftwareName.Value)) ADU_UserName true =SrsResources.Localization.GetString("Total", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 0.6cm true true =Count(Fields!SoftwareName.Value) Middle 2pt 2pt 2pt 2pt 0.6cm true true =Count(Fields!CollectionName.Value) WhiteSmoke Middle 2pt 2pt 2pt 2pt 0.6cm true true Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!UserName.Value) LightGrey Middle 2pt 2pt 2pt 2pt 5.19755cm true =Fields!UserName.Value ADU_UserName true =SrsResources.Localization.GetString("User", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 10.15889cm true =Fields!SoftwareName.Value ADU_SoftwareName true =SrsResources.Localization.GetString("SoftwareName", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 8.83015cm true =Fields!CollectionName.Value ADU_CollectionName true =SrsResources.Localization.GetString("Collection", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 2.5cm true =Fields!Purpose.Value true =SrsResources.Localization.GetString("Purpose", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.49235cm true =Fields!Device.Value true =SrsResources.Localization.GetString("Computer", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.4184cm true =Fields!Manufacturer.Value true =SrsResources.Localization.GetString("Manufacturer", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.87071cm true =Fields!DeviceType.Value true =SrsResources.Localization.GetString("Type", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.05563cm true =Fields!ChassisType.Value true =SrsResources.Localization.GetString("Chassis", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.61954cm true =Fields!SerialNumber.Value true =SrsResources.Localization.GetString("SerialNumber", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.86422cm true =Fields!PrimaryUser.Value ADD_Device true =SrsResources.Localization.GetString("PrmaryUser", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 3.87582cm true =Fields!TopConsoleUser.Value ADD_Device true =SrsResources.Localization.GetString("TopConsoleUser", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 4.40018cm true =Fields!EnforcementState.Value true =SrsResources.Localization.GetString("EnforcementState", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt =Fields!UserName.Value =Fields!UserName.Value 5.19755cm true true =Fields!UserName.Value Top 2pt 2pt 2pt 2pt true 10.15889cm true true Top 2pt 2pt 2pt 2pt 8.83015cm true true Top 2pt 2pt 2pt 2pt 2.5cm true true Textbox29 Middle 2pt 2pt 2pt 2pt 3.49235cm true true Top 2pt 2pt 2pt 2pt 3.4184cm true true Top 2pt 2pt 2pt 2pt 2.87071cm true true Top 2pt 2pt 2pt 2pt 3.05563cm true true Top 2pt 2pt 2pt 2pt 2.61954cm true true Top 2pt 2pt 2pt 2pt 2.86422cm true true Top 2pt 2pt 2pt 2pt 3.87582cm true true Top 2pt 2pt 2pt 2pt 4.40018cm true true Textbox928 Middle 2pt 2pt 2pt 2pt After =Fields!SoftwareName.Value =Fields!SoftwareName.Value 10.15889cm true true =Fields!SoftwareName.Value WhiteSmoke Top 2pt 2pt 2pt 2pt 8.83015cm true true Textbox30 WhiteSmoke Middle 2pt 2pt 2pt 2pt 2.5cm true true Textbox30 WhiteSmoke Middle 2pt 2pt 2pt 2pt 3.49235cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 3.4184cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 2.87071cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 3.05563cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 2.61954cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 2.86422cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 3.87582cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 4.40018cm true true Textbox929 WhiteSmoke Middle 2pt 2pt 2pt 2pt After =Fields!CollectionName.Value =Fields!CollectionName.Value 8.83015cm true true =Fields!CollectionName.Value Top 2pt 2pt 2pt 2pt =Fields!Purpose.Value =Fields!Manufacturer.Value =Fields!DeviceType.Value =Fields!ChassisType.Value =Fields!SerialNumber.Value =Fields!EnforcementState.Value =Fields!Device.Value 2.5cm true true =Fields!Purpose.Value Middle 2pt 2pt 2pt 2pt 3.49235cm true true =Fields!Device.Value Top 2pt 2pt 2pt 2pt 3.4184cm true true =Fields!Manufacturer.Value Top 2pt 2pt 2pt 2pt 2.87071cm true true =Fields!DeviceType.Value Top 2pt 2pt 2pt 2pt 3.05563cm true true =Fields!ChassisType.Value Top 2pt 2pt 2pt 2pt 2.61954cm true true =Fields!SerialNumber.Value Top 2pt 2pt 2pt 2pt 2.86422cm true true =Fields!PrimaryUser.Value Top 2pt 2pt 2pt 2pt 3.87582cm true true =Fields!TopConsoleUser.Value Top 2pt 2pt 2pt 2pt 4.40018cm true true =SrsResources.Localization.GetStateMessage(1702, Fields!EnforcementState.Value, User!Language) Middle 2pt 2pt 2pt 2pt true ADU_TV_SoftwareName true ADU_TV_UserName 5.19755cm true true Total LightGrey Middle 2pt 2pt 2pt 2pt 10.15889cm true true LightGrey Middle 2pt 2pt 2pt 2pt 8.83015cm true true LightGrey Middle 2pt 2pt 2pt 2pt 2.5cm true true Textbox33 LightGrey Middle 2pt 2pt 2pt 2pt 3.49235cm true true LightGrey Middle 2pt 2pt 2pt 2pt 3.4184cm true true LightGrey Middle 2pt 2pt 2pt 2pt 2.87071cm true true LightGrey Middle 2pt 2pt 2pt 2pt 3.05563cm true true LightGrey Middle 2pt 2pt 2pt 2pt 2.61954cm true true LightGrey Middle 2pt 2pt 2pt 2pt 2.86422cm true true LightGrey Middle 2pt 2pt 2pt 2pt 3.87582cm true true LightGrey Middle 2pt 2pt 2pt 2pt 4.40018cm true true Textbox932 LightGrey Middle 2pt 2pt 2pt 2pt Before ApplicationDeployments 1.26206cm 0.1398cm 3cm 55.04261cm 3 =IIF((Parameters!CollectionType.Value = 1 AND Parameters!DeploymentType.Value = 1 ), False, True) 1.75917cm 0.6cm true =Sum(CountDistinct(Fields!PackageName.Value)) PDU_UserName true =SrsResources.Localization.GetString("Total", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!PackageName.Value) Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!ProgramName.Value) WhiteSmoke Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!CollectionName.Value) Middle 2pt 2pt 2pt 2pt 0.6cm true true WhiteSmoke Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!UserName.Value) LightGrey Middle 2pt 2pt 2pt 2pt 5.09774cm true =Fields!UserName.Value PDU_UserName true =SrsResources.Localization.GetString("UserName", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 14.82406cm true =Fields!PackageName.Value PDU_PackageName true =SrsResources.Localization.GetString("Package", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 12.52742cm true =Fields!ProgramName.Value PDU_ProgramName true =SrsResources.Localization.GetString("Program", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 12.99105cm true =Fields!CollectionName.Value PDU_CollectionName true =SrsResources.Localization.GetString("Collection", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 3.51667cm true =Fields!Purpose.Value true =SrsResources.Localization.GetString("Purpose", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 4.32651cm true =Fields!LastStateName.Value true =SrsResources.Localization.GetString("State", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt =Fields!UserName.Value =Fields!UserName.Value 5.09774cm true true =Fields!UserName.Value Top 2pt 2pt 2pt 2pt 14.82406cm true true Top 2pt 2pt 2pt 2pt 12.52742cm true true Top 2pt 2pt 2pt 2pt 12.99105cm true true Top 2pt 2pt 2pt 2pt 3.51667cm true true Textbox2 Middle 2pt 2pt 2pt 2pt 4.32651cm true true Textbox928 Middle 2pt 2pt 2pt 2pt After =Fields!PackageName.Value =Fields!PackageName.Value 14.82406cm true true =Fields!PackageName.Value WhiteSmoke Top 2pt 2pt 2pt 2pt 12.52742cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 12.99105cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 3.51667cm true true Textbox3 WhiteSmoke Middle 2pt 2pt 2pt 2pt 4.32651cm true true Textbox929 WhiteSmoke Middle 2pt 2pt 2pt 2pt After =Fields!ProgramName.Value =Fields!ProgramName.Value 12.52742cm true true =Fields!ProgramName.Value Top 2pt 2pt 2pt 2pt 12.99105cm true true Textbox37 Middle 2pt 2pt 2pt 2pt 3.51667cm true true Textbox4 Middle 2pt 2pt 2pt 2pt 4.32651cm true true Textbox930 Middle 2pt 2pt 2pt 2pt After =Fields!CollectionName.Value =Fields!CollectionName.Value 12.99105cm true true =Fields!CollectionName.Value WhiteSmoke Top 2pt 2pt 2pt 2pt =Fields!Purpose.Value 3.51667cm true true =Fields!Purpose.Value WhiteSmoke Middle 2pt 2pt 2pt 2pt 4.32651cm true true =Fields!LastStateName.Value WhiteSmoke Middle 2pt 2pt 2pt 2pt true PDU_TV_ProgramName true PDU_TV_PackageName true PDU_TV_UserName 5.09774cm true true Total LightGrey Middle 2pt 2pt 2pt 2pt 14.82406cm true true LightGrey Middle 2pt 2pt 2pt 2pt 12.52742cm true true LightGrey Middle 2pt 2pt 2pt 2pt 12.99105cm true true LightGrey Middle 2pt 2pt 2pt 2pt 3.51667cm true true Textbox6 LightGrey Middle 2pt 2pt 2pt 2pt 4.32651cm true true Textbox932 LightGrey Middle 2pt 2pt 2pt 2pt Before PackageDeployments 7.30147cm 0.13981cm 3.6cm 55.04261cm 4 =IIF((Parameters!CollectionType.Value = 1 AND Parameters!DeploymentType.Value = 2 ), False, True) 1.75917cm 0.6cm true =Sum(CountDistinct(Fields!PackageName.Value)) PDD_Device true =SrsResources.Localization.GetString("Total", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!PackageName.Value) Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!ProgramName.Value) Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!CollectionName.Value) Middle 2pt 2pt 2pt 2pt 0.6cm true true Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!Device.Value) LightGrey Middle 2pt 2pt 2pt 2pt 3.46649cm true =Fields!Device.Value PDD_Device true =SrsResources.Localization.GetString("Device", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 3.50631cm true =Fields!Manufacturer.Value PDD_Device true =SrsResources.Localization.GetString("Manufacturer", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 2.66353cm true =Fields!DeviceType.Value PDD_Device true =SrsResources.Localization.GetString("Type", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 3.135cm true =Fields!ChassisType.Value PDD_Device true =SrsResources.Localization.GetString("Chassis", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 2.8175cm true =Fields!SerialNumber.Value PDD_Device true =SrsResources.Localization.GetString("SerialNumber", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 2.8175cm true =Fields!PrimaryUser.Value PDD_Device true =SrsResources.Localization.GetString("PrmaryUser", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 3.50542cm true =Fields!TopConsoleUser.Value PDD_Device true =SrsResources.Localization.GetString("TopConsoleUser", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 9.23052cm true =Fields!PackageName.Value PDD_PackageName true =SrsResources.Localization.GetString("Package", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 8.09165cm true =Fields!ProgramName.Value PDD_PackageName true =SrsResources.Localization.GetString("Program", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 7.87167cm true =Fields!CollectionName.Value PDD_CollectionName true =SrsResources.Localization.GetString("Colection", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 2.5cm true =Fields!Purpose.Value true =SrsResources.Localization.GetString("Purpose", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.67785cm true =Fields!LastStateName.Value true =SrsResources.Localization.GetString("State", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt =Fields!Device.Value =Fields!Device.Value =Fields!Manufacturer.Value =Fields!DeviceType.Value =Fields!ChassisType.Value =Fields!SerialNumber.Value =Fields!PrimaryUser.Value =Fields!TopConsoleUser.Value 3.46649cm true true =Fields!Device.Value Top 2pt 2pt 2pt 2pt 3.50631cm true true =Fields!Manufacturer.Value Top 2pt 2pt 2pt 2pt 2.66353cm true true =Fields!DeviceType.Value Top 2pt 2pt 2pt 2pt 3.135cm true true =Fields!ChassisType.Value Top 2pt 2pt 2pt 2pt 2.8175cm true true =Fields!SerialNumber.Value Top 2pt 2pt 2pt 2pt 2.8175cm true true =Fields!PrimaryUser.Value Top 2pt 2pt 2pt 2pt 3.50542cm true true =Fields!TopConsoleUser.Value Top 2pt 2pt 2pt 2pt 9.23052cm true true Top 2pt 2pt 2pt 2pt 8.09165cm true true Top 2pt 2pt 2pt 2pt 7.87167cm true true Top 2pt 2pt 2pt 2pt 2.5cm true true Textbox35 Middle 2pt 2pt 2pt 2pt 3.67785cm true true Textbox928 Middle 2pt 2pt 2pt 2pt After =Fields!PackageName.Value =Fields!PackageName.Value 9.23052cm true true =Fields!PackageName.Value Top 2pt 2pt 2pt 2pt 8.09165cm true true Top 2pt 2pt 2pt 2pt 7.87167cm true true Top 2pt 2pt 2pt 2pt 2.5cm true true Textbox36 Middle 2pt 2pt 2pt 2pt 3.67785cm true true Textbox929 Middle 2pt 2pt 2pt 2pt After =Fields!ProgramName.Value =Fields!ProgramName.Value 8.09165cm true true =Fields!ProgramName.Value Top 2pt 2pt 2pt 2pt 7.87167cm true true Textbox37 Middle 2pt 2pt 2pt 2pt 2.5cm true true Textbox37 Middle 2pt 2pt 2pt 2pt 3.67785cm true true Textbox930 Middle 2pt 2pt 2pt 2pt After =Fields!CollectionName.Value =Fields!CollectionName.Value 7.87167cm true true =Fields!CollectionName.Value Top 2pt 2pt 2pt 2pt =Fields!Purpose.Value =Fields!LastStateName.Value =Fields!PackageName.Value =Sum(CountDistinct(Fields!Device.Value)) 2.5cm true true =Fields!Purpose.Value Middle 2pt 2pt 2pt 2pt 3.67785cm true true =Fields!LastStateName.Value Middle 2pt 2pt 2pt 2pt true PDD_TV_ProgramName true PDD_TV_PackageName true PDD_TV_Device 3.46649cm true true Total LightGrey Middle 2pt 2pt 2pt 2pt 3.50631cm true true LightGrey Middle 2pt 2pt 2pt 2pt 2.66353cm true true LightGrey Middle 2pt 2pt 2pt 2pt 3.135cm true true LightGrey Middle 2pt 2pt 2pt 2pt 2.8175cm true true LightGrey Middle 2pt 2pt 2pt 2pt 2.8175cm true true LightGrey Middle 2pt 2pt 2pt 2pt 3.50542cm true true LightGrey Middle 2pt 2pt 2pt 2pt 9.23052cm true true LightGrey Middle 2pt 2pt 2pt 2pt 8.09165cm true true LightGrey Middle 2pt 2pt 2pt 2pt 7.87167cm true true LightGrey Middle 2pt 2pt 2pt 2pt 2.5cm true true Textbox39 LightGrey Middle 2pt 2pt 2pt 2pt 3.67785cm true true Textbox932 LightGrey Middle 2pt 2pt 2pt 2pt Before PackageDeployments 10.90231cm 0.13981cm 3.6cm 55.04261cm 5 =IIF((Parameters!CollectionType.Value = 2 AND Parameters!DeploymentType.Value = 2 ), False, True) Segoe UI 14.54881cm 55.447cm 2.60098cm true true true true =SrsResources.Localization.GetString(Globals!ReportName, User!Language) 1.59698cm 0.127cm 0.89817cm 24.95739cm Middle 2pt 2pt 2pt 2pt Embedded Report_Logo FitProportional 0.0617cm 0.127cm 1.35889cm 1.5cm 1 0.60444in 0.05in 0in 21.67536in 2 0.75pt 0.75pt 0.75pt 0.75pt 0.75pt 1.19856cm true true true true ="Page: " + Globals!PageNumber.ToString() + "of " + Globals!TotalPages.ToString() 0.35631cm 0.13981cm 0.63492cm 2.79292cm 0.06944in 0.04889in 0in 21.69222in 1 1.5pt 1.5pt 1.5pt 1.5pt 1.5pt 21cm 29.7cm 2.54cm 2.54cm 2.54cm 2.54cm 1.27cm