
Useful commands for the vCenter Server Appliance command line and shell. Only use in lab and never in production environment.
Working the VCSA command line (not shell!)
1 |
vimtop |
More details about vimtop: http://www.virtuallyghetto.
Get VCSA version
1 |
system.version.get |
Show VCSA health status
1 |
mem.health.get |
Get memory statistics (in kilobytes)
1 |
mem.stats.get |
Show free space and space used
1 |
storage.stats.list |
List all installed software
1 |
software-packages list |
List all local users (vsphere.local domain)
1 |
localaccounts.user.list |
Get details about local users
1 |
localaccounts.user.get –username <username> |
List all services
1 |
services.list |
Check status of service
1 |
services.status.get –name <service_name> |
Working the VCSA shell
Disk usage, separate by subdir, show only 50MB+
1 |
du -Sach -t 50M |
Get password of vCenter postgres database
1 |
cat /etc/vmware-vpx/embedded_db.cfg | grep PASSWORD |
Login to vCenter postgres database
1 |
/opt/vmware/vpostgres/9.3/bin/psql -h 127.0.0.1 -U vc VCDB |
Complete process to remove stale datastore entries from vCenter postgres database (VCSA 5.5 and 6.0):
Back up and restore vCenter Server Appliance/vCenter Server 6.0 vPostgres database (2091961) –» Back Up the Embedded vCenter Server Appliance Database http://kb.vmware.com/kb/
1 2 |
shell.set –enabled True shell |
1 |
service vmware-vpxd stop |
1 2 3 4 5 6 |
VCSA 5.5 cat /etc/vmware-vpx/embedded_db.cfg | grep -i password ./opt/vmware/vpostgres/9.3/bin/psql -h 127.0.0.1 -U vc VCDB VCSA 6.0 (no password needs to be grepped) ./opt/vmware/vpostgres/9.3/bin/psql -d VCDB vc |
1 |
SELECT ID FROM VPX_ENTITY WHERE NAME ='datastore_name'; |
1 2 3 4 |
DELETE FROM VPX_DS_ASSIGNMENT WHERE DS_ID=ID; DELETE FROM VPX_VM_DS_SPACE WHERE DS_ID=ID; DELETE FROM VPX_DATASTORE WHERE ID=ID; DELETE FROM VPX_ENTITY WHERE ID=ID; |
1 2 3 4 |
SELECT * FROM VPX_DS_ASSIGNMENT WHERE DS_ID=ID; SELECT * FROM VPX_VM_DS_SPACE WHERE DS_ID=ID; SELECT * FROM VPX_DATASTORE WHERE ID=ID; SELECT * FROM VPX_ENTITY WHERE ID=ID; |
1 |
\q |
1 |
service vmware-vpxd start |
Complete process to remove stale VM locks (vMotion/Migrate is unavailable) entries from vCenter postgres database (VCSA 5.5 and 6.0):
1 2 |
shell.set –enabled True shell |
1 |
service vmware-vpxd stop |
1 2 3 4 5 6 |
VCSA 5.5 cat /etc/vmware-vpx/embedded_db.cfg | grep -i password ./opt/vmware/vpostgres/9.3/bin/psql -h 127.0.0.1 -U vc VCDB VCSA 6.0 (no password needs to be grepped) ./opt/vmware/vpostgres/9.3/bin/psql -d VCDB vc |
1 |
SELECT * FROM vpx_disabled_methods; |
1 |
TRUNCATE TABLE vpx_disabled_methods; |
1 |
\q |
1 |
service vmware-vpxd start |