Friday, June 30, 2017

SQL server Reporting Services configuration manager does not open

This can happen due a corrupted wmi repository. If that is the case in your installation.

Find the file sqlmgmproviderxpsp2up.mof in your SQL installation directory on your server.

 In my case it was located in

C:\Program Files (x86)\Microsoft SQL Server\110\Shared

Then open command prompt as admin and navigate to the directory.

Then execute

mofcomp.exe sqlmgmproviderxpsp2up.mof

This will repair your repository  and you should be able to open the console.

Friday, June 23, 2017

Extract contents from msp file

Use the msix utility to extract the contents of your msp file.

C:\Parag\Tools\Temp>MsiX.exe SCSM2012R2_CU_KB3129780_AMD64_7.5.3079.607.msp

Rename the cab file by adding the extension .cab to it.

Now you can browse the file in Windows Explorer and extract the file you need.

Find the directory for your installation and search for this file.


Copy the location of that file in my case its

C:\Program Files\Microsoft System Center 2012 R2\Operations Manager\Setup

Thursday, June 22, 2017

VMWare monitoring using SCOM

The management pack for monitoring VMware is here.

It's a very good management pack.and also has clear instructions for installation.

But after installation you may find that the required objects are not being discovered.
This is largely due to the fact that the powershell scripts which are running the discoveries have this

Try {
    Add-PSSnapin VMware.VimAutomation.Core
} Catch {
    Start-Sleep -Seconds 10
    Try {
        Add-PSSnapin VMware.VimAutomation.Core
    } Catch {

If the mp was unsealed then maybe I could have updated the code and added import-module instead of this one. But to fix it  try this.

1. Install the VMware powercli version from this link.


After installation run the commands in powershell and if you do not get any errors then you are good to go.

Wednesday, June 7, 2017

How to make a parameter mandatory in powershell.

How to make a parameter mandatory in powershell.

Enter this at the start of your script.


A very good explanation and additional ways to do it is here.

powershell powergui download link

Powergui is a very good powershell editor. I particularly like the speed of execution compared to windows powershell ise.

Please refer to this link for powergui and additinal downloads.

In case the page does not open the direct download link is posted below.