Hosted in table in database

[Bharath099]

Hi all,

Do you know from which table I can get the info shown in Inventory device properties? I also want to know in 'Inventory device properties' there is a field called 'Hosted in'. Can I know in which table I can get this info?

Thanks

[dhoagland1 · Accepted solution]

It's not quite that simple.

ComplianceComputer has 2 fields relevant here. The first is "HostId" - which if the Virtual Machine is hosted On Prem (say VMware or HyperV) relates back to the Host Computer. If this field has a value, Hosted In on the Grid will show "On Prem".

The second field relevant is "CloudServiceProviderId". This contains the ID value that relates to the correct value in the CloudServiceProvider table (AWS, Azure, etc.).

Documentation about the ComplianceComputer table: https://docs.flexera.com/FlexNetManagerSuite2022R2/EN/Schema/index.html#SysRef/schema/ComplianceSchema/Compliance.Logic.CoreTables/reference/ComplianceComputer.html#reference_FNMP_ComplianceComputer

Further information about the CloudeServiceProvider table: https://docs.flexera.com/FlexNetManagerSuite2022R2/EN/Schema/index.html#SysRef/schema/ComplianceSchema/Compliance.Logic.CoreTables/reference/CloudServiceProvider.html#reference_FNMP_CloudServiceProvider