wmmayms

Simple report for counting IE versions



14 posts in this topic

Here you go:

 

SELECT ExecutableName0, ProductVersion0, count(*)

FROM
v_GS_INSTALLED_EXECUTABLE

WHERE ExecutableName0 = 'iexplore.exe'

GROUP BY ExecutableName0, ProductVersion0
Order by ExecutableName0

 

Example:

post-2500-12680569244951_thumb.png

Share this post


Link to post
Share on other sites


great stuff :)

 

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

 

should be easy enough to do or ?

Share this post


Link to post
Share on other sites

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%'

Share this post


Link to post
Share on other sites

cool and thanks :)

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

Hello.

 

No matching records could be found.

 

And i have the software inventory on

 

Thank you

Share this post


Link to post
Share on other sites

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.

 

Asset.jpg

 

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

Share this post


Link to post
Share on other sites

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.

 

post-3797-12850556703556_thumb.jpg

 

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 :)

Share this post


Link to post
Share on other sites

Hi Kingen,

You are trying the SQL queries in WQL Query tab. 'Queries' feature uses WQL queries which is the same used for SCCM Collection queries. Repoprting feature works on SQL. The queries given above are all SQL based and you need to try the same on the Reporting feature of SCCM.

 

Regards,

Rajeesh

http://scorpits.blogspot.com

Share this post


Link to post
Share on other sites

Hi guys,

 

Im new to SQL queries. My management are asking me for a report to show what IEs we have and how many.

I need to do a custom report and point it to a collection to get the data from. How can I do this ?

 

Appreciate your help

 

Regards,

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now