Misc

Howto combine two columns into one in mysql

This is how you can combine (or concatenate or merge) data from two table columns into one column using a mysql SQL query. SELECT CONCAT(firstname,lastname) AS ‘name’ FROM tablename The result would be “firstname lastname” If you would like to insert this data into a new column INSERT INTO tablename (full_name) SELECT CONCAT(firstname,lastname) AS ‘name’ […]

Read More
Windows

Getting VMware vSphere Client to run on Windows 7 RTM

This post describes how you can get your VMware vSphere Client version 4 running on a 32-bit Windows 7 (RTM) installation until VMware makes an update to fix this Microsoft .Net problem. Be aware that this method of getting the client to run is not recommended in a production environment since you are running the […]

Read More
Linux

Suspend a VMware Workstation host from command line

This post gives a short description of how to suspend a VMware Workstation 6.5.x guest/VM on a Ubuntu 9.04 Workstation but it shouldn’t be any problem to follow it on other linux distributions. Lately I’ve experienced that one of my VMware Workstation host lock up and my mouse cursor stops responding. The keyboard doesn’t let […]

Read More
Linux

Replace RPMforge packages with Redhats own on a RHEL5 system

This post came to life after experiencing some upgrade problems with missing dependencies and RPM packages from RPMforge and Redhat Enterprise Linux Client release 5. The prosess to remove or replace the packages was to remove RPMforge as a package repository and replace the blocking packages with Redhats own packages. The process of replacing RPMforge […]

Read More
Scripting

Simple Windows Print Accounting using Event Viewer data

This post continues where my previous post titled Export events including Event Properties from Windows Event Viewer left off. The data I’m going to work with was exported using eventquery.vbs and saved in a CSV-file, comma separated file and it is presented in the form shown below. “Information”,”10″,”12.05.2009 13:24:48″,”Print”,”Servername”,”None”,”AD\username”,”Document 232, filename.pdf owned by username was […]

Read More