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:
Yorum Gönder