Jump to content


  • 0
wmmayms

Simple report for counting IE versions

Question

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

Recommended Posts

  • 0

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

  • 0

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

  • 0

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

  • 0

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

  • 0

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.