TechNet Blogs

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 ;-)

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

Result:

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 environment Smile

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

Finding Multihomed OpsMgr agents with PowerShell

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

Finding Multihomed OpsMgr agents with PowerShell