1. Note the names of all the vCLS VMs we are looking to delete.
2. Login to vCenter Database using the below command.
/opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres
3. Identify the Virtual Machine ID in the vCenter database with this command (replace <vm_name> with the display name of the virtual machine noted in step 1):
select * from vpx_entity where name like ‘%<vm_name>%’;
Example Output:
VCDB=# select * from vpx_entity where name like ‘%vcsa%’;
id | name | type_id | parent_id
——+———-+———+———–
1563 | vcsa-123 | 0 | 1002
Note the ID of the VM to be deleted from the list.
4. First stop the vpxd service.
service-control --stop vmware-vpxd
5. Delete vCLS (replace <ID number> with ID from step 3):
delete from vc.vpx_entity where id=<ID number>;
6. Start service.
service-control --start vmware-vpxd
Leave a Reply