Link ‘ConnID’ with Interaction Id in Infomart

In Genesys environment, most of us are still used to track call information using Connection Id (ConnID). However, Genesys Infomart (GIM), core subject areas are linked with interaction id and this post will help you to get interaction id using connid or vice versa.

To get interaction id using conn id

• Login into Genesys Icon database and query ‘g_call’ table using your conn id as below.

select  id, callid, connid, irid, rootirid from g_call where connid = < your conn id here>

From the results, take note of rootirid. A call can have multiple conn id due to transfers and column ‘rootirid’ links call records like below

• Now, login into Genesys Infomart database and query ‘interaction_fact’ using query below

select * from interaction_fact where media_server_ixn_guid = <your root irid here>