SHORETEL IS NOW PART OF MITEL. See how powering connections in the cloud is now brilliantly simple.

ECC Call Log Tables

Jun 10, 2016 05:02 PM PDT
Marcus Williams
Northcentral University
I'm trying to create some custom reports based on the ECC MYSQL tables. Is there a table schema available anywhere. I know there is a call log in the CDR database but the ECC database tables are not very clearly named.
Jul 16, 2016 03:22 PM PDT
Damian Galindo
Global CTI Group
The main ECC database is not published and read only access would require a sign-off from ShoreTel, request this through your partner. The CCIR database is published and can be installed on another server. The CCIR would contain records on a per-call basis as well as any events that occurred on that call. The CCIR is documented in the ECC reporting guide. A ST-Pro-Services application(CCIV and Transaction Service bundle) can build a table within the CCIR instance that combines raw CCIR data into a single row per call.

For additional help with the ECC database you may need to go to your partner or post specific questions in the forum.

To reply to this post please Sign In