компьютеры с Internet Explorer
Компьютеры с IE 8:
SELECT TOP (100) PERCENT dbo.v_R_System.Name0 AS [Computer name], dbo.v_R_System.User_Name0 AS [User name],
dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 AS [IE name]
FROM dbo.v_R_System INNER JOIN
dbo.v_GS_ADD_REMOVE_PROGRAMS ON dbo.v_R_System.ResourceID = dbo.v_GS_ADD_REMOVE_PROGRAMS.ResourceID
WHERE (dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 = ‘Windows Internet Explorer 8’)
ORDER BY [Computer name]
Компьютеры с IE 9:
SELECT DISTINCT
TOP (100) PERCENT dbo.v_R_System.Name0 AS [Computer name], dbo.v_R_System.User_Name0 AS [User name], dbo.v_GS_SoftwareFile.FileName AS [IE name],
dbo.v_GS_SoftwareFile.FileVersion AS [IE version]
FROM dbo.v_GS_SoftwareFile INNER JOIN
dbo.v_R_System ON dbo.v_GS_SoftwareFile.ResourceID = dbo.v_R_System.ResourceID
WHERE (dbo.v_GS_SoftwareFile.FileName = ‘iexplore.exe’) AND (dbo.v_GS_SoftwareFile.FileVersion LIKE ‘9.%’)
ORDER BY [Computer name]