Retrieve basic VM replication information from vSphere replication

Products

• VMware Live Recovery
• VMware vSphere ESXi

Issue/Introduction

This article outlines the steps to obtain a list of destination datastores configured for Virtual Machines in vSphere Replication.

Resolution

You can retrieve the list of destination datastores by checking the replication configuration for individual Virtual Machines:

1. In the vSphere Client, navigate to vSphere Replication > Monitor.
2. Right-click on the desired virtual machine and select Reconfigure.
3. Expand the target location to view the destination datastore configured for the virtual machine replication.

Alternatively, you can access this information directly from the VRMS database:

1. SSH into the vSphere Replication Appliance and navigate to the following directory:
   cd /opt/vmware/vpostgres/current/bin

2. Connect to the VRMS database using the following command:
   ./psql -U vrmsdb

3. You will be prompted for a password, which can be found in the following file:
   /opt/vmware/hms/conf/embedded_db.cfg

4. Run the following commands to list basic information:

• To list all tables:
  \d


• To list all fields in a specific table (example for virtualmachineentity):
  SELECT * FROM virtualmachineentity;
  
  
• To list specific fields:
  SELECT name, rpo, quiesceguestenabled, recoverystate FROM groupentity;
SELECT name, configfilespath, instanceuuid, destconfigfilesdatastoreuuid FROM virtualmachineentity;

Look for the column destconfigfilesdatastoreuuid, which contains the GID for all virtual machines and their associated datastore UUIDs.

 

Additional Information

Additional Information
To back up the VRMS database:

1. Navigate to the directory:
   cd /opt/vmware/vpostgres/current/bin

2. Run the following command to back up the database to your desired location:
   ./pg_dump -U vrmsdb -Fp -c > /tmp/DBBackup.bak