Hi there,

I need a SQL query that will give me the version of IE installed on all the pc's on our network.

please see below a picture from the registry this is the info that I need on the report:

 

I need this info on a report for all 14 000 clients on our network.

Can anyone plase assist?

Regards,

 

 

Answer Summary:
Cancel
2 Comments   [ + ] Show Comments

Comments

  • What tool are you using to gather the data? Kace?
  • Hi Sorry, Yes we do use KACE
Please log in to comment

Community Chosen Answer

3

I use the registry keys for my custom software inventory

RegistryValueReturn(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer,svcVersion,TEXT)

RegistryValueReturn(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer,Version,TEXT)

and created the following report

and as sql code

you can get the custom numbers of the items you create by using the report creator then looking at the sql code or hover over the software items and look at the bottom of your browser.

Answered 10/02/2013 by: SMal.tmcc
Red Belt

Please log in to comment

Answers

2

The following seems to be working for me:

select NAME, IE_VERSION from MACHINE

of course you could always narrow it down a bit more.

Answered 10/07/2013 by: WGM_Jeff
Fourth Degree Black Belt

Please log in to comment
1

I have found that due to the way Internet Explorer is reported in KACE this kind of report is difficult to create. In light of that I created a custom inventory field first to collect the IE version. I used a rule to capture the file version of iexplorer.exe:

FileInfoReturn(C:\Program Files\Internet Explorer\iexplore.exe,FileVersion,TEXT)

You could also use a rule that captures the registry key you posted. Keep in mind that you have to capture the value as text, since a true number can't contain multiple dots.

Once you have the custom inventory rule you can create a report using the following SQL:

 SELECT MACHINE.NAME, STR_FIELD_VALUE as Version
FROM ORG1.MACHINE_CUSTOM_INVENTORY 
JOIN MACHINE on MACHINE_CUSTOM_INVENTORY.ID = MACHINE.ID
WHERE SOFTWARE_ID = 31484 
ORDER BY MACHINE.NAME

You will need to change the SOFTWARE_ID value (mine is 31484) to match the software_id of the custom inventory rule that you created.

 

Answered 10/02/2013 by: chucksteel
Red Belt

  • I did do this but get a SQL error when I ran the report
  • As a result of IE 8,9, and 10 going end of life 1.12.2016 I used this report and it worked like a charm!
Please log in to comment
Answer this question or Comment on this question for clarity