Purging and deleting historical data from vCenter Operations?

For purging data look at the following VMware KB: http://kb.vmware.com/kb/2008223  For removing resources/data collected for stale non existing VM’s look at, http://kb.vmware.com/kb/2020638

February 24, 2014 · 1 min · Jahnin Rajamoni

Accessing the vCenter Operations Capacity IQ database

To connect to the Capacity IQ database: 1. SSH to the UI VM. 2. Switch to the postgres user using the command: su - postgres 3. Connect to the database using the command: psql cmapp 4. To list all tables, type \\d at the cmapp=# prompt. 5. For hep with SQL commands type \\h at the cmapp=# prompt. 6. For help with PSQL commands type \\? at the cmapp=# prompt.

October 30, 2013 · 1 min · Jahnin Rajamoni