Expected Behavior

We are accessing the vSphereDB database via SQL for some import runs. These ceased to work with the update to vSphereDB v1.2.1. This is because we cannot look up the uuid of resource pool objects in the object table any longer:

select count(*) from virtual_machine vm  inner join object rpo on vm.resource_pool_uuid=rpo.uuid;
0

Also, there doesn't seem to be a object type ResourcePool or similiar in the object table:

select distinct(object_type) from object o;
ComputeResource
ClusterComputeResource
Datacenter
Datastore
DistributedVirtualPortgroup
Folder
HostSystem
Network
StoragePod
VirtualMachine
VmwareDistributedVirtualSwitch

It seems like resource pool objects are no longer synchronized?

Possible Solution

Steps to Reproduce (for bugs)

Your Environment

• VMware vCenter®/ESXi™-Version: vSphere 7.0
• Version/GIT-Hash of this module: v1.2.1
• Icinga Web 2 version: 2.9.5
• Operating System and version: CentOS 7.9
• Webserver, PHP versions: Apache 2.4, RH SCL PHP 7.3