Announcement

Collapse
No announcement yet.
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • agentouk
    replied
    Interesting, @bhaikalis. We've only ever had a single entry and only 1 agent associated with each call for each call into the CDR table (regardless of how many agents were'involved')

    Can you provide any additional information on how this is configured, or even supply some anonymous data showing what you have access to?

    Leave a comment:


  • bhaikalis
    replied
    No, the CDR should show all legs of the call not just the final leg. Not sure how your setup is but it shouldn't be limited to just ECC calls. The core system should still show all calls that come into any of your trunks.

    Leave a comment:


  • agentouk
    replied
    Originally posted by bhaikalis View Post
    If you are just looking to report on calls why not use the CDR database rather than the Oaisys?
    We do, but the CDR database only includes calls made through ECC, and not all calls I am trying to track pass through ECC. In addition, when multiple agents are involved in a call, CDR only shows the first agent offfered the call, not necessarily the agent who actually spoke to the customer.

    Leave a comment:


  • bhaikalis
    replied
    If you are just looking to report on calls why not use the CDR database rather than the Oaisys?

    Leave a comment:


  • agentouk
    started a topic Oaisys Database Layout / Diagram request

    Oaisys Database Layout / Diagram request

    I have access to the database used by Oaisys and am trying to build a data extract. I'm trying to get the detailed view information from the "bottom half" of Oaisys Management Studio.

    I have found the core information in the "CTSDevices" database. I can also find the extensions/users involved in the "CallExtensionAssoc" table (but this has no start/end times) to determine a users call length, and also the start time and end time of the recording in the "Annotations" table (but this has no user information)

    Can anyone help with how to link the call information to the start and end time of the user taking the call so I can build this extract and report on it?
Working...
X