SCOM 2012 - Java EE MP and Sizing Helper updated

SCOM, SCOM 2012 Send feedback »

A few days ago Microsoft uploaded some updated SCOM 2012 tools.

The first one is the monitoring pack for Java EE. The Second is the Operations Manager Sizing Helper.

Here is an excerpt of the downlaod page with a description:

The downloads can be found over here:
System Center 2012 - Operations Manager Component Add - On

Bob Cornelissen

MVP Summit 2013 Summary

SCOM, DPM, SCVMM, SCCM, System Center Send feedback »

I have been off the blog for a few weeks due to visiting the MVP Summit 2013 last month and being sick for a few weeks. I am almost OK though, so starting to get back to all this as well.

Right before the MVP Summit my friends at Savision asked me if I would write something about the MVP Summit 2013 this year. Of course a lot of what is actually told and shown during the MVP summit is NDA (non disclosure agreement, so secret). However I did write up a piece during and right after the event and Savision posted it over here:

For all those who want to know what it is about, just have a look and gain a little insight.

Bob Cornelissen

Your chance to win a copy of Mastering SCOM 2012 book by evaluating System Center

SCOM, DPM, Service Manager, SCCM, System Center, SCOM 2012, Configuration Manager Send feedback »

My good friend and MVP Kevin Greene put out a blog post here with details on how you can win a copy of Mastering System Center 2012 Operations Manager by downloading and evaluating System Center. Look here for his blog post.

SCOM 2012 SP1 strange file names for OperationsManagerDW database

SCOM, System Center, SCOM Tricks, SCOM 2012 4 feedbacks »

In the case you have done a clean install of SCOM 2012 SP1 you might want to take a look at the file names of the OperationsManagerDW database and log files. They might look like this:

So empty names for the files and ending up with ".mdf" and ".ldf" for the file names.

However, my good friend Marnix Wolf also found that when using custom database and log file paths, the file names can take on the name of the directory they are in!

In the Release Notes of SCOM 2012 SP1 this known issue is mentioned (well, at least the part where the file names can be empty):

There are multiple ways to overcome the issue, and it would be best to solve this right after installation of the first management server before you install the other management servers.

One of the ways to fix this is to "Detach - Rename - Attach" the database. I will describe this process below with screenshots and all for those who like the step by step guides.


First of all some work before we get started:

  1. BACKUP your database before you play around with it!!
  2. Stop the System Center * services on the management servers before you do the next steps
  3. Perhaps you want to make sure where your database files live, because you want to be able to find these files. Open SQL management studio. Right-click on the database OperationsManagerDW and select Properties. On the left click the "Files" tab and find the Path and File Name of the database. Remember these.

The steps
This procedure uses the Detach - Rename - Attach method.

  1. Open SQL Management studio and connect to the database instance where the SCOM databases live.
  2. Find the OperationsManagerDW database and right-click it. Go to Tasks - Detach...

  3. If there are still any connections just use the "Drop Connections" option

  4. After a succesful detach the database will be gone from the SQL management studio.
  5. Next go to the Windows Explorer and on your file system find the database files and rename them to what you want them to be called. In general the default would be OperationsManagerDW.mdf and OperationsManagerDW.ldf .

  6. In SQL management studio, right-click on Databases and select Attach...

  7. Click the Add button to select the database file.

  8. Select the mdf file belonging to the OperationsManagerDW database in the file path where it lives

  9. The resulting screen shows some information on how it wants to attach the database and information about the files. There are a few problems in this screen (red circles). The first is the Owner might not be the one you want and the second is that it can not find the two files it expects.

  10. To change the owner just click on that field and a dropdown list will appear where you can select from known logins and take the one you want.

  11. Next we have to go to the Not Found files. This is because the database file knows which files it relies on (at least one database file and one log file) and it only knows about the old file names in the old file paths. So we need to change both and point them to the correct files. The first one points to the database file (mdf), so click the small button next to it.

  12. Go to the correct path where the database file is located and select the database file OperationsManagerDW.mdf in my case.

  13. Next do the same with the second file and point it to OperationsManagerDW.ldf for the log file.

  14. Now attach the database
  15. when opening the properties of the OperationsManagerDW database and going to the Files tab you will now see the correct paths and file names for both files belonging to this database.

  16. Do not forget to start the System Center * services again on the management servers!

The management servers and databases should be fine now.

Like I mentioned before my friend Marnix Wolf used another method and that is the backup - Restore method, whereby you can define the path location and file names of the files. You can find that post here:

Thanks to our SQL DBA David Scheltens for the procedure!

Well, I hope this helps and enjoy your monitoring!
Bob Cornelissen

Checking if CU7 for SCOM 2007 R2 has been applied successfully

Active Directory 2 feedbacks »

Because Microsoft released CU7 for SCOM 2007 R2 in January 2013 as explained in a previous post about this subject, it was time to also update the checking scripts I had made before for CU5 and CU6 and make them work for CU7.

As I explained in the previous post on how to check for CU5 installation on SCOM 2007 R2, the way to check for successfull implementation of Cumulative updates has come up as questions in the community a number of times and I found a need as well to have this scripted. So I created a number of scripts for SCOM 2007 R2 CU5 which I discuss in the other blog post here. The method for CU7 is exactly the same as mentioned in that article with two differences.

  • The names of the scripts are with a 7 in it
  • scripts are located on another TechNet Gallery page (see below for the link)

Refer to the post on CU5 check scripts for SCOM 2007 R2 on the procedure and screenshot.

This is the link to the TechNet Gallery page where the CU7 check for SCOM 2007 R2 is located.

Good luck and enjoy!
Bob Cornelissen

CU7 for SCOM 2007 R2

Active Directory 2 feedbacks »

Microsoft released SCOM 2007 R2 CU7 last night.
The relating KB article can be found here: Cumulative Update 7 for System Center Operations Manager 2007 R2

The update contains the following fixes (and this is a screenshot from that KB article):

The download can be found here: Cumulative Update 7 for System Center Operations Manager 2007 R2 (KB2783850)

Also interesting to note is that there are a few security vulnerabilities for SCOM 2007 R2 fixed within this CU7 as you can find explained over here:

Please pay close attention to the installation order and steps as described in the KB article. It is basically the same story as CU4+5+6 for the ones informed on the process of those.

UR1 for System Center 2012 SP1 released

SCOM, DPM, SCVMM, Service Manager, System Center, SCOM 2012, Configuration Manager 6 feedbacks »

Funny things this System Center 2012. As you probably know by now Service Pack 1 for System Center 2012 is available for some, but not yet in GA (General availability) status. Expecting that to be soon, and please watch for announcements on the System Center blogs... I really will not tell you anything more than this.

However last night some people found with the WSUS/SCCM updates of this months patch-Tuesday a number of additional updates called something like Update Rollup 1 for Microsoft System Center 2012 SP1 - [product] (KB1111111).

Say what? UR1 for SP1 already? 88|

Yes, it has to do with the quarterly cadence of updates coming from the System Center team. Even though the SP1 is not yet available to everybody, of course the product team is moving forward. :)

If you do not see all these updates yet in WSUS and are applicable to you check in your WSUS server settings.

In WSUS go to Options -> Products and Classifications. In the popup scroll down to the System Center products. Here you will see both the System Center 2012 and System Center 2012 SP1 type of product categories.

As you see in my case I still needed to select them and synchronize again to get to see all the updates related to SP1 as well.

And now we see a list of updates released 8 January 2013 relating to System Center 2012 and up.

The following KB article contains the Description of Update Rollup 1 for System Center 2012 Service Pack 1.

In the Article there are fixes describer for App Controller + DPM + SCOM + SPF + VMM.

Interesting is that it talks about UR1 for VMM 2012 SP1 and in WSUS it shows both that one and UR4 for VMM 2012. Not all links to all the KB articles seem to be active or available yet. Well perhaps its just waiting for a few hours/days more until all the info is up on TechNet.

The article also contains important information on how to install the updates and where to find stuff. Do not think that for all products you simply need to approve stuff in WSUS and be ready with it! As SCOM is still my main thing I will post a note below for SCOM admins. Check in the article for extended notes for SCOM and other products!!!


Note for SCOM admins: After installing the update on management servers, gateways, web console and agents and so on, you need to import the new management packs! These are according to the KB article the following: (By the way, please read further below first before you start clicking on things)...

  • Microsoft.SystemCenter.DataWarehouse.Library.mpb
  • Microsoft.SystemCenter.Visualization.Library.mpb
  • Microsoft.SystemCenter.WebApplicationSolutions.Library.mpb

You can find them in the following location:
%SystemDrive%\Program Files\System Center 2012 SP1\Operations Manager\Server\Management Packs for Update Rollups

However, I found the following two mpb management packs to be present in the mentioned folder (and in my case the folder name did not have SP1 in the path name):

  • Microsoft.SystemCenter.AlertAttachment.mpb
  • Microsoft.SystemCenter.IntelliTraceProfiling.mpb

And these also sound more like the mentioned issues actually.

Update 23 January 2013: The KB article seems to have been adjusted. It now mentions to only install the Microsoft.SystemCenter.AlertAttachment.mpb management pack! The IntelliTrace management pack contains a number of dependencies that seem to be as yet impossible to resolve &#59;) and I read somewhere that it would actually contain nothing new over the version included in the SP1 bits. So only import the one mpb file!

For UNIX/Linux monitoring there are also updates. You can find them by going to this location: and download the MSI and guides.
Install the MSI to extract the contents. You will find updated Microsoft.Unix.Library management pack in the Microsoft.Unix.Library\2012 SP1 folder and the Microsoft.Process.Library management pack bundle and platform library management packs that are relevant to the Linux or UNIX platforms you are monitoring which you can import.

Good luck updating your System Centers!
Bob Cornelissen

New MCTS System Center 2012 certifications

SCOM, DPM, Service Manager, System Center, SCOM 2012 8 feedbacks »

Was surprised this morning with an email stating I had earned a certification for the System Center 2012 suite. Well, I did the exams in April 2012, so I went and had a look what happened in my transcript. And at first I did not see it, but with a little scrolling I found these:

MCTS System Center 2012

MCTS System Center 2012, Monitor and Operate
MCTS System Center 2012, Deployment and Configuration

With an achievement date of the first of January 2013.

Until now there were no separate MCTS certifications for these exams, but they were of course taken together as two exams together with an MCSA 2008 or MCSA 2012 to attain MCSE Private Cloud. Seems they changed their minds and created the MCTS anyway now for the two existing exams 70-246 and 70-247.

Well, I guess thanks Microsoft for these two certs as a 2013 new year present B)

MCTS System Center 2012

Bob Cornelissen

MVP SCCDM renewal

SCOM, DPM, SCVMM, Service Manager, System Center, SCOM 2012 3 feedbacks »

I just got the confirmation that I got renewed as MVP for SCCDM (System Center Cloud and Datacenter Management) for my second year!

I want to thank the whole System Center community for making this possible!

Lets have much more fun in 2013! There will be lots to do around System Center in this year as well.

Upgrading SCOM 2012 to SCOM 2012 SP1

SCOM, System Center, SCOM 2012 15 feedbacks »

In my lab I was looking at upgrading three SCOM 2012 instances to the SP1 RTM version. Upgrading the ones which already had a pre-release version of the RTM of SP1 turned out to be no work at all, so I was left with the one which was SCOM 2012 UR3 and upgrading that one. Lets see what happened.

First of all the System Requirements from the Supported Configurations page on Technet here

Lets see, this computer is running Windows 2008 R2 SP1 and SQL 2008 R2 SP1 and of course has SCOM 2012 with UR3 installed. We should be fine.

I did give the machine a reboot and checked everything came back up again before I went ahead with the installation. Downloaded the SCOM 2012 SP1 ISO file and attached it to the machine.

There it is. It says Service Pack 1, so on to the Install link!

One thing I forgot to say is that this is an all-in-1 installation. So all roles are combined on one machine. It doesn't have that many agents connected to it, so thats fine. As we can see it found the installed components and it wants to upgrade them all. Of course the added tip of first creating a backup of your databases! The next screen asks you to agree to the license terms.

Select installation location. In my case the default installation location is fine, so moving on!

A prerequisite checker starts running which verifies the hardware and software configuration.

Passed! Next!

The System Center Configuration service and System Center Data Access service account. You have a choice for Local System or a domain account. If the database is running locally as is the case on my machine you can leave it at Local System. If the databases are remote it required to use a domain account. Because I might move some components out from this machine I will use a domain account anyway and proceed.

The next screen tells me it is ready to upgrade and it shows me again the installation location and config/das account setting I selected.

There it is, the upgrade button. Click!

In my case it took a while for it to upgrade all the bits and pieces and there is a progress indication for each. During the Operational Database Configuration phase it also imports a whole lot of management packs, so that takes some time. After upgrade finishes, just close the setup screen.

Start the SCOM console and go to Help -> About.

Looking good! Service Pack 1 and of course still activated.

Next up are our good friends the SCOM agents.
Go to the Administration Pane of the SCOM console and open the Pending Management node.

All the agents which were installed through the SCOM console which are manageable by the console are set to Pending Management with the note Agent Requires Update. Right-click them and select Approve. In bigger installations I would it about 30 to 40 at a time. Use the default action account or one you provide yourself and select Upgrade.

In my case all success and one fail. That was a machine which was turned off actually.

Next jump over to the Monitoring Pane, and on the left hand side go to Operations Manager -> Agent Details -> Agents by Version.

As you can see in this picture the process has started already. The first two have been upgraded and have reported back their new version already. The path list is empty again for the updated agents, because they dont have a patch installed now. Its a full SP1. &#59;)

Next phase would be looking at management packs. On the installation ISO there is a Management Packs directory where you can select the ones you want/need. The upgrade should have upgraded the management pack you had installed already and for which it had an updated version. It could be that you want more things, like APM, and cross plat monitoring management packs for instance.

Well, all looks nice and well now.

This upgrade was relatively easy to do because the OS and prerequisites were in place already and it was just one upgrade step for the Service Pack. Also an all-in-1 machine is easier to upgrade of course, but generally its all the same story. Upgrade all the components following the same procedures as any SCOM update for SCOM 2012.

Update: One important thing to note is that you have to update the management servers one by one. SO do not even start the wizard on the second management server if your first has not completely finished updating to SP1! See in case you were not patient and ran into error messages when opening alerts and such.

I'm done for today. Tomorrow is another day to play with System Center!

Bob Cornelissen

Contact / Help. ©2017 by Bob Cornelissen. blog software.
Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.