|Applies To||RSA Product Set: DLP|
RSA Product/Service Type: Enterprise Manager
RSA Version/Condition: 9.5 SP1
O/S Version: 2008 Server R2 Standard (64 bit)
|Issue||How to remove endpoint agents that have been inactive for a long time from Enterprise manager?|
|Resolution||To list the endpoints that have been inactive since a certain date ,use the following select query from the Enterprise manager database:|
select * from EP_AGENT_SYSTEM_EVENT where heartbeat_timestamp < '2016-04-20 00:00:00.000'
To proceed with deleting these endpoints from the status table run the following delete statement from the Enterprise manager database:
delete from EP_AGENT_SYSTEM_EVENT where heartbeat_timestamp < '2016-04-20 00:00:00.000'