Announcement

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

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

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

    Comment


    • #3
      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.

      Comment


      • #4
        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.

        Comment


        • #5
          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?

          Comment

          Working...
          X