Get an application's install location from installer evidence

[#1]

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>

You can build on this query if you need to find the location of specific devices. In the example below,  several relevant tables are joined using the computerID value of the device, the softwareID, and the softwareoccurenceID. They are then filtered by application and device name.

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'