Archive for the ‘OpsMgr 2012’ category

Copy SCOM View Data to Excel

May 13, 2013

 I come across this post regarding SCSM and thought it worth pointing out that it works in SCOM as well.
http://blogs.technet.com/b/servicemanager/archive/2010/03/03/hidden-feature-export-data-to-excel-from-a-view.aspx

Go to a view (State or Alerts) and do Ctrl-A to select all the rows. Ctrl-C to copy and then paste the results into Excel. Instant spread sheet of the data in the view.  A lot easier than using PowerShell to export the data to CSV and then bring it into Excel. And it also brings in the column names as well.
This works best when not using the Group Items By feature. If the group by is closed then only the titles get copied and you cannot expand them in Excel. If they are expanded in SCOM then all the data will be copied but the Group Items By will just be another row in the spread sheet.
This does not work on performance views or any of the views in the Authoring area.

How to Create a New Override MP

May 3, 2013

 This is something that an OpsMgr admin does on a regular basis but I have added some additional bits to the process.

When a new override management pack is needed then the following steps are required.

If there is a specific alert that needs to be overridden then click on that alert and in Alert Details click on the Alert Rule/Alert Monitor.  This will show which Management Pack the alert was generated by.

 For example - the SQL Server 2008 (Monitoring) management pack.

It is best practice to create an override Management Pack for the sealed MP and put the overrides for the sealed MP into that MP. I prefer to create a new MP in the Administration tab so I can control the process rather than create the MP on the fly when overriding an alert.

Note that unsealed MPs do not need a separate MP as the override will be written directly into the MP.

Go to the Administration  tab and click on Management packs.

 In this case I have filtered the MPs to the SQL 2008 ones. 

 sql server 2008 mps

 Double click on the SQL Server 2008 (Monitoring) MP.

The 2 important fields are ID and Name. The ID must match the filename of the MP and the Name will be the name that shows up in the list of MPs.

Highlight the Name and copy (Ctrl C).

 SQL 2008 MP properties

This will give you the name of the MP – SQL Server 2008 (Monitoring).

Close the dialogue box.

Right click in the Management Pack area and chose Create Management Pack.

 Create MP Wizard

This will start the Create a Management Pack Wizard

 MP Wizard 1

 Paste the name that was copied into the Name field and add Overrides.

Some organizations put Overrides at the beginning of the name so that they show up in the MP list together. It is easy to find all MPs with overrides in the name using the Find search box on the tool bar. Therefore I do not think that  it is necessary to put the word overrides at the beginning. Putting it at the end means that the override MP shows up in the MP list next to the sealed MP so that you know that there are overrides for that MP.

 MP Wizard 2

 Note that it creates the ID name for you. But importantly does not include numbers. When the MP is created it is checked in the console to make sure it is unique. If the 2012 one was done next it would create an MP with ID of SQL.Server.Monitoring.Overrides0. This can be fixed later to match the version with the name.

The version can be any number but leave it at 1.0.0.0 for now.

 MP Wizard 3

 If you click Edit to add knowledge you will get this error message.

 VSTfO Error

In order to edit Knowledge you must have Visual Studio Tools for Office runtime installed along with Word on the computer that is running the console.

 Once it is created it can be seen in the console. It can now be used for overrides but the following steps are recommended before you create overrides. If you go to the Monitoring pane you will see a new View folder with the name of the MP.

 Empty view

 All new MPs created in the console create a top level folder so that views can be created underneath. As this will only be used for overrides the empty view is not necessary and clutters the console.

Highlight the folder and press Delete.

 Delete Empty view

Click yes.

 As noted earlier the MP created does not have 2008 in the file name. When the 2012 MP is made it will have a very similar name. I have found it is better to rename the filename to have 2008 in the name to make it easier to distinguish files outside of the console.

Go back to the Administration pane and click Management Packs.

Click on the new management pack and right click to Export Management Pack.

 export MP

 Once exported open the MP in a text editor.

 The contents will now look like this.

 SQL 2008 Override MP 1

 The key fields are ID and Name.

The ID has to be a unique name for the Management Group and MUST match the name of the file. If these two do not match you will not be able to import it back into the Management Group.

The Name is the friendly name that is seen in views and can be left.

Change the contents of the ID field from SQL.Server.Monitoring.Overrides to SQL.Server.2008.Monitoring.Overrides.

You must also change the Display String Element to match otherwise you will get a message like this.

 SQL 2008 Override MP 2

The highlighted text shows that it is the Display String Element in the Language section that is wrong as it still refers to the original name.

 Change the version number to 1.0.0.1 to show that the view has been removed, that the file name has changed.

 SQL 2008 Override MP 3

 Do a File Save As and ensure that the file name is the same as the ID.

  Import the new MP into the Management group.

 As this has a unique name (ID) it does not overwrite the original MP.

 Multiple MPs

The 1.0.0.0 MP can now be deleted and the new MP is ready for overrides.

 Rather than going through the whole process again for the SQL Server 2012 overrides the existing XML file can be edited by changing 2008 to 2012 in the 4 lines highlighted.

 SQL 2008 Override MP 5a

Do a file save as SQL.Server.2012.Monitoring.Overrides.xml and the new MP can be imported in.

 new sql 2008 override MP

 This template can now be used for any new override MP.

 Override MP Template

 When a new MP is need replace FILENAME with the name of the file which reflects the MP name and must be unique with no spaces and in the 2 Name fields replace MPNAME with a friendly name.

 Here is the text file to use as a template.  

<?xml version=”1.0″ encoding=”UTF-8″?>
<ManagementPack ContentReadable=”true” SchemaVersion=”2.0″ OriginalSchemaVersion=”1.1″ xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:xsl=”http://www.w3.org/1999/XSL/Transform” >
   <Manifest>
      <Identity>
         <ID>FILENAME.Overrides</ID>
         <Version>1.0.0.1</Version>
      </Identity>
      <Name>MPNAME Overrides</Name>
      <References>
         <Reference Alias=”SystemCenter”>
            <ID>Microsoft.SystemCenter.Library</ID>
            <Version>7.0.8432.0</Version>
            <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
         </Reference>
      </References>
   </Manifest>
   <LanguagePacks>
      <LanguagePack ID=”ENU” IsDefault=”false”>
         <DisplayStrings>
            <DisplayString ElementID=”FILENAME.Overrides”>
               <Name>MPNAME Overrides</Name>
            </DisplayString>
         </DisplayStrings>
      </LanguagePack>
   </LanguagePacks>
</ManagementPack> 

NOTE – when copying this text ensure that the quotation marks are the straight ones (“”) and not the curly ones(“ “). This can happen when copying and pasting from certain programs and web pages.

 

OpsMgr 2012 Beta First Looks

July 21, 2011

The public beta has now been released for those of you who want to test it.

Download – http://www.microsoft.com/download/en/details.aspx?id=26804 (About 1 GB and 3 MB for the zipped docs)

Microsoft site for beta – http://www.microsoft.com/systemcenter/en/us/om-vnext-beta.aspx

Technet Site -  http://technet.microsoft.com/en-us/library/hh205987.aspx

 

There are already three posts showing a simple (all components on one server) screenshot install. The big thing I am seeing from these is that there are new prerequisites which need to be checked and installed.

Christopher Keyaert

http://scug.be/blogs/christopher/archive/2011/07/20/system-center-operations-manager-2012-beta-installation-step-by-step.aspx

Dual – Polish – English by Łukasz Rutkowski

http://oopsmgr.wordpress.com/2011/07/20/instalacja-operations-manager-2012/

Bob Cornelissen
http://www.bictt.com/blogs/bictt.php/2011/07/20/scom-2012-beta-first-install

There is a bunch of useful information as usual from Kevin Holman

http://blogs.technet.com/b/kevinholman/archive/2011/07/21/operations-manager-2012-public-beta-has-launched.aspx

And Graham Davies (MVP) has setup a new blog to deal with OpsMgr 2012 posts – http://www.systemcentersolutions.com/2011/07/whats-new-in-scom-2012/

Some nice snippets of information.

There is a lot if useful information in the docs from the download.

  • Quick Start Guide – 62 pages
  • Deployment Guide – 104 pages
  • Operations Guide – 305 pages
  • Supported Configurations – 19 pages
  • Release notes

Plenty to read and it is needed as the requirements for SQL and Windows to install 2012 on is much higher.


Follow

Get every new post delivered to your Inbox.