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:

[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,