000032287 - How to remove the server from the Job Engine Manager's Server list in the RSA Archer 5.5.x Control Panel

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000032287
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.5.x


 
IssueYou want to remove a server from your environment however it still can be seen in the Job Engine Manager's Server list in the Archer Control Panel (ACP).
TasksManually remove the server that is no longer required using a SQL script.
ResolutionUse the below script against the Archer Configuration database to remove the server.
Note: Make sure to take a backup before executing the below script.
 
DECLARE @ServerName AS VARCHAR(50)
SET @ServerName='<ServerNameToDelete>'
DELETE FROM tblXPropertyTag WHERE tag_id IN (SELECT tag_id FROM dbo.tblTag WHERE tag='ServerName.'+@ServerName)
DELETE FROM dbo.tblTag WHERE tag='ServerName.'+@ServerName

Attachments

    Outcomes