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.
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'
on Oct 05, 202212:11 PM - edited on Oct 06, 202209:01 AM by HollyM