→ 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: 
BrianM
Engaged Sweeper III
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

4 REPLIES 4
BrianM
Engaged Sweeper III
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
Lansweeper Alumni
We don't understand your question. The specified report lists all IE11 installations (on machines whose state is set to "active").
BrianM
Engaged Sweeper III
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
Lansweeper Alumni
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.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now