Steps to delete unused custom baselines and baseline groups from VUM Database

Products

• VMware vCenter Server

Issue/Introduction

• When trying to delete a custom baseline/baseline group from Menu -> Lifecycle Manager -> Baselines, the delete option is greyed out.
• Update Manager Database reset is not an option as it will remove all the baselines from the Lifecycle Manager.
• In such scenarios, baseline/baseline group can be removed from the update manager database directly.

Environment

VMware vCenter Server 7.x
VMware vCenter Server 8.x

Resolution

Follow the steps below to remove the baseline/baseline groups using vpostgres database:

• Take a snapshot of the vCenter VM. If the vCenter is in Enhanced Linked Mode, please take offline snapshots of all the vCenter Servers.
  
  
• SSH to the vCenter Server as root. Enter shell.
  
  
• Note the password for the vumuser from the below file:
  /usr/lib/vmware-updatemgr/bin/configvalues.txt


• Run the following command to connect to vCenter database as vumuser:
  /opt/vmware/vpostgres/current/bin/psql -U vumuser -d VCDB


• Run the queries below to list the baselines and baseline groups:
  select id, name from vci_baselines;
select baseline_group_id, name from vci_baseline_groups;


• Run the commands below to delete the unwanted baselines and baseline groups:
  delete from vci_baseline_groups where baseline_group_id = <id>;
delete from vci_baselines where id =<id>;


• Exit from the database:
  \q


• Restart the Update Manager service:
  service-control --restart updatemgr