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 since 10 September 2024.

 

  select * from agent where CONNECTSTATUS = '2' AND LASTCONNECTIONTIME >= '10-SEP-24';

Additional Information

CONNECTSTATUS = '1' is for the reporting agents

CONNECTSTATUS = '2' is for the not reporting agents