IE Version report?

[BrianM]

Looking for a report that shows all computers that are on IE11. Anyone have one already built? I am not at all familiar with SQL, and have been looking around for one, but only found one that showed version. Not Asset Name. Tried the one below, but all it reports back is version. Can't find where to add Asset Name without getting the error "In aggregate and grouping expressions, the SELECT clause can contain only aggregates and grouping expressions. [ Select clause = tblSoftwareUni,softwareName ]"

Just needs to show IE version & Asset Name.

Select tblSoftware.softwareVersion As IEVersion,
Count(tblAssets.AssetID) As Total
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like N'windows internet explorer%'
Group By tblSoftware.softwareVersion
Order By Total

[BrianM]

Ah. Found it. By putting in the search field Internet Explorer 11 it shows all the different version (patches) put onto IE11, not just 11.0.9600.17207 or just 11.0.9600.17126 ...

[Hemoco]

We don't understand your question. The specified report lists all IE11 installations (on machines whose state is set to "active").

[BrianM]

Only problem is that it shows them with the different versions or updates in IE 11. I want a report that shows them all.

[Hemoco · Accepted solution]

You should be able to perform a search for "Internet Explorer 11" in the web console search bar to view a built-in IE11 report.