MOM 2000 Agent Computer 수동 제거 쿼리

Microsoft Operations Manager(MOM) 2000 환경에서 Agent Computer 가 어떤 이유에서든.... 삭제되지 않을 때, OnePoint 데이터베이스에서 직접 수동으로 삭제해 줄 수 있습니다. 

OnePoint 데이터베이스의 computer 테이블을 참조해서 ComputerName, DomainName 정보만 변경해 주시면 해당 컴퓨터 개체를 삭제할 수 있습니다. 단, Rules - Computer Groups 에 포함된 컴퓨터 이름은 삭제되지 않으니 콘솔에서 수동으로 제거해 주셔야 합니다.

Agent Computer 를 수동으로 삭제하는 Query 는 아래와 같습니다.

USE OnePoint
GO

DECLARE @idComputer AS uniqueidentifier
SELECT @idComputer = idComputer FROM Computer WHERE Name = 'ComputerName' and domain = 'DomainName'
DELETE AlertEventSuppression WHERE idAlert IN (SELECT idAlert FROM Alert WHERE idComputer = @idComputer)
DELETE AlertHistory WHERE idAlert IN (SELECT idAlert FROM Alert WHERE idComputer = @idComputer)
DELETE AlertToEvent WHERE idAlert IN (SELECT idAlert FROM Alert WHERE idComputer = @idComputer)
DELETE Alert WHERE idComputer = @idComputer
DELETE EventConsolidated WHERE idEvent IN (SELECT idEvent FROM Event WHERE idGeneratedBy = @idComputer)
DELETE EventParam WHERE idEvent IN (SELECT idEvent FROM Event WHERE idGeneratedBy = @idComputer)
DELETE Event WHERE idGeneratedBy = @idComputer
DELETE AlertToEvent WHERE idEvent IN (SELECT idEvent FROM Event WHERE idGeneratedBy = @idComputer)
DELETE SampledNumericData WHERE idSampledNumericDataSource IN (SELECT idSampledNumericDataSource FROM SampledNumericDataSource WHERE idComputer = @idComputer)
DELETE ComputerAttribute WHERE idComputer = @idComputer
DELETE ComputerToComputerRule WHERE idComputer = @idComputer
DELETE SampledNumericDataSource WHERE idComputer = @idComputer
DELETE Configuration WHERE idComputer = @idComputer
DELETE Computer WHERE idComputer = @idComputer

작성자 : Lai Go / 작성일자 : 2010.01.10