26 Eylül 2011 Pazartesi

Removing servers from database

USE[OperationsManager]
UPDATE
dbo.[BaseManagedEntity]
SET
[IsDeleted] = 1,
[LastModified] = getutcdate()
WHERE
Path = 'FQDN' OR Name = 'FQDN' OR DisplayName = 'FQDN' AND [IsDeleted] = 0

USE[OperationsManager]
UPDATE
dbo.[BaseManagedEntity]
SET
[IsManaged] = 0,
[LastModified] = getutcdate()
WHERE
Path = 'FQDN' OR Name = 'FQDN' OR DisplayName = 'FQDN' AND
[IsDeleted] = 1 AND [IsManaged] = 1

Hiç yorum yok: