Client Management Suite

Would much appreciate it

Try this information to create a required filter

• https://www-secure.symantec.com/connect/forums/how-get-report-altiris-71#comment-8284511
• https://www-secure.symantec.com/connect/forums/creating-software-installed-report
• http://www.symantec.com/docs/HOWTO84095

See this thread and articles

Inventory, Reporting, and Filtering of Internet Explorer in Inventory Solution 7.x

https://www-secure.symantec.com/connect/articles/inventory-reporting-and-filtering-internet-explorer-inventory-solution-7x

Report for Internet Explorer Version

https://www-secure.symantec.com/connect/forums/report-internet-explorer-version

If you don't want to read those article and just get a raw query, that one should fit your request

select p._ResourceGuid from Inv_AddRemoveProgram p
where p.DisplayName in ('internet explorer','windows internet explorer 10','internet explorer 10')
and p.DisplayVersion like '10%'
and p.Publisher in ('microsoft','microsoft corporation')

I get no results from your query. Nor do I get any if I cange the 10's to 11's or 9's. I do get seven results when I change it to 8.

use this query in sql studio or a report to identify what you need as a filter for your environment

select distinct p.DisplayName,p.DisplayVersion,p.Publisher from Inv_AddRemoveProgram p
where p.DisplayName like '%internet explorer%'
 

IE 9, 10 and 11 don't show up in this new query. Not even updates for it.

Yes that's what i also realized... internet explorer is a windows feature and not listed in add remove program.  You will have to rely on detection rules to feed the catalog then have a query that basicly show the same list you would get in the software catalog.  The query is not that complicated but now it all depends on how you manage your software catalog.

The first step for you would be to create a software release for Internet explorer 10.  I will not repeat everything because it's all very clearly described in the link provided by James007

If you have Software inventory enabled, you can use this filter query:

-- IE 10 (file based)

select distinct [vif].[_ResourceGuid]
  FROM [RMV_Installed_File_Inventory] vif
  where [File Name] = 'iexplore.exe'
 and  [Product Version] like '10.%'
 

I use a simple template for all my Add/Remove SQL queries.  Here is what I use to find IE10 only systems....

SELECT DISTINCT vc.Guid, vc.Name, vc.[OS Name], vc.[System Type], vc.[User]

,IsManaged AS 'Managed'

,[dca2_AddRemoveProgram].[DisplayName] as 'Application name'

,[dca2_AddRemoveProgram].[DisplayVersion] as 'App Version'


FROM vComputer vc

LEFT OUTER JOIN [Inv_AddRemoveProgram] AS [dca2_AddRemoveProgram]

ON ([vc].[Guid] = [dca2_AddRemoveProgram].[_ResourceGuid])

WHERE

IsManaged = 1 

and [dca2_AddRemoveProgram].[DisplayName] like '%Internet Explorer 10%'

and [dca2_AddRemoveProgram].[DisplayVersion] like '10.%'

Internet Explorer 10 may not be listed in the Add/Remove listing of a PC, however, the entry for the Windows components (i.e. Windows Internet Explorer 10) and it's version number ARE catalogued in the Add/Remove table:

Application Name = [Inv_AddRemoveProgram].[DisplayName]

App Version = [Inv_AddRemoveProgram].[DisplayName]

Here is simple SQL query that can be put in a Altiris Report summarizes the number of Internet Explorer installs...