How to fetch username and endpoint server associated with the agents shown in agent overview (Enforce console > system and detectors > Agents > Agent overview) from the database

Products

• Data Loss Prevention

Issue/Introduction

If there is a use case where a customer wants to pull username and endpoint server associated with the agents as displayed in agent's overview from the database to meet business requirements.

Environment

DLP  

Resolution

Note: Table and column names can be changed in the future releases so please change them in the queries accordingly. 

 

1. In order to get username, run this query: SELECT username from AGENTUSERNAMEVIEW inner join Agent on Agent.AGENTID = AGENTUSERNAMEVIEW.AGENTID;

2. In order to get endpoint server, run this query: SELECT INFORMATIONMONITOR.MONITORNAME from INFORMATIONMONITOR inner join Agent on AGENT.AGGREGATORID = INFORMATIONMONITOR.INFORMATIONMONITORID;

Additional Information

Please note: Running queries directly on the DLP database is not supported nor encouraged. Hence proceed with the queries at your own risk.