→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kingskawn
Engaged Sweeper
I need to make a report to see the IE version (6/7/8/9/10/11) but ordered by domain name.
Can this be done?

Example:

Domain name Count Version
Domain A 223 IE9
Domain B 459 IE8
Domain A 353 IE10
Domain C 105 IE8
Domain A 704 IE8
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
SELECT
Top 1000000
tblAssets.Domain,
tblSoftwareUni.softwareName,
Count(*) AS Total
FROM
tblAssets
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
INNER JOIN tblSoftware ON tblAssets.AssetID = tblSoftware.AssetID
INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.softID
WHERE
tblAssetCustom.State = 1
AND tblSoftwareUni.softwareName LIKE 'Windows Internet Explorer%'
GROUP BY
tblAssets.Domain,
tblSoftwareUni.softwareName

View solution in original post

2 REPLIES 2
kingskawn
Engaged Sweeper
Wow, very nice RC62N. It worked directly! Thanks a lot
RCorbeil
Honored Sweeper II
SELECT
Top 1000000
tblAssets.Domain,
tblSoftwareUni.softwareName,
Count(*) AS Total
FROM
tblAssets
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
INNER JOIN tblSoftware ON tblAssets.AssetID = tblSoftware.AssetID
INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.softID
WHERE
tblAssetCustom.State = 1
AND tblSoftwareUni.softwareName LIKE 'Windows Internet Explorer%'
GROUP BY
tblAssets.Domain,
tblSoftwareUni.softwareName