Description Archive/CDR tables RRS feed

  • Question

  • Hi,


    Where can I found a description of the different archive/CDR tables.

    Also which information is stored on the different actions (e.g. making OC to OC call, making an outbound voice call, receiving an inbound call, starting a Conference Call, ...)





    Friday, April 13, 2007 8:58 AM


  • Hi Dieter,

    We were able to find the following information in the OCS_Technical Overview.doc, but was unable to find any documentation related to the description of the tables. If we find such a table, we will post here.

    Call Detail Records (CDRs) provide a way to collect both IM and meeting data, and generate reports on usage characteristics, which can be used to determine network bandwidth load, employee usage patters, and return on investment. CDRs capture user logons and logoffs, IM conversations, and conference starts and joins.

    CDRs allow enterprises to monitor the amount of IM and conferencing activity for the purpose of developing data and metrics on employee usage and productivity. Enterprise administrators require such data to justify technology investments. Decision makers require such data to determine the return on investment.

    Network administrators specify which IM and conferencing usage data to capture. IM data includes registrations, call details, file transfers, audio and video calls, and remote assistance calls. Meeting data includes number of meetings, number of participants joining a meeting, number of data and Audio/Video instances joining a meeting, and details about private meeting IM calls and broadcast IM calls.

    Monday, April 30, 2007 6:16 PM