How to delete orphaned server/s records from "OnePoint" Database

 
The MOM (Microsoft Operation Management) "OnePoint" database may contain a old records
 
of orphaned server/s that was manage by MOM (Microsoft Operation Management) server.

 
Unsuccessful MOM (Microsoft Operation Management) Agent uninstall or/and
 
manually disconnect server/s from the network can lead to orphaned server/s records.
 

 
Use the following SQL statement to delete orphaned server records from
 
  "OnePoint" Database:
 
 
Start Of Script
--------------------------------------------------------------------------------------------------------
 
Use OnePoint
Go
Declare @computerID uniqueidentifier
Set @computerID = (Select idComputer from Computer Where
name = 'Put your machine name in here' AND domain
= 'Workgroup')
 

-- Perf Data --
Delete From SampledNumericData
WHERE idSampledNumericDataSource IN
(Select idSampledNumericDataSource From
SampledNumericDataSource where idComputer = @computerID)
Delete From SampledNumericDataSource
WHERE idComputer = @computerID
-- Events --
Delete From EventParam
WHERE idEvent IN (Select idEvent FROM Event WHERE
idloggedon=@ComputerID)
Delete From EventConsolidated
WHERE idEvent IN (Select idEvent FROM Event WHERE
idLoggedOn=@ComputerID)
Delete From Event
WHERE idGeneratedBy = @computerID
-- Alerts --
Delete From alertEventSuppression
WHERE idAlert IN (Select idAlert FROM alert WHERE
idComputer=@ComputerID)
Delete From AlertHistory
WHERE idAlert IN (Select idAlert FROM alert WHERE
idComputer=@ComputerID)
Delete From alert
WHERE idComputer=@ComputerID
-- Computer --
Delete From computerattribute
WHERE idComputer=@ComputerID
Delete From ComputerResponsibility
WHERE idConfigManager=@ComputerID
Delete From ComputerToComputerRule
WHERE idCOmputer=@ComputerID
Delete From Configuration
WHERE idComputer=@ComputerID
Delete From computer
WHERE idComputer = @computerID
 
 
 
--------------------------------------------------------------------------------------------------------
End Of Script
 
 

 
System Center Operations Manager
 
http://www.microsoft.com/mom/default.mspx