0
/ConfigMgr_M02/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}
None
11111111-1111-1111-1111-111111111111
AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_
SELECT
SYS.Name0 AS Computer
, VGL.Name0 AS [Group]
, VGL.Account0 AS Account
, VGL.Category0 AS Category
, VGL.Type0 AS Type
, VGL.Domain0 AS Domain
, SYS.Operating_System_Name_and0
FROM
v_GS_LocalGroupMembers0 VGL
INNER JOIN v_R_System SYS
ON VGL.ResourceID = SYS.ResourceID
JOIN v_ClientCollectionMembers Members
ON SYS.ResourceID = Members.ResourceID
WHERE
Members.CollectionID = @CollID
(
VGL.Name0 = N'Administrators' OR VGL.Name0 = N'Администраторы'
)
true
Computer
System.String
Group
System.String
Account
System.String
Category
System.String
Type
System.String
Domain
System.String
Operating_System_Name_and0
System.String
AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_
SELECT
CollRBAC.CollectionID
, CollRBAC.Name
FROM
v_Collection CollRBAC
WHERE
CollRBAC.CollectionType = 2
ORDER BY CollRBAC.Name
CollectionID
true
Name
true
=SrsResources.Localization.GetDBString(Fields!CollectionName.Value, User!Language)
1.625in
2.01042in
1.90625in
1.3125in
1in
1.30208in
0.25in
true
true
Computer
Textbox2
#4c68a2
2pt
2pt
2pt
2pt
true
true
Group
Textbox3
#4c68a2
2pt
2pt
2pt
2pt
true
true
Account
Textbox5
#4c68a2
2pt
2pt
2pt
2pt
true
true
Category
Textbox7
#4c68a2
2pt
2pt
2pt
2pt
true
true
Type
Textbox9
#4c68a2
2pt
2pt
2pt
2pt
true
true
Domain
Textbox11
#4c68a2
2pt
2pt
2pt
2pt
0.25in
true
true
=Fields!Computer.Value
Computer
2pt
2pt
2pt
2pt
true
true
=Fields!Group.Value
Group
2pt
2pt
2pt
2pt
true
true
=Fields!Account.Value
Account
2pt
2pt
2pt
2pt
true
true
=Fields!Category.Value
Category
2pt
2pt
2pt
2pt
true
true
=Fields!Type.Value
Type
2pt
2pt
2pt
2pt
true
true
=Fields!Domain.Value
Domain
2pt
2pt
2pt
2pt
After
DataSet1
0.6in
0.5in
9.15625in
2.25in
9.27083in
0.45in
true
true
1in
1in
1in
1in
String
SMS00001
Коллекция
CollectionInfo
CollectionID
Name
SrsResources, culture=neutral
Inch
https://scsql-srv03.dom.maria.o/ReportServer
6fbd236a-d836-4950-8788-14b828deb616