Genesys Engage on-premises

 View Only

Discussion Thread View

  • 1.  Oracle DB Query to Pull CDR

    Posted 09-19-2018 14:51

    Hello,

    I do have task where I have to build Oracle query (SELECT statement) for Genesys DB. I got connection to DB for all the tables for Genesys. For example, I see the table G_CALL, G_IR, etc.

    I tried to understand the documentation 1, but I am afraid to miss join or join the wrong table.

    Here is the basic CDR information that I need:

    • Start time
    • End Time
    • Media ID
    • Media Type
    • Employee/agent who respond
    • Call Type
    • Caller SIP
    • Callee SIP
    • Caller Telephone URI
    • Callee Telephone URI
    • Telephone Number
    • Referrer

    I am wondering if any of you fellow programmer can direct me where to pull this data correctly. Genesys might not have all of the fields that I need, It is OK.

    Does anyone have query snippet close to what I need?

    Thanks.



  • 2.  RE: Oracle DB Query to Pull CDR

    GENESYS
    Posted 10-03-2018 12:03
    I believe that if you join G_CALL and G_PARTY using CallId then that would get you most, if not all, of the fields you are looking for.

    The G_CALL table seems to have the start and end times for the call, ANI, DNIS, media type, etc.  If you join in the G_PARTY table, then you can determine the agent who handled the call.

    Hope that helps.

    ------------------------------
    Jim Crespino
    Director, Developer Enablement
    Genesys
    https://developer.genesys.com
    ------------------------------

    Original Message


Need Help finding something?

Check out the Genesys Knowledge Network - your all-in-one access point for Genesys resources