Отображает список компьютеров и антивирусных решений обнаруженных на основе Центра обеспечения безопасности Windows. 0 /ConfigMgr_CM1/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602} None 26ab293a-e677-41fa-b540-e18324326ed6 DataSource2 =Parameters!UserTokenSIDs.Value select dbo.fn_rbac_GetAdminIDsfromUserSIDs(@UserTokenSIDs) as UserSIDs UserSIDs System.String DataSource2 =Parameters!UserSIDs.Value -- DECLARE @UserSIDs NVARCHAR(max) = '16777218' 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) DataSource2 =Parameters!UserSIDs.Value =Parameters!CollID.Value =Parameters!CompName.Value -- DECLARE @UserSIDs NVARCHAR(max) = N'disabled', @CollID NVARCHAR(max) = 'SMS00001', @CompName NVARCHAR(max) = N'%LE-%' SELECT DISTINCT SYS.Netbios_Name0 AS 'Netbios Name' , HSUSB.Caption0 , HSUSB.Description0 , HSUSB.Service0 , HSUSB.DeviceID0 , HSUSB.[TimeStamp] -- , convert (varbinary, AV.productState0) -- , AV.timestamp0 AS 'AV Timestamp' FROM fn_rbac_R_System(@UserSIDs) SYS JOIN fn_rbac_ClientCollectionMembers(@UserSIDs) Members ON SYS.ResourceID = Members.ResourceID LEFT JOIN v_HS_USB_DEVICE HSUSB ON SYS.ResourceID = HSUSB.ResourceID WHERE Members.CollectionID = @CollID AND SYS.Netbios_Name0 like @CompName true Netbios Name System.String Caption0 System.String Description0 System.String Service0 System.String TimeStamp System.DateTime DeviceID0 System.String 1.38542in 1.125in 1.29249in 1.70668in 1.37624in 0.25in true true =Fields!Netbios_Name.Value 1.5pt 1.5pt White Middle 5pt 5pt 5pt 5pt true true Caption0 Textbox1 1.5pt 1.5pt White Middle 5pt 5pt 5pt 5pt true true Description0 Textbox4 1.5pt 1.5pt White Middle 5pt 5pt 5pt 5pt true true Service0 Textbox2 1.5pt 1.5pt White Middle 5pt 5pt 5pt 5pt true true Previous frequency Time Stamp 1.5pt 1.5pt White Middle 5pt 5pt 5pt 5pt 0.25in true true =Fields!Netbios_Name.Value ../Оборудование - Общее/Сведения об определенном компьютере =Fields!Netbios_Name.Value =iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro") Middle 2pt 2pt 2pt 2pt true true =Fields!Caption0.Value Caption0 =iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro") Middle 2pt 2pt 2pt 2pt true true =Fields!Description0.Value =iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro") Middle 2pt 2pt 2pt 2pt true true =Fields!DeviceID0.Value DeviceID0 =iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro") Middle 2pt 2pt 2pt 2pt true true =Fields!TimeStamp.Value =iif(RowNumber(Nothing) Mod 2, "Transparent", "Gainsboro") Middle 2pt 2pt 2pt 2pt After true true Detail Detail_Collection Output true DataSetMain 0.3675in 0in 0.5in 6.88583in Tahoma 8pt Normal None General Top 1.25in 5.74in 0.4in true true =SrsResources.Localization.GetString("Description", User!Language) Gainsboro 2pt 2pt 2pt 2pt true true USB Gainsboro 5pt 2pt 2pt 2pt DataSetMain 0in 0.4in 6.99in true 0in 0in 0.4in 6.99in 1 Gainsboro 0.25in 0in 0in 6.99in 2 1.5pt 1.5pt 1.5pt 1.5pt 1.5pt 0.8675in External /ConfigMgr_M02/Report Resources/Report_Header_Left.png 0.01389in 0in 0.75in 0.21in 1 External /ConfigMgr_M02/Report Resources/Report_Header_Right.png FitProportional 0.01389in 4.63583in 0.75in 2.35417in 2 true true USB Textbox54 0.75in 0in 0.35in 6.99in 3 Gainsboro 2pt 2pt 2pt 2pt true 0in 0in 1.1in 6.99in #e2e9f2 0.45in true true 1in 1in 1in 1in