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

clip_image001

  • 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>

image

(Visited 123 times, 1 visits today)

Tagged: , ,

1 comment

  1. […] ‘Conn Id in Infomart?’ in SGGU(www.sggu.com) forum and referred to the link ‘Link ConnId In Infomart’.  However, requester want to retrieve Conn ID directly from Infomart. As Conn Id field is stored in […]

Leave a Reply

Your email address will not be published. Required fields are marked *