Author Topic: Get raw data in a table from MiCC  (Read 2768 times)

Offline Ronan

  • Full Member
  • ***
  • Posts: 149
  • Country: fr
  • Karma: +1/-0
    • View Profile
Get raw data in a table from MiCC
« on: April 11, 2019, 09:46:50 AM »
Hello,

my client wants to do some bell curve charts of abandoned calls.

However with CCMWeb I can only get the calls spread in a spectrum, making the data unusable for the purpose.

With a lifecycle chart I can access all the calls of the day, or alternatively looking at the SMDR data, but I'm not going to do this manually, we're talking about hundreds of abandoned calls a day.

Alternatively if you know how to get the data from the SQL database, that could also work.

Thanks


Offline sarond

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1404
  • Country: au
  • Karma: +73/-0
    • View Profile
Re: Get raw data in a table from MiCC
« Reply #1 on: April 11, 2019, 07:56:17 PM »
I'm not a DBA but we have given access to the SQL database to one of our clients and they just extract their own data or create their own reports.
There are some existing 'views' already created.

If they know what their doing I don't believe it's that difficult, they will just need access to the MSSQL.

If you want the raw data it is kept in the C:\Program Files (x86)\Mitel\MiContact Center\DataDirectory\Node_{xx} directory of the MiCC server. Each file will be prefixed with either a (ACD Data), s (SMDR Data) or t (Trunk Data)

Offline Ronan

  • Full Member
  • ***
  • Posts: 149
  • Country: fr
  • Karma: +1/-0
    • View Profile
Re: Get raw data in a table from MiCC
« Reply #2 on: May 13, 2019, 09:44:48 AM »
Thanks. They've put a "data engineer" on the subject, we'll see how that goes.

Offline krazzer

  • New Member
  • *
  • Posts: 1
  • Country: gb
  • Karma: +0/-0
    • View Profile
Re: Get raw data in a table from MiCC
« Reply #3 on: May 23, 2019, 05:03:29 AM »
Hi Ronan, did you manage to make any progress with querying the database? We have tried this alternative and we've been finding very difficult make sense of the data and it seems to be based on your configuration which probably is not the right one for reporting. Any advice? Thanks.
« Last Edit: May 23, 2019, 05:08:08 AM by krazzer »

Offline Ronan

  • Full Member
  • ***
  • Posts: 149
  • Country: fr
  • Karma: +1/-0
    • View Profile
Re: Get raw data in a table from MiCC
« Reply #4 on: July 08, 2019, 05:12:35 AM »
Hello,

no I have no update at this time.

Offline benmills

  • New Member
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: Get raw data in a table from MiCC
« Reply #5 on: February 28, 2022, 08:42:14 AM »
Did anyone manage to find SQL access to the call data?

In an old ShoreTel system, we had access to a MySql "CDR" database.  Looking for something similar in Mitel MiVoice Business or MiCC.


 

Sitemap 1 2 3 4 5 6 7 8 9 10