Would much appreciate it
Try this information to create a required filter
See this thread and articles
Inventory, Reporting, and Filtering of Internet Explorer in Inventory Solution 7.x
Report for 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])
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...
when inv.[Product Version] like '6.00%' then 'Internet Explorer 6'
when inv.[Product Version] like '7.00%' then 'Internet Explorer 7'
when inv.[Product Version] like '8.00%' then 'Internet Explorer 8'
when inv.[Product Version] like '9.00%' then 'Internet Explorer 9'
when inv.[Product Version] like '10.00%' then 'Internet Explorer 10'
when inv.[Product Version] like '11.00%' then 'Internet Explorer 11'
else inv.[Product Version]
end [Internet Explorer Versions]
,COUNT(*) as Count
from RMV_Installed_File_Inventory inv
where inv.[File Name] = 'iexplore.exe'
inv.Path = 'C:\Program Files (x86)\Internet Explorer'
inv.Path = 'C:\Program Files\Internet Explorer'