Simple report for counting IE versions

[wmmayms]

Here you go:

 

SELECT ExecutableName0, ProductVersion0, count(*)

FROM
v_GS_INSTALLED_EXECUTABLE

WHERE ExecutableName0 = 'iexplore.exe'

GROUP BY ExecutableName0, ProductVersion0
Order by ExecutableName0

 

Example:

[anyweb]

great stuff

 

and if we wanted to have two reports for counting IE6 and IE8 ?

[wmmayms]

great stuff

 

and if we wanted to have two reports for counting IE6 and IE8 ?

 

I don´t understand how you mean.

Do you want a report that combines all versions so you only see version 6 and version 8?

[anyweb]

ok lets just say we want one to count all versions of ie8

 

should be easy enough to do or ?

[wmmayms]

ok lets just say we want one to count all versions of ie8

 

should be easy enough to do or ?

 

Yes

 

just add the part in red:

 

SELECT ExecutableName0, ProductVersion0, count(*)

FROM

v_GS_INSTALLED_EXECUTABLE

WHERE ExecutableName0 = 'iexplore.exe' and ProductVersion0 LIKE '8%'

GROUP BY ExecutableName0, ProductVersion0

Order by ExecutableName0

 

 

To make it count all instances of just IE 6 just change the '8%' to '6%'

[anyweb]

cool and thanks

[flyingbirds]

Am in new in reporting & SCCM , I tried to create a new report and add this to SQL statement but there is result when running the report.

may be I forgot something I don't know?

[Eswar Koneti]

Am in new in reporting & SCCM , I tried to create a new report and add this to SQL statement but there is result when running the report.

may be I forgot something I don't know?

 

the question is to be no Result isn't it ? Do you see any error or blank web page ? check if you have software inventory enabled for .exe?

[YiannosG]

Hello.

 

No matching records could be found.

 

And i have the software inventory on

 

Thank you

[Eswar Koneti]

Hello.

 

No matching records could be found.

 

And i have the software inventory on

 

Thank you

 

 

Do you have Asset intelliegence enabled in your site since v_GS_INSTALLED_EXECUTABLE View Lists information about the installed software application executables on Configuration Manager clients found through Asset Intelligence.

 

 

To get the list of Iexplore versions,use this syntax:

 

 select filename as "executable name",left(FileVersion,14)as "File Version",COUNT(*)as Total from v_GS_SoftwareFile where FileName='iexplore.exe'
group by FileName,FileVersion 

 

More on Iexplore here

[YiannosG]

Do you have Asset intelliegence enabled in your site since v_GS_INSTALLED_EXECUTABLE View Lists information about the installed software application executables on Configuration Manager clients found through Asset Intelligence.

 

 

To get the list of Iexplore versions,use this syntax:

 

 select filename as "executable name",left(FileVersion,14)as "File Version",COUNT(*)as Total from v_GS_SoftwareFile where FileName='iexplore.exe'
group by FileName,FileVersion 

 

More on Iexplore here

 

 

Thx for clearing it out