Legacy Dev Forum Posts

 View Only

Sign Up

Back to discussions
Expand all | Collapse all

Oracle DB Query to Pull CDR

  • 1.  Oracle DB Query to Pull CDR

    Posted 06-05-2025 19:20

    benedicttobias | 2018-09-19 16:31:34 UTC | #1

    Hello, sorry for uncategorized. I am not sure where to ask.

    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 GCALL, GIR, etc.

    I tried to understand the documentation, 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.

    Jason_Mathison | 2018-09-19 16:52:03 UTC | #2

    What product are you trying to gather CDR for?

    benedicttobias | 2018-09-19 17:05:51 UTC | #3

    SQL Server. I do have console app that will build SQL server table from the query result. Project detail is abstract on my side. But that is my task.

    Query data from Oracle DB and insert it to SQL Server.

    Jason_Mathison | 2018-09-19 17:47:40 UTC | #4

    Sorry for the confusion, but which Genesys product are you using?

    benedicttobias | 2018-09-19 17:57:01 UTC | #5

    I believe they told me it is Genesys ICON. That is why I look for G_CALL on Oracle DB from this page.

    Jason_Mathison | 2018-09-19 18:10:45 UTC | #6

    Sorry for having to send you to a different forum, but this forum is for PureCloud questions. Most of the employees here are not very knowledgeable about the PureEngage products.

    I think that starting here: https://community.genesys.com/home and then clicking the PureEngage dropdown would probably get you to the right place to ask your question.

    Sorry I can't be of more help, --Jason

    benedicttobias | 2018-09-19 18:48:15 UTC | #7

    Understand. Thank you for your response.

    system | 2018-10-20 18:48:16 UTC | #8

    This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.

    This post was migrated from the old Developer Forum.

    ref: 3587



Related Content