DLP Oracle database query to pull the not reporting agents list

Products

• Data Loss Prevention Enforce
• Data Loss Prevention

Issue/Introduction

There is a requirement to pull a list of agents that are not reporting beyond a specific date.

Environment

All DLP versions

Resolution

Please run the below query in the database:

select * from agent where CONNECTSTATUS = '2' AND LASTCONNECTIONTIME >= 'DATE';  

 

Example query to return agents that have not reported in the last 30 days

 

select * from agent where CONNECTSTATUS = '2' AND LASTCONNECTIONTIME >= (SYSDATE-30);

 

As of DLP 26.1 direct database querying is no longer necessary and it is recommended you instead use the Agent Management APIs

Additional Information

CONNECTSTATUS values and their associated meanings. 

1 = Reporting
2 = Disabled
3 = Not Reporting