Blog entries by Herco van Brug

These are some topics I ran into at customers that may benefit other people.

Tag >> script

In my post on sizing up the storage for block size usage, I wrote a script to get the data into a manageable form. This script runs fine from the command line but you probably want to have some sort of trend to analyze.


Migrating from VBA to VSTO

Posted by: hbr in vstovbascriptpowershelloffice on

It was long overdue but we finally made the move away from Visual Basic for Applications (Microsoft Office scripting). We implemented Sharepoint 2010 and were still using the old fashioned VBA code that originated from Office 2003. So we got Visual Studio out and started translating the VBA code into Visual Basic dotnet.


It's SAMPLE time with vscsiStats

Posted by: hbr in vscsiStatsscriptpythonesx on

vscsiStats is a new VMware tool that helps give insight in disk IOs and latency and stuff like that. It’s a very useful tool but it dumps data in histograms. Using these in Excel is quite a pain because Excel knows histograms (with add-ins) but only one at a time. If you want a graph a whole LUN or other lower level part of the storage over time, you need to reformat the data. And luckily, ESX, like most Linux versions nowadays, comes with a python interpreter. Now I know a lot of different scripting languages but python wasn’t one of them. So I decided to write a small python script to do the reformatting for me to allow me to draw nice 3D graphics of block size over time.


I had a discussion last week with a colleague about archiving messages in outlook. I have a 7GB mailbox on the server because I never delete mail. That may seem overdone but it has served me well a couple of times in discussions we had. Besides, I see absolutely no point in archiving mail away from the mail server to another store on some fileserver that eventually lands on the same central storage.


This is part 2 of a quick guide to importing a VM into Lab Manager using Orchestrator. In case you missed it, part 1 is available on http://virtuall.eu/blog/import-a-vm-in-lab-manager-using-orchestrator.


There are a lot of things you can automate in a virtual infrastructure. One of the tools that can help automate the more complex workflows is Orchestrator. It’s free when you have a vCenter and it’s very powerful.