Query Windows 7 64bit PCs with IE11 Installed - Problems

Hello All,

I have been trying to create a query that will tell me what PCs have IE11 installed on them.  I have tried various angles at doing this but I cannot get anything to display...even though we have 15 PCs with IE11 installed.  Normally I use Simple Value, Installed Applications, Display Name and then pick the name.  But IE10 and 11 are not listed. 

So I went a different path where I tried using Software Files. File Name = "iexplore.exe" and Software.File Version is like "11.%"

I tried using Installed Executable with basically the same properties as above with no results.  At one point I was able to get 1 PC to display but that was it.

does anyone have any suggestions.

Thanks,

Rich

April 28th, 2015 3:19pm

Hi,

Can you the statement of the query?

You can try thisview:   v_GS_Software_Shortcut

How to Query for Internet Explorer 9 , Internet Exploer 10, Internet Explorer 11 using SCCM2012    

You can also check registry key or file versions by using compliance settings

Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 3:13am
have you enabled SCCM software inventory to scan for *.exe files?
April 29th, 2015 4:16am
have you enabled SCCM software inventory to scan for *.exe
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 4:29am

For File Inventory you should discover iexplore.exe in %programfiles(x86)% and %Programfiles%. Dont forget to shedule Inventory on the Client Agent. Default should be 1x/Day

You can find it with an SSRS Web Report if File inventory is on. You can also put the Query in SQL Management Studio for a quick result.

All Versions of IE on specific OS:

select 
    SF.FileName,
    OS.Caption0,
    replace(left(SF.FileVersion,2), '.','') as 'IE Version',
    Count (Distinct SF.ResourceID) as 'Total'
From 
    dbo.v_GS_SoftwareFile SF 
    JOIN v_FullCollectionMembership fcm on SF.ResourceID=fcm.ResourceID
    JOIN dbo.v_GS_OPERATING_SYSTEM OS ON SF.ResourceID = OS.ResourceID
    join dbo.v_GS_SYSTEM S on SF.ResourceID = S.ResourceID
Where 
    SF.FileName = 'iexplore.exe' 
    and SF.FilePath like '%Internet Explorer%'
    and S.SystemRole0 = 'Workstation'
Group by 
    SF.FileName, 
    OS.Caption0,
    replace(left(SF.FileVersion,2), '.','')
Order by 
    2

Source was from Garth Jones.



  • Edited by Afraskai 21 hours 50 minutes ago
April 29th, 2015 5:20am

Personally, I'm not a fan of software inventory when I can use hardware inventory instead: http://mnscug.org/blogs/sherry-kissinger/330-internet-explorer-version-information-via-hardware-inventory

Note that Afraskai's answer will work just fine.  I just prefer hardware inventory methods.

Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 8:50am

We have software and hardware inventory enabled.  Software is tracking .exe and when I do a query for iexplore.exe it returns all the PCs on our network.  It is just when I try to specify the version I lose the data.

I had not thought about using a report and probably should go that route and I need to hand this out to our IT Support Helpdesk group.  I am not allowed to SQL edits in my role so I'll check with our DB guys.

Not sure Why I cannot use a PC query though when I have the correct info in there.

April 29th, 2015 9:13am

For File Inventory you should discover iexplore.exe in %programfiles(x86)% and %Programfiles%. Dont forget to shedule Inventory on the Client Agent. Default should be 1x/Day

You can find it with an SSRS Web Report if File inventory is on. You can also put the Query in SQL Management Studio for a quick result.

All Versions of IE on specific OS:

select 
    SF.FileName,
    OS.Caption0,
    replace(left(SF.FileVersion,2), '.','') as 'IE Version',
    Count (Distinct SF.ResourceID) as 'Total'
From 
    dbo.v_GS_SoftwareFile SF 
    JOIN v_FullCollectionMembership fcm on SF.ResourceID=fcm.ResourceID
    JOIN dbo.v_GS_OPERATING_SYSTEM OS ON SF.ResourceID = OS.ResourceID
    join dbo.v_GS_SYSTEM S on SF.ResourceID = S.ResourceID
Where 
    SF.FileName = 'iexplore.exe' 
    and SF.FilePath like '%Internet Explorer%'
    and S.SystemRole0 = 'Workstation'
Group by 
    SF.FileName, 
    OS.Caption0,
    replace(left(SF.FileVersion,2), '.','')
Order by 
    2

Source was from Garth Jones.



  • Edited by Afraskai Wednesday, April 29, 2015 9:53 AM
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 9:19am

Personally, I'm not a fan of software inventory when I can use hardware inventory instead: http://mnscug.org/blogs/sherry-kissinger/330-internet-explorer-version-information-via-hardware-inventory

Note that Afraskai's answer will work just fine.  I just prefer hardware inventory me

April 29th, 2015 9:19am

I was able to get it to work this morning with the same basic settings inside of Monitoring - Queries like my OP shows.  Not sure why it seems to be working today vs two days ago.  Here is the Query

select distinct SMS_R_System.Name, SMS_G_System_SoftwareFile.FileName, SMS_G_System_SoftwareFile.FileVersion from  SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FileVersion like "11.%"

Displayed

Thanks for the alternate options but this is the best way for me.

Rich

Free Windows Admin Tool Kit Click here and download it now
April 30th, 2015 9:39am

I was able to get it to work this morning with the same basic settings inside of Monitoring - Queries like my OP shows.  Not sure why it seems to be working today vs two days ago.  Here is the Query

select distinct SMS_R_System.Name, SMS_G_System_SoftwareFile.FileName, SMS_G_System_SoftwareFile.FileVersion from  SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FileVersion like "11.%"

Displayed

Thanks for the alternate options but this is the best way for me.

Rich

  • Marked as answer by richard keel Thursday, April 30, 2015 2:32 PM
April 30th, 2015 1:37pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics