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
‎Jun 12, 2023 07:07 AM
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
‎Jun 12, 2023 01:35 PM
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
‎Jun 12, 2023 01:35 PM