Welcome to the blog of mechanised.com

This blog is mainly a technical repository of information on Virtualisation tools and management for our hosting service.

Also for HP's Bladesystem that we use at both our datacentres.

Other articles are also included on .Net development and MS SQL Server as well as other interesting things we come across.

Tuesday 31 March 2015

Installing VMWare tools on RHEL6

Install the latest repo RPM for your version of vSphere:
Find the RHEL version and 32/64 bit RPM you need and grab the link, then install with YUM:
yum install http://packages.vmware.com/tools/esx/5.5latest/repos/vmware-tools-repo-RHEL6-9.4.11-1.el6.x86_64.rpm
Install the tools for non-graphical systems
yum install vmware-tools-esx-nox
It should show up pretty quickly within the client.

Friday 9 January 2015

vCentre tidying of SQL

A few handy queries to tidy up old records to keep the database size down.

delete from vpx_text_array
where not exists(select 1 from vpx_entity where id=vpx_text_array.mo_id);

This removes old information about operations involving entities that don't exist anymore.