Mitel Phone System Database Information

[ManufacturingDS]

Hi all,

So, I just started working with some Mitel Phone data that we are planning to dig into for some in-house analytics. First thing I come across is the SQL Server with few databases:

[ul]
[li]CCMData[/li]
[/ul]

[ul]
[li]CCMRuntimeServices[/li]
[/ul]

[ul]
[li]CCMStatisticalData[/li]
[/ul]

[ul]
[li]Ccmwa[/li]
[/ul]

I did some online search and went through the online documentation available at Mitel's website, BUT I can't find anything that documents what these databases are for, what are the tables/views inside and what each variable in the table means.

I would very much appreciate if someone could direct me to correct source where I can find the information or if you have come across this, then how did you get the understanding of what's being stored inside these. Thanks in advance!

 

[Lundah]

Those are the SQL databases used by MiContact Center Business for reporting on call statistics. Normally you'd run reports on that data from MiCC, specifically from CCMWeb.

 

[Billz66]

there is a SQL Views Advanced Data Access Guide 6.0.2.1 - i think its only available via KMS
this contains information on how to generate SQL queries to retrieve call information

If I never did anything I'd never done before , I'd never do anything.....