In our Data Warehouse integration, many tables will populate an agent ID. This agent ID can be from any integrated system in MaestroQA (helpdesk, telephony, LMS, etc.).
Due to this, you may see agent ID values in our tables that you don't recognize.
The good news is that you can use the MaestroQA helpdesk_id_email table to grab the pertinent agent_id to use in your joins.
The following example uses the coaching_sessions table to illustrate this, but the same query could be used for any table containing an agent ID.
Table B is used to represent your internal table that can map the table you join to.
SELECT A.*, B.*
FROM coaching_sessions A
JOIN helpdesk_id_email C1 ON A.agent_id = C1.agent_id
JOIN external_table B ON B.agent_id IN (SELECT C2.agent_id FROM helpdesk_id_email C2 WHERE C1.email = C2.email)