Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

Can someone provide me with a query for an Altiris filter to find machines WITH IE10 installed

Created: 07 Aug 2014 | 11 comments

Would much appreciate it

Operating Systems:

Comments 11 CommentsJump to latest comment

Igor Perevozchikov's picture

Try this information to create a required filter

  1. Don't forget that, first you can find an answer for your question in Knowledge base
  2. If answer solves your question, then please mark as solution to close a thread
ericg2's picture

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')

 

Scott W. Allen's picture

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.

ericg2's picture

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%'
 

Scott W. Allen's picture

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

ericg2's picture

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

JoeVan's picture

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.%'
 

Joe VanHollebeke
Systems Engineer

Papa-Gio's picture

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.%'

 

John A.

Papa-Gio's picture

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]

John A.

WDRAIN1's picture

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

select

case

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'

and

(

inv.Path = 'C:\Program Files (x86)\Internet Explorer'

or

inv.Path = 'C:\Program Files\Internet Explorer'

)

group by

case

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

with rollup