Software

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.

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.

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.