Archive | November, 2012

Bridgeways VMWARE ESX/VC subscriptions fails

28 Nov

 

Problem:

You want to add a new VC server to the Bridgeways ESX monitoring using the “Bridgeways VMware Management Administrator” tool. But the connection always fails. You checked everything user / pwd / IP , all okay

Analyze:

1) First check if the network routing is okay. Open IE and type https://<ip>/sdk

You should get a SSL warning. If not you will have to check networking.

2) If you checked networking and you can connect to the VC but still get no SSL warning you have a SSL RSA problem.

Solution:

On Windows 2008 and above the RSA minimum bits are 1024. All other certificate length will be blocked. See http://support.microsoft.com/kb/2661254?wa=wsignin1.0 .

So check you certificate properties and look for the RCA bits length. I think it will be 512Bits.

To solve this:

Open under admin a CDM console and execute this.

Certutil -setreg chain\minRSAPubKeyBitLength 512

Now retry your add action.

 

Happy Scomming

Michel Kamp

SCOM and Excel a perfect couple.

25 Nov

This time I will do a post on retrieving SCOM data into Excel. In a previous blog post series I talked about how to process SCOM data into pivot tables. See: https://michelkamp.wordpress.com/category/powerpivot/ But you had to use direct SQL query’s to get this data. So this is what I wanted to eliminate. Also I wanted to get SCOM data from more than one management group using different credentials and only over an SDK connection.

So… can I make you lucky today ?

I programmed a prototype in a C# EXCEL sheet that will do all the work. You will have 1 sheet that will contain all the MNG and SCOM data you want to retrieve.  After you press the ‘refresh’ button all the SCOM data will be retrieved and put into a new created worksheet with the given name. You can also use the auto refresh for a , for example , every 1 minute refresh. Now you can make your pivot or graph from the data. The nice part is that you will only have to have excel and this plugin installed. NO SQL connections and NO faulty SQL query’s.

The beating heart “the connection” sheet:

Every row in this sheet contains the MNG connection and the data you want to get. This is done by using the SDK SCOM query language (http://msdn.microsoft.com/en-us/library/bb437603.aspx). In the Type column you specify the type of data you want to receive. For now you can choose : Alert , Objects , Performance.

SNAGHTML45b6974d

Now if you press on Refresh every row is processed the MNG group is connected and the data query is executed. The output is written into a new created sheet with the name that you typed into the SheetName column.

image

If you go to the , for example , MonitoringObjects sheet you will see all SCOM targets with their healthstate. This is because the Query is “HealthState > 0”.

The sheet will look like this:

SNAGHTML45eed5d4

Next  you can use this data as input for everything you want. For example a pivot table that summaries the health of the targets.

SNAGHTML45c240d5

Or make an dashboard:

SNAGHTML45d65c8f

 

Using Excel with SCOM data this way you can create and display every output need you want. And even better what your boss want.  Just give your boss a prepared sheet and let excel do the work. No “he can you give me this today “ or “can you put a other label on this table” ect..

The End

The first nice part is that if you set the auto refresh all the pivot tables used in any sheet is updates also. Imagine that you can create a ‘real time’ excel dashboard and put this full screen on the wall.

The second nice part is that I will SHARE this sheet !! 😉 Just drop me a mail or put a note on this post and I will send it to you. Remember its still a prototype but you can customize it as wish.

Happy Scomming.

Michel Kamp

VSAE Adding Binary Resource Features

6 Nov

 

Hi , As I’m on age my memory sometimes lets me alone/ So this post is for my own purpose and since I am sharing it also for you. Not saying you are out aged …. ; –)

So this post is short and fast..

Challenge

One of the greatest new features of the schema 2.0 in combination with VSAE is the binary resource distributions. Using this feature you want to include a binary file that will be used in your OM12 SCHEMA 2.0 MP. You want this binary file to be available on the agent where the workflow runs. So do the steps below.

1) Add your resource to the project:

Drag your binary to the MP project. For this example I used a .ZIP file.

image

Most important: Do NOT forget to set it to “Embedded Resource” !!

2) Add your resource to the MP:

<DeployableResource
ID=”AgentResource.Binary”
FileName=”xxxxxxxx.zip”
Accessibility=”Public”
HasNullStream=”false”
     />

3) How to reference it in your workflows

Now you want to know where this binary resource is put at the agent, correct ? Use the $FileResource tag. The example below fills the Value element with the runtime path where the binary is standing.

<Value>$FileResource[Name=”AgentResource.Binary”]/Path$</Value>

This FileResource\Path parser is very handy. Because you must know that every time the MP is updated or the agent is restarted the resource path will change.

In runtime this Value element will be filled with for example: (running on the MS server)

C:\Program Files\System Center 2012\Operations Manager\Server\Health Service State\Monitoring Host Temporary Files 4249\194\xxxxxxxx.zip

 

Happy scomming.

Michel Kamp