Lists installed software by user selection (Device, Publisher or Software). Supports filtering and exclusions by multiple software names using comma separated values and sql wildcards. Supported wildcards: '%', '[]', '_'. Example: Like = 'Adobe%,7zip'; NotLike = 'Adobe Acrobat%,winzip'. Don't abuse wildcards, they are very resource intensive. Ioan Popovici @SCCM-Zone.com 0 /ConfigMgr_HUB/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602} None 11111111-1111-1111-1111-111111111111 SQL Data Source=dfs-sccmcas-52.dpko.un.org;Initial Catalog=ReportServer true Integrated 577b22ff-5778-4c0b-b15c-3dea33b466c1 CMSQLDatabase =Parameters!UserTokenSIDs.Value /* Get AdminID Dataset */ SELECT dbo.fn_rbac_GetAdminIDsfromUserSIDs (@UserTokenSIDs) AS UserSIDs UserSIDs System.String CMSQLDatabase =Parameters!UserSIDs.Value SELECT CollectionID, Name FROM dbo.fn_rbac_Collection(@UserSIDs) WHERE CollectionType = 2 ORDER BY Name; true CollectionID System.String Name System.String CMSQLDatabase =Parameters!SoftwareNameLike.Value =Parameters!UserSIDs.Value =Parameters!CollectionID.Value =Parameters!SoftwareNameNotLike.Value /* .SYNOPSIS Lists the installed software. .DESCRIPTION Lists the installed software by user selection (Device, Publisher or Name). Supports filtering and exclusions by multiple software names using comma separated values and sql wildcards. .NOTES Created by Ioan Popovici. Requires ufn_csv_String_Parser custom function. Part of a report should not be run separately. .LINK https://SCCM.Zone/SW-Installed-Software-by-User-Selection .LINK https://SCCM.Zone/SW-Installed-Software-by-User-Selection-CHANGELOG .LINK https://SCCM.Zone/SW-Installed-Software-by-User-Selection-GIT .LINK https://SCCM.Zone/Issues */ /*##=============================================*/ /*## QUERY BODY */ /*##=============================================*/ /* #region QueryBody */ /* Testing variables !! Need to be commented for Production !! */ --DECLARE @UserSIDs AS NVARCHAR(10) = 'Disabled'; --DECLARE @CollectionID AS NVARCHAR(250) = 'HUB00095'; --DECLARE @SoftwareNameLike AS NVARCHAR(250) = 'Adobe%,WinZip%'; --DECLARE @SoftwareNameNotLike AS NVARCHAR(250) = 'Adobe Acrobat [1-8]%,7-zip%,%Fran_aise%'; /* Initialize SoftwareLike table */ DECLARE @SoftwareLike TABLE ( SoftwareName NVARCHAR(250) ) /* Initialize SoftwareNotLike table */ DECLARE @SoftwareNotLike TABLE ( SoftwareName NVARCHAR(250) ) /* Initialize InstalledSoftware table */ DECLARE @InstalledSoftware TABLE ( Device NVARCHAR(250) , Manufacturer NVARCHAR(250) , DeviceType NVARCHAR(50) , SerialNumber NVARCHAR(50) , Publisher NVARCHAR(250) , SoftwareName NVARCHAR(250) , Version NVARCHAR(50) , DomainOrWorkgroup NVARCHAR(100) , UserName NVARCHAR(100) , OperatingSystem NVARCHAR(100) ) /* Populate SoftwareLike table */ INSERT INTO @SoftwareLike (SoftwareName) SELECT StringValue FROM CM_Tools.dbo.ufn_csv_String_Parser(@SoftwareNameLike, ','); --!! Change the 'CM_Tools' database to your custom function database !! /* Populate SoftwareNotLike table */ INSERT INTO @SoftwareNotLike (SoftwareName) SELECT StringValue FROM CM_Tools.dbo.ufn_csv_String_Parser(@SoftwareNameNotLike, ','); --!! Change the 'CM_Tools' database to your custom function database !! /* Populate InstalledSoftware table */ INSERT INTO @InstalledSoftware (Device, Manufacturer, DeviceType, SerialNumber, Publisher, SoftwareName, Version, DomainOrWorkgroup, UserName, OperatingSystem) SELECT DISTINCT Device = Systems.Netbios_Name0 , 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 ) , SerialNumber = Enclosure.SerialNumber0 , Publisher = ( CASE WHEN Software.Publisher0 IS NULL THEN '<No Publisher>' WHEN Software.Publisher0 = '' THEN '<No Publisher>' WHEN Software.Publisher0 = '<no manufacturer>' THEN '<No Publisher>' ELSE Software.Publisher0 END ) , SoftwareName = COALESCE(NULLIF(Software.DisplayName0, ''), 'Unknown') , Version = COALESCE(NULLIF(Software.Version0, ''), 'Unknown') , DomainOrWorkgroup = Systems.Resource_Domain_OR_Workgr0 , UserName = Systems.User_Name0 , OperatingSystem = OS.Caption0 FROM fn_rbac_Add_Remove_Programs(@UserSIDs) AS Software JOIN v_R_System AS Systems ON Systems.ResourceID = Software.ResourceID JOIN v_ClientCollectionMembers AS CollectionMembers ON CollectionMembers.ResourceID = Systems.ResourceID JOIN v_GS_OPERATING_SYSTEM AS OS ON OS.ResourceID = Systems.ResourceID LEFT JOIN v_GS_SYSTEM_ENCLOSURE AS Enclosure ON Enclosure.ResourceID = Systems.ResourceID WHERE CollectionMembers.CollectionID = @CollectionID AND EXISTS ( SELECT SoftwareName FROM @SoftwareLike AS SoftwareLike WHERE Software.DisplayName0 LIKE SoftwareLike.SoftwareName ); /* Use NOT LIKE if needed */ IF EXISTS (SELECT SoftwareName FROM @SoftwareNotLike) BEGIN SELECT Device , Manufacturer , DeviceType , SerialNumber , Publisher , SoftwareName , Version , DomainOrWorkgroup , UserName , OperatingSystem FROM @InstalledSoftware AS InstalledSoftware WHERE NOT EXISTS ( SELECT SoftwareName FROM @SoftwareNotLike AS SoftwareNotLike WHERE InstalledSoftware.SoftwareName LIKE SoftwareNotLike.SoftwareName ) END; /* Otherwise perform a normal select */ ELSE BEGIN SELECT Device , Manufacturer , DeviceType , SerialNumber , Publisher , SoftwareName , Version , DomainOrWorkgroup , UserName , OperatingSystem FROM @InstalledSoftware END; /* #endregion */ /*##=============================================*/ /*## END QUERY BODY */ /*##=============================================*/ true Device System.String Manufacturer System.String DeviceType System.String SerialNumber System.String Publisher System.String SoftwareName System.String Version System.String DomainOrWorkgroup System.String UserName System.String OperatingSystem System.String CMReportServer =Parameters!ReportName.Value /* ReportDescription Dataset */ SELECT DISTINCT Description FROM ReportServer.dbo.Catalog WHERE Name = @ReportName Description System.String 1.47018in 8.35556in 0.4in true true =SrsResources.Localization.GetString("Description", User!Language) 2pt 2pt 2pt 2pt true true =SrsResources.Localization.GetString(Fields!Description.Value, User!Language) 5pt 2pt 2pt 2pt ReportDescription 0.03194in 0.127cm 0.4in 9.82574in 0.46065in 0.04887in 0in 18.85533in 1 1.5pt 1.5pt 1.5pt 1.5pt 1.5pt 1.83854cm 0.6cm true =Sum(CountDistinct(Fields!SoftwareName.Value)) BD_Device true =SrsResources.Localization.GetString("Total", User!Language) Black 1pt Black 1pt 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!SoftwareName.Value) WhiteSmoke Middle 2pt 2pt 2pt 2pt 0.6cm true true Textbox355 Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!Device.Value) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.73713cm true =Fields!Device.Value BD_Device true =SrsResources.Localization.GetString("Device", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 6.93965cm true =Fields!Publisher.Value BD_Publisher true =SrsResources.Localization.GetString("Publisher", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 11.20081cm true =Fields!Publisher.Value true =SrsResources.Localization.GetString("SoftwareName", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.76617cm true =Fields!Version.Value true =SrsResources.Localization.GetString("Version", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.56783cm true =Fields!Manufacturer.Value BD_Device true =SrsResources.Localization.GetString("Manufacturer", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.94979cm true =Fields!DeviceType.Value BD_Device true =SrsResources.Localization.GetString("DeviceType", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.63229cm true =Fields!SerialNumber.Value BD_Device true =SrsResources.Localization.GetString("SerialNumber", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.92334cm true =Fields!DomainOrWorkgroup.Value BD_Device true =SrsResources.Localization.GetString("Domain", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.55897cm true =Fields!UserName.Value BD_Device true =SrsResources.Localization.GetString("User", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 5.78083cm true =Fields!OperatingSystem.Value BD_Device true =SrsResources.Localization.GetString("OperatingSystem", 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!SerialNumber.Value =Fields!DomainOrWorkgroup.Value =Fields!OperatingSystem.Value 3.73713cm true true =Fields!Device.Value Top 2pt 2pt 2pt 2pt 6.93965cm true true Top 2pt 2pt 2pt 2pt 11.20081cm true true Top 2pt 2pt 2pt 2pt 2.76617cm true true Top 2pt 2pt 2pt 2pt 3.56783cm true true =Fields!Manufacturer.Value Top 2pt 2pt 2pt 2pt 2.94979cm true true =Fields!DeviceType.Value Top 2pt 2pt 2pt 2pt 2.63229cm true true =Fields!SerialNumber.Value Top 2pt 2pt 2pt 2pt 2.92334cm true true =Fields!DomainOrWorkgroup.Value Top 2pt 2pt 2pt 2pt 3.55897cm true true =Fields!UserName.Value Top 2pt 2pt 2pt 2pt 5.78083cm true true =Fields!OperatingSystem.Value Top 2pt 2pt 2pt 2pt After =Fields!Publisher.Value =Fields!Publisher.Value =Fields!SoftwareName.Value =Fields!Version.Value =Fields!Device.Value =Fields!Manufacturer.Value =Fields!DeviceType.Value =Fields!SerialNumber.Value =Fields!DomainOrWorkgroup.Value =Fields!UserName.Value =Fields!OperatingSystem.Value 6.93965cm true true =Fields!Publisher.Value WhiteSmoke Top 2pt 2pt 2pt 2pt 11.20081cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 2.76617cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 3.56783cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 2.94979cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 2.63229cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 2.92334cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 3.55897cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 5.78083cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt After =Fields!SoftwareName.Value =Fields!SoftwareName.Value =Fields!Version.Value 11.20081cm true true =Fields!SoftwareName.Value Top 2pt 2pt 2pt 2pt 2.76617cm true true =Fields!Version.Value Top 2pt 2pt 2pt 2pt 3.56783cm true true Top 2pt 2pt 2pt 2pt 2.94979cm true true Top 2pt 2pt 2pt 2pt 2.63229cm true true Top 2pt 2pt 2pt 2pt 2.92334cm true true Top 2pt 2pt 2pt 2pt 3.55897cm true true Top 2pt 2pt 2pt 2pt 5.78083cm true true Top 2pt 2pt 2pt 2pt true TV_BD_Publisher true TV_BD_Device 3.73713cm true true Total Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 6.93965cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 11.20081cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.76617cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.56783cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.94979cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.63229cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.92334cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.55897cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 5.78083cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt SoftwareData 1.2997cm 0.12413cm 3cm 47.89535cm 2 =IIF(Parameters!ReportBy.Value = "Device", False, True) 1.83854cm 0.6cm true =Sum(Count(Fields!Device.Value)) BP_Publisher 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!SoftwareName.Value) WhiteSmoke Middle 2pt 2pt 2pt 2pt 0.6cm true true =Count(Fields!SoftwareName.Value) Middle 2pt 2pt 2pt 2pt 0.6cm true true Textbox528 WhiteSmoke Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!Device.Value) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 6.93965cm true =Fields!Publisher.Value BP_Publisher true =SrsResources.Localization.GetString("Publisher", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 11.67224cm true =Fields!SoftwareName.Value BP_SoftwareName true =SrsResources.Localization.GetString("SoftwareName", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.2657cm true =Fields!Version.Value BP_SoftwareName true =SrsResources.Localization.GetString("Version", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.76617cm true =Fields!Device.Value true =SrsResources.Localization.GetString("Computer", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.56783cm true =Fields!Manufacturer.Value true =SrsResources.Localization.GetString("Manufacturer", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.94979cm true =Fields!DeviceType.Value true =SrsResources.Localization.GetString("DeviceType", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.63229cm true =Fields!SerialNumber.Value true =SrsResources.Localization.GetString("SerialNumber", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.92334cm true =Fields!DomainOrWorkgroup.Value true =SrsResources.Localization.GetString("Domain", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.55897cm true =Fields!UserName.Value true =SrsResources.Localization.GetString("User", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 5.78083cm true =Fields!OperatingSystem.Value true =SrsResources.Localization.GetString("OperatingSystem", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt =Fields!Publisher.Value =Fields!Publisher.Value =Fields!SoftwareName.Value =Fields!Version.Value =Fields!Device.Value =Fields!Manufacturer.Value =Fields!DeviceType.Value =Fields!SerialNumber.Value =Fields!DomainOrWorkgroup.Value =Fields!UserName.Value =Fields!OperatingSystem.Value 6.93965cm true true =Fields!Publisher.Value Top 2pt 2pt 2pt 2pt 11.67224cm true true Top 2pt 2pt 2pt 2pt 3.2657cm true true Top 2pt 2pt 2pt 2pt 2.76617cm true true Top 2pt 2pt 2pt 2pt 3.56783cm true true Top 2pt 2pt 2pt 2pt 2.94979cm true true Top 2pt 2pt 2pt 2pt 2.63229cm true true Top 2pt 2pt 2pt 2pt 2.92334cm true true Top 2pt 2pt 2pt 2pt 3.55897cm true true Top 2pt 2pt 2pt 2pt 5.78083cm true true Top 2pt 2pt 2pt 2pt After =Fields!SoftwareName.Value =Fields!SoftwareName.Value =Fields!Version.Value 11.67224cm true true =Fields!SoftwareName.Value WhiteSmoke Top 2pt 2pt 2pt 2pt 3.2657cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 2.76617cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 3.56783cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 2.94979cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 2.63229cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 2.92334cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 3.55897cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 5.78083cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt After =Fields!Version.Value 3.2657cm true true =Fields!Version.Value Top 2pt 2pt 2pt 2pt 2.76617cm true true Top 2pt 2pt 2pt 2pt 3.56783cm true true Top 2pt 2pt 2pt 2pt 2.94979cm true true Top 2pt 2pt 2pt 2pt 2.63229cm true true Top 2pt 2pt 2pt 2pt 2.92334cm true true Top 2pt 2pt 2pt 2pt 3.55897cm true true Top 2pt 2pt 2pt 2pt 5.78083cm true true Top 2pt 2pt 2pt 2pt 2.76617cm true true =Fields!Device.Value WhiteSmoke Top 2pt 2pt 2pt 2pt 3.56783cm true true =Fields!Manufacturer.Value WhiteSmoke Top 2pt 2pt 2pt 2pt 2.94979cm true true =Fields!DeviceType.Value WhiteSmoke Top 2pt 2pt 2pt 2pt 2.63229cm true true =Fields!SerialNumber.Value WhiteSmoke Top 2pt 2pt 2pt 2pt 2.92334cm true true =Fields!DomainOrWorkgroup.Value WhiteSmoke Top 2pt 2pt 2pt 2pt 3.55897cm true true =Fields!UserName.Value WhiteSmoke Top 2pt 2pt 2pt 2pt 5.78083cm true true =Fields!OperatingSystem.Value WhiteSmoke Top 2pt 2pt 2pt 2pt true TV_BP_Version true TV_BP_SoftwareName true TV_BP_Publisher 6.93965cm true true Total Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 11.67224cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.2657cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.76617cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.56783cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.94979cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.63229cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.92334cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.55897cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 5.78083cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt SoftwareData 4.32329cm 0.12413cm 3.6cm 47.89535cm 3 =IIF(Parameters!ReportBy.Value = "Publisher", False, True) 1.83854cm 0.6cm true =Sum(CountDistinct(Fields!Device.Value)) BS_SoftwareName 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!SoftwareName.Value) WhiteSmoke Middle 2pt 2pt 2pt 2pt 0.6cm true true Textbox528 Middle 2pt 2pt 2pt 2pt 0.6cm true true =CountDistinct(Fields!Device.Value) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 11.67224cm true =Fields!SoftwareName.Value BS_SoftwareName true =SrsResources.Localization.GetString("SoftwareName", User!Language) LightGrey Middle 2pt 2pt 2pt 2pt 6.91953cm true =Fields!Publisher.Value BS_Publisher true =SrsResources.Localization.GetString("Publisher", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.28582cm true =Fields!Version.Value BS_SoftwareName true =SrsResources.Localization.GetString("Version", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.76617cm true =Fields!Device.Value true =SrsResources.Localization.GetString("Computer", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.56783cm true =Fields!Manufacturer.Value true =SrsResources.Localization.GetString("Manufacturer", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.94979cm true =Fields!DeviceType.Value true =SrsResources.Localization.GetString("DeviceType", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.63229cm true =Fields!SerialNumber.Value true =SrsResources.Localization.GetString("SerialNumber", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.92334cm true =Fields!DomainOrWorkgroup.Value true =SrsResources.Localization.GetString("Domain", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.55897cm true =Fields!UserName.Value true =SrsResources.Localization.GetString("User", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 5.78083cm true =Fields!OperatingSystem.Value true =SrsResources.Localization.GetString("OperatingSystem", User!Language) Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt =Fields!SoftwareName.Value =Fields!SoftwareName.Value =Fields!Publisher.Value =Fields!Version.Value 11.67224cm true true =Fields!SoftwareName.Value Top 2pt 2pt 2pt 2pt 6.91953cm true true Top 2pt 2pt 2pt 2pt 3.28582cm true true Top 2pt 2pt 2pt 2pt 2.76617cm true true Top 2pt 2pt 2pt 2pt 3.56783cm true true Top 2pt 2pt 2pt 2pt 2.94979cm true true Top 2pt 2pt 2pt 2pt 2.63229cm true true Top 2pt 2pt 2pt 2pt 2.92334cm true true Top 2pt 2pt 2pt 2pt 3.55897cm true true Top 2pt 2pt 2pt 2pt 5.78083cm true true Top 2pt 2pt 2pt 2pt After =Fields!Publisher.Value 6.91953cm true true =Fields!Publisher.Value WhiteSmoke Top 2pt 2pt 2pt 2pt =Fields!Version.Value 3.28582cm true true =Fields!Version.Value WhiteSmoke Top 2pt 2pt 2pt 2pt 2.76617cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 3.56783cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 2.94979cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 2.63229cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 2.92334cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 3.55897cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt 5.78083cm true true WhiteSmoke Top 2pt 2pt 2pt 2pt =Fields!Device.Value =Fields!Manufacturer.Value =Fields!DeviceType.Value =Fields!SerialNumber.Value =Fields!DomainOrWorkgroup.Value =Fields!UserName.Value =Fields!OperatingSystem.Value 2.76617cm true true =Fields!Device.Value Top 2pt 2pt 2pt 2pt 3.56783cm true true =Fields!Manufacturer.Value Top 2pt 2pt 2pt 2pt 2.94979cm true true =Fields!DeviceType.Value Top 2pt 2pt 2pt 2pt 2.63229cm true true =Fields!SerialNumber.Value Top 2pt 2pt 2pt 2pt 2.92334cm true true =Fields!DomainOrWorkgroup.Value Top 2pt 2pt 2pt 2pt 3.55897cm true true =Fields!UserName.Value Top 2pt 2pt 2pt 2pt 5.78083cm true true =Fields!OperatingSystem.Value Top 2pt 2pt 2pt 2pt true TV_BS_Version true TV_BS_SoftwareName true TV_BS_SoftwareName 11.67224cm true true Total Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 6.91953cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.28582cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.76617cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.56783cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.94979cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.63229cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 2.92334cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 3.55897cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt 5.78083cm true true Black 1pt Black 1pt LightGrey Middle 2pt 2pt 2pt 2pt SoftwareData 7.94808cm 0.12413cm 3cm 47.89535cm 4 =IIF(Parameters!ReportBy.Value = "Software", False, True) 10.97453cm 48.182cm 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 0.60444in 0.05in 0in 18.86781in 1 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.12413cm 0.63492cm 2.79292cm 0.06944in 0.04887in 0in 18.86894in 1 1.5pt 1.5pt 1.5pt 1.5pt 1.5pt 21cm 29.7cm 2.54cm 2.54cm 2.54cm 2.54cm 1.27cm