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
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.