Good day
Does anyone have a data mapping between ILMT and Flexera? The reason i am asking this, is i would like to see which tables does Flexera read to get "VM Host" information. We have an issue where the "VM Hosts" are actually decommissioned, they DO NOT appear in the Flexera VM Inventory, but they appear from ILMT SQL.
‎Jan 26, 2024 06:33 AM
Hello, be aware of archieved inventory, where FNMS put deleted server for a given time (for peak calculation in the past). These servers are no more in all inventory. Regards.
‎Jan 30, 2024 12:56 PM
There is not a simple field-to-field "mapping" between inventory sources such as ILMT and the FlexNet Manager Suite data model. However you can find all the code that extracts data from the ILMT database in the "C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\ILMT SQL" directory on your application (or beacon) server.
In particular, take a look at the "VirtualMachine.xml" file in that directory which imports virtual machine details. You will find readers named "CopyComputerData" in that file which might be a place to start to see what queries are used to extract this data.
‎Jan 30, 2024 04:58 PM