Remove unwanted duplicate records from the operational database

Microsoft.SystemCenter.2007.OpsMgrDb.FixDuplicateAgntToSrvRel.Recovery (Recovery)

This recovery will fix the duplicate condition.

Element properties:

TargetMicrosoft.SystemCenter.OpsMgrDBWatcher
MonitorMicrosoft.SystemCenter.OpsMgrDB.DetectDuplicateRelationshipsforAgentsToServers
Reset MonitorTrue
RemotableTrue
Timeout300
CategoryMaintenance
Enabledfalse
AccessibilityInternal

Member Modules:

ID Module Type TypeId RunAs 
FixOpsMgrDbRelDuplicates WriteAction Microsoft.SystemCenter.2007.OpsMgrDB.FixDuplicateAgntToSrvRel Default

Source Code:

<Recovery ID="Microsoft.SystemCenter.2007.OpsMgrDb.FixDuplicateAgntToSrvRel.Recovery" Accessibility="Internal" Enabled="false" Target="SCLibrary!Microsoft.SystemCenter.OpsMgrDBWatcher" Monitor="Microsoft.SystemCenter.OpsMgrDB.DetectDuplicateRelationshipsforAgentsToServers" ResetMonitor="true" ExecuteOnState="Error" Remotable="true" Timeout="300">
<Category>Maintenance</Category>
<WriteAction ID="FixOpsMgrDbRelDuplicates" TypeID="Microsoft.SystemCenter.2007.OpsMgrDB.FixDuplicateAgntToSrvRel">
<TimeoutSeconds>300</TimeoutSeconds>
<DatabaseServerName>$Target/Property[Type="SCLibrary!Microsoft.SystemCenter.OpsMgrDBWatcher"]/DatabaseServerName$</DatabaseServerName>
<DatabaseName>$Target/Property[Type="SCLibrary!Microsoft.SystemCenter.OpsMgrDBWatcher"]/DatabaseName$</DatabaseName>
</WriteAction>
</Recovery>