0
/ConfigMgr_M02/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}
None
3c6df09e-eeff-4d82-bf47-97287ce573a4
DataSource1
=Parameters!UserSIDs.Value
=Parameters!CollID.Value
=Parameters!GlobalUnknown.Value
-- DECLARE @UserSIDs NVARCHAR(max) = N'disabled', @CollID NVARCHAR(max) = 'M02003BA', @UnknownLoc NVARCHAR(max) = 'Unknown'
Select distinct
v_R_System_Valid_Alias.Netbios_Name0 AS [Computer Name],
v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.NormalizedName AS [Product Name],
[Publisher] = CASE when (ISNULL(v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.NormalizedPublisher, N'-1') = N'-1') then @UnknownLoc
Else v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.NormalizedPublisher
End,
[Version] = CASE when (ISNULL(v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.NormalizedVersion, N'-1') = N'-1') then @UnknownLoc
Else v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.NormalizedVersion
End,
[Language] = CASE when (ISNULL(v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.Language0, -1) < 0) then @UnknownLoc
Else CAST(v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.Language0 as nvarchar)
End,
ISNULL(v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.InstallType0, 0) as [Installation Type],
v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.FamilyName AS [Product Family],
v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.CategoryName AS [Product Category],
v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.ProductID0 AS [ProductID],
v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.SoftwareID as [Software ID],
v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.CM_DSLID0 AS [DSL ID],
[Installed Location] = CASE when (ISNULL(v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.InstalledLocation0, N'-1') = N'-1') then @UnknownLoc
Else v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.InstalledLocation0
End,
[Install Source] = CASE when (ISNULL(v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.InstallSource0, N'-1') = N'-1') then @UnknownLoc
Else v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.InstallSource0
End,
[Uninstall String] = CASE when (ISNULL(v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.UninstallString0, N'-1') = N'-1') then @UnknownLoc
Else v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.UninstallString0
End,
v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.InstallDate0 AS [Install Date],
[Registered User] = CASE when (ISNULL(v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.RegisteredUser0, N'-1') = N'-1') then @UnknownLoc
Else v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.RegisteredUser0
End
FROM fn_rbac_GS_INSTALLED_SOFTWARE_CATEGORIZED(@UserSIDs) v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias
INNER JOIN fn_rbac_R_System_Valid(@UserSIDs) v_R_System_Valid_Alias
ON v_R_System_Valid_Alias.ResourceID = v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.ResourceID
INNER JOIN fn_rbac_ClientCollectionMembers(@UserSIDs) Members
ON Members.ResourceID = v_R_System_Valid_Alias.ResourceID
Where Members.CollectionID = @CollID
order by v_R_System_Valid_Alias.Netbios_Name0, v_GS_INSTALLED_SOFTWARE_CATEGORIZED_Alias.NormalizedName, Publisher, Version
Computer Name
System.String
Product Name
System.String
Publisher
System.String
Version
System.String
Language
System.String
Installation Type
System.Int32
Product Family
System.String
Product Category
System.String
ProductID
System.String
Software ID
System.String
DSL ID
System.String
Installed Location
System.String
Install Source
System.String
Uninstall String
System.String
Install Date
System.DateTime
Registered User
System.String
DataSource1
=Parameters!UserTokenSIDs.Value
select dbo.fn_rbac_GetAdminIDsfromUserSIDs(@UserTokenSIDs) as UserSIDs
UserSIDs
System.String
DataSource1
=Parameters!UserSIDs.Value
-- DECLARE @UserSIDs NVARCHAR(max) = N'disabled'
SELECT
CollRBAC.CollectionID
, CollRBAC.Name
FROM
fn_rbac_Collection(@UserSIDs) CollRBAC
WHERE
CollRBAC.CollectionType = 2
ORDER BY CollRBAC.Name
CollectionID
System.String
Name
System.String
=SrsResources.Localization.GetDBString(Fields!CollectionName.Value, User!Language)
1.95in
1.25in
1.25in
1.25in
1.54in
2.15in
2in
2.47in
4.03in
2.02in
2.45in
2.03in
2.76in
1.62in
3.29in
0.25in
true
=Fields!ProductName.Value
true
=SrsResources.Localization.GetString("ProductName", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
=Fields!Publisher.Value
true
=SrsResources.Localization.GetString("Publisher", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
=Fields!Version.Value
true
=SrsResources.Localization.GetString("Version", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
=Fields!Language.Value
true
=SrsResources.Localization.GetString("Language", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
=Fields!InstallationType.Value
true
=SrsResources.Localization.GetString("InstallationType", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
=Fields!ProductFamily.Value
true
=SrsResources.Localization.GetString("ProductFamily", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
=Fields!ProductCategory.Value
true
=SrsResources.Localization.GetString("ProductCategory", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
=Fields!ProductID.Value
true
=SrsResources.Localization.GetString("ProductID", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
=Fields!SoftwareID.Value
true
=SrsResources.Localization.GetString("SoftwareID", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
=Fields!DSLID.Value
true
=SrsResources.Localization.GetString("DSLID", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
=Fields!InstalledLocation.Value
true
=SrsResources.Localization.GetString("InstalledLocation", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
=Fields!InstallSource.Value
true
=SrsResources.Localization.GetString("InstallSource", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
=Fields!UninstallString.Value
true
=SrsResources.Localization.GetString("UninstallString", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
=Fields!InstallDate.Value
true
=SrsResources.Localization.GetString("InstallDate", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
=Fields!RegisteredUser.Value
true
=SrsResources.Localization.GetString("RegisteredUser", User!Language)
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
0.25in
true
true
=Fields!ProductName.Value
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
true
true
=Fields!Publisher.Value
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
true
true
=Fields!Version.Value
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
true
true
=Fields!Language.Value
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
true
true
=IIf(Fields!InstallationType.Value = 0, Parameters!GlobalInsType0.Value, Parameters!GlobalInsType1.Value)
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
true
true
=Fields!ProductFamily.Value
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
true
true
=Fields!ProductCategory.Value
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
true
true
=Fields!ProductID.Value
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
true
true
=Fields!SoftwareID.Value
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
true
true
=Fields!DSLID.Value
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
true
true
=Fields!InstalledLocation.Value
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
true
true
=Fields!InstallSource.Value
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
true
true
=Fields!UninstallString.Value
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
true
true
=IIf(IsNothing(Fields!InstallDate.Value), "", FormatDateTime(Fields!InstallDate.Value, DateFormat.ShortDate))
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
true
true
=Fields!RegisteredUser.Value
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
1.79in
true
true
=SrsResources.Localization.GetString("ComputerName", User!Language)
Textbox39
1.5pt
1.5pt
White
Bottom
5pt
5pt
5pt
5pt
true
After
true
=Fields!ComputerName.Value
=Fields!ComputerName.Value
1.79in
true
true
=Fields!ComputerName.Value
ComputerName
Silver
=iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro")
Top
5pt
5pt
5pt
5pt
Detail
Detail_Collection
Output
true
DataSetMain
0.33in
0.5in
33.85in
Tahoma
8pt
Normal
None
General
Top
1.25in
32.35in
0.4in
true
true
=SrsResources.Localization.GetString("Description", User!Language)
Textbox16
Gainsboro
2pt
2pt
2pt
2pt
true
true
=SrsResources.Localization.GetString("Report50_Description", User!Language)
Textbox18
true
DescriptionLabelTextbox
Gainsboro
5pt
2pt
2pt
2pt
DataSetMain
0.4in
33.6in
true
0.4in
33.85in
1
Gainsboro
0.25in
0in
33.85in
2
1.5pt
1.5pt
1.5pt
1.5pt
1.5pt
1.75in
33.85in
1.1in
true
true
External
/ConfigMgr_M02/Report Resources/Report_Header_Center.png
Fit
0.21in
0.75in
31.3in
External
/ConfigMgr_M02/Report Resources/Report_Header_Right.png
31.51in
0.75in
2.34in
1
External
/ConfigMgr_M02/Report Resources/Report_Header_Left.png
0.75in
0.21in
2
true
0.75in
33.85in
#e2e9f2
true
true
=SrsResources.Localization.GetString("Report50_Name", User!Language) + " "
Textbox54
0.75in
0.35in
33.85in
1
Gainsboro
2pt
2pt
2pt
2pt
0.45in
true
true
11in
8.5in
1in
1in
1in
1in
String
=SrsResources.UserIdentity.GetUserSIDs(User!UserID)
true
String
DataSetAdminID
UserSIDs
true
String
=SrsResources.Localization.GetString("Unknown", User!Language)
true
true
String
=SrsResources.Localization.GetString("InstallationType0", User!Language)
true
true
String
=SrsResources.Localization.GetString("InstallationType1", User!Language)
true
true
String
Коллекция
CollectionInfo
CollectionID
Name
=User!Language
SrsResources, culture=neutral
true
Inch
https://scsql-srv03.dom.maria.o/ReportServer
683b1c9f-1856-4072-bc64-619c15d3eeaf