WordPress – 2014 Blog review

December 31, 2014

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 11,000 times in 2014. If it were a concert at Sydney Opera House, it would take about 4 sold-out performances for that many people to see it.

Click here to see the complete report.

PowerShell – Manage your Hyper-V virtual machines

December 18, 2014

If you are running a Windows Server 2008 you are missing this crucial PS tool to help you manage your Hyper-V machines.

It was not so easy to first find the proper Hyper-V PS Modules and secondly to get them installed.

1. Download the Hyper-V module

from Codeplex http://PShyperV.codeplex.com

It is a bit strange that MS does not distribute the Module officially. But it does the job well so go ahead.

2. Set-ExecutionPolicy to RemoteSigned

But make sure you open the PS command with elevated credentials !


3. Check the policy Get-ExecutionPolicy

Check that the Execution Policy was initialized correctly.

4. DO NOT RUN the install bat files !

Because this will install Powershell and some more features on your windows 2008r2 server.

Instead just use the module from where you extracted it

Import-Module “C:\Temp\HyperV\HyperV.psd1” or different directory where you placed the files from the zip.


5. Test it against your live Hyper-V environment.



Windows – AD User Password reset Tool

December 15, 2014

It has always been an issue to set up a self-service web facing Password Reset Tool.

Well if you have an Exchange server running let’s say 2010 SP1 or higher, you have all you need to make it work Smile

The only thing you need is to make an extra registry key entry in your CAS server. Which is in small organizations the same server as the Exchange backend server.

Solution :

  1. On the Client Access Server (CAS), click Start > Run and type regedit.exe and click OK.
  2. Navigate to HKLM\SYSTEM\CurrentControlSet\Services\MSExchange OWA
  3. Right click the MSExchange OWA key and click New > DWord (32-bit)
  4. The DWORD value name is ChangeExpiredPasswordEnabled and set the value to 1.
    Note: The values accepted are 1 (or any non-zero value) for “Enabled” or 0 or blank / not present for “Disabled”
  5. After you configure this DWORD value, you must reset IIS. The recommended method to reset IIS is to use IISReset /noforce from a command prompt.

Here is the result !


As of now your users can reset their passwords themselves Winking smile

PS : To check the Exchange version you can do this using the Outlook client.

Press CRTL + right click on the Outlook Icon in the system tray.

Select the Conntection status.


And read out the version column.


Or you can check the management console


Or you can use Powershell to do the job …

You can find the build numbers here :


Enjoy !

Google – Modifying MS Office files using Google Docs

December 5, 2014

Ever wanted to open / edit and save MS Office documents without the need of Office 365 installed.

All you need is to have Chrome installed on your machine and add the MS Office Editing extension.


Solution :

1. Copy an Excel for to your Gdrive or go to https://drive.google.com and upload an MS Office file.


Once the XSL(X) file is uploaded, open it with Google Sheets, in this case.

2. Open the file and make some changes.


You will see now 2 files, the original and the new Google Sheets file.


The beauty is that you can work simultaneously on the file with multiple users !

The Original MS Office file you can open with Google Drive Viewer


3. Next download (save) the file again using the original XLSX Office file extension.



4. Open the new XLSX file in MS Excel, and check the result.


Works like a charm !


More information can be found here : View and edit Office files in Google Docs, Sheets, and Slides


QlikView – Automation using the Object Model

December 3, 2014

When starting to automate the QlikView client you can use AutoIt or Powershell as a client application to run against local or remote server documents


This QlikView application is a guide to the QlikView 11 Automation Interface and the QlikViewOCX API.

The Automation Interface part is intended to serve as an interactive guide to the QlikView Automation API.
– The Object Model sheet provides a simplified model of the API that shows the Class hierarchy.
– The Members sheet contains information on all classes and members in the Automation interface.
– The Examples sheet offers VBscript code examples for a specified class and member.
– The Help sheet contains some explanations on some of the sheet objects in the main sheet and their contents.

The OCX API part is intended to serve as an interactive complement to the QlikViewOCX SDK documentation, which is available as PDF on the QlikViewOCX SDK CD.
– The sheet contains information on all QlikViewOCX specific API members with code examples in VB, C# and VC++.

But what you need is of course knowledge of the QV Object model


You can get this COM API documentation here : http://community.qlik.com/docs/DOC-2640

In this nice QVW file you can find lot’s in interesting information, Help AND +1800 Examples.




This is how they pulled it together


Here is an Example using AutoIT

Enjoy !