
johnwee_lee asked a question.
Extraction of Application actual installation path?
Hi everyone, would like to know how does one extract the application actual installation path from FlexNet Manager itself? Currently we have SCCM 2012 data synchronize with FlexNet Manager on a daily basis and we know that SCCM keep tracks of the Application actual installation path.
Any one have done this previously?
Hi,
Does this help?
USE FNMSInventorySELECT *FROM SoftwareOccurrence soJOIN SoftwareDetails sdON so.SoftwareDetailsID = sd.SoftwareDetailsIDJOIN SoftwareValue svON so.SoftwareOccurrenceID = sv.SoftwareOccurrenceIDJOIN SoftwareProperty spON sv.SoftwarePropertyID = sp.SoftwarePropertyIDWHERE sp.Property = 'InstallLocation'Best regards,
Markward
The script returns what is stored in the Inventory database. Which is, as you have noticed, only what the agent or remote inventory delivered.
The results are only what is collected from the WMI/Registry. Depending on the quality of the installer, it might be missing, existing or even accurate.
For more reliable path data, you might want to look for file evidences instead.
Here is an example of a SQL query that can be executed against the inventory database to return a list of computer names with files found on them as per data gathered by the FlexNet inventory agent:
SELECT c.ComputerCN, sfn.Name, sfp.PathFROM dbo.SoftwareFile sfJOIN dbo.SoftwareFileName sfn ON sfn.SoftwareFileNameID = sf.SoftwareFileNameIDJOIN dbo.SoftwareFilePath sfp ON sfp.SoftwareFilePathID = sf.SoftwareFilePathIDJOIN dbo.Computer c ON c.ComputerID = sf.ComputerIDI'm sure a query similar to this one, and possibly a query similar to @mfranz ' query that returns InstallLocation details recorded in the registry by application installers, could be written to be executed against the SCCM database too to cover computers inventoried by SCCM - but I would defer to somebody who knows the SCCM database schema/reporting interfaces better than I do to do that.