Installer evidence typically contains a property that indicates where a product has been installed, known as the InstallLocation property. You can find the InstallLocation for an application in the inventory device's NDI file or by querying specific tables in the inventory database.

Find an InstallLocation using the NDI file

If the FlexNet Inventory Agent detects the InstallLocation property for an application, you will find it in the NDI file.

<Package Name="IBM InfoSphere Change Data Capture Replication 
Engine Update (Sybase)" Evidence="IA" Version="10.2.0.0" 
InstallDate="20140313T122900">
<Property Name="InstallLocation" Value="/CDC/
ReplicationEngineforSybase"/>
<Property Name="Publisher" Value="IBM Corporation"/>

Find an InstallLocation in the inventory database

You can also find the InstallLocation property by running the following query in your inventory database.

Use FNMSInventory
Select * From SoftwareProperty WHERE Property LIKE 
'InstallLocation'
--use SoftwarePropertyID in the following query:
Select * From SoftwareValue WHERE SoftwarePropertyID = 
<SoftwarePropertyID>

Use FNMSInventory
Select * From SoftwareProperty WHERE Property LIKE 
'InstallLocation'
--use SoftwarePropertyID in the following query:
select c.ComputerCN as 'Inventory device', sv.SoftwareName as 
'Application Name', sw.Value as 'Install location' from computer c
join SoftwareOccurrence so on c.computerID=so.computerID
join SoftwareVersion sv on so.softwareID=sv.SoftwareID
join SoftwareValue sw on so.softwareoccurrenceID=
sw.SoftwareOccurrenceID
where SoftwarePropertyID =  <SoftwarePropertyID> and
sv.SoftwareName like '%application%' and
c.computerCN = 'devicename'