Listing Largest Tables in vCenter Database

Components: vCenter 5.0 / Windows 2008 / SQL Standard Edition 2008 R2 Open SQL Server Management Studio and log in. Click New Query then ensure you have selected the relevant database in the drop down box below.  Paste the following code into the right hand side window: select object_name(id) [Table Name],[Table Size] = convert (varchar, dpages Read More…

Add a Read-Only User to VCSA

Scenario: I wanted to add a user with read-only privileges to the vcenter server appliance in order to run the Dell D-Pack 1) Firstly SSH to the VCSA Then add the user jord-vcenter:~ # useradd delldpack Set a password for the user jord-vcenter:~ # passwd delldpack Changing password for delldpack. New UNIX password: BAD PASSWORD: is Read More…

Script to Reset CBT on a Single VM in VMware

I wanted to reset CBT (Change Block Tracking) on a single VM to due to the VMware bug (KB2090639) which affects any VMs that have expanded disks over 128GB. Using this script over the manual option prevents the restart of the VM as the modification is performed online using a Power CLI script.   In the below example the Read More…