Stefan Stranger's Weblog - Manage your IT Infrastructure

"People are strange when you're a stranger" (The Doors) Link to my personal Lifestream

April, 2011

  • Who put the RMS in Maintenance Mode? (2nd update)

    I was investigating an issue with OpsMgr Agents who where stuck in Maintenance Mode. A big help was this article from David Dixon.

    We managed to solve the issue but we also wanted to know what caused the issue and I investigated if the RMS HealthService was put in Maintenance Mode accidentally. By the way, it is not a good thing to put the RMS in Maintenance Mode!

    Update 2: I got an email from one of my co-workers Marek Tyszkiewicz telling me he made an enhancement to my SQL query to find out if the RMS HealthService was put in Maintenance Mode:

    -- Find if RMS is put in MM
    -- Author: Stefan Stranger
    -- Version 0.3
    -- Remark: Added (NOLOCK) to query. Thanks to Jeremy Pavleck.
    -- Remark: No need to specify  RMS server name. Thanks to Marek Tyszkiewicz
    -- Date: 20-04-2011
    USE OperationsManagerDW
    SELECT ManagedEntity.DisplayName, MaintenanceModeHistory.*
    FROM ManagedEntity WITH (NOLOCK)
    INNER JOIN MaintenanceMode ON ManagedEntity.ManagedEntityRowId = MaintenanceMode.ManagedEntityRowId
    INNER JOIN MaintenanceModeHistory ON MaintenanceMode.MaintenanceModeRowId = MaintenanceModeHistory.MaintenanceModeRowId
    WHERE (ManagedEntity.DisplayName in (
    SELECT DISTINCT METarget.DisplayName
    FROM vManagedEntity MESource
    INNER JOIN vRelationship R ON R.SourceManagedEntityRowId = MESource.ManagedEntityRowId
    INNER JOIN ManagedEntity METarget ON R.TargetManagedEntityRowId = METarget.ManagedEntityRowId
    WHERE MESource.FullName  = 'Microsoft.SystemCenter.RootManagementServerComputersGroup'

    Have fun pointing your finger ;-)

  • Finding Multihomed OpsMgr agents with PowerShell

    This week I got some questions about Multihoming agents. As you know, a multihomed architecture is based on the concept of an agent reporting to two (or more) management groups. But first I wanted to know how I could see if an agent was a multihomed agent and I used PowerShell to look into the registry of an agent for the ManagementGroup information.


    dir "HKLM:\SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Agent Management Groups\" `
    | Format-Table @{Label="ManagementGroup";Expression={$_.PSChildName}} –aut




    Is this case I used PowerShell Remoting to connect to another Agent in my OpsMgr demo environment to collect the Management Group information.

    As you see I don’t have a multihomed agent in my demo environmentSmile