Sometimes one may want to define a specific OU as default location for newly joined computers in an Active Directory Domain. This can be done very easy: redircmd <OU> redircmd OU=Clientrechner,OU=main-location,DC=my,DC=domain,DC=de  

Deploy Acrobat Reader via MS-AD GPO
25. April 2014

Download Adobe Reader: Adobe Reader Customization Wizard: Extract Acrobat Reader AdbeRdr11006_de_DE.exe -nos_o”MyFolder” -nos_ne Customize load msi package in Customization Wizard define your settings write transform-file by “Transform–>Write Transform” menu  Set GPO Add MSI package to software installation GPO add mst package as modification in advanced deployment step    

Analyse MySQL diskusage
20. March 2014

It may happen that your mysql instances face some diskspace problems. Usually this is an application-side problem. Following steps may help to identify the bogus points. Show databases and their sizes SELECT table_schema “DB Name”, Round(Sum(data_length + index_length) / 1024 / 1024, 1) “DB Size in MB” FROM information_schema.tables GROUP BY table_schema; Display table information […]


If you use curl to get some json in your shell and try to read what you got, this is no fun. I discovered jq as a very nice commandline tool to format json output. Fetching graphite time-series data is a good example on how to use jq. curl -s “http://graphite_host/render?*&format=json&from=-5min” | jq ‘.’ [ { “datapoints”: […]

How to create Ansible deb packages
10. March 2014

Ansible is a quite nice tool for ssh based systems management and orchestration. It is written in python and hosted on github. Quite easy to install by using pip or install, but creating a deb package out of the sources is much better in terms of manageability. To do so, just do the following: […]

Python and oracle databases
21. February 2014

As oracle databases are not that easy stuff, it seems normal that connecting to one is also not that easy. Doing the following might help. Install Oracle Instantclient (on OSX) This brought me into some trouble starting with simply trying something with something downloaded from oracle :-). The following howto helped me a lot on […]

compacted output for pdsh
12. February 2014

Using pdsh is some kind of a knife with latches on both sides. Nevertheless it is a great tool to do things really fast on a lot of systems. It is able to execute ssh commands in parallel on many systems but also produces a overblown output, fairly bad to read. To get a consolidated […]