13 replies to this topic

[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

[Kingen]

Does not work for me :



Am i doing something wrong?

[wanafly]

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

[Kemixn]

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,