Required Subscription: Mitel MiVC
Required Permission Level: Administrator
Brightmetrics does not have any inherent support for Mitel (formerly ShoreTel) archive databases. Some customers connect to the archive database by setting it up as an additional Mitel data source instance — essentially treating it as a second Mitel system entirely. In this case, there is always some manual work on the Brightmetrics side to point the agent to a non-standard MySQL connection, regardless of which server it is on.
Since Brightmetrics processes CDR data to produce a summarized aggregate data set that is uploaded to our hosted system, we retain that summary data going back up to three years with no dependence on the original data being available on your Mitel database. The CDR data only needs to remain available if you need to drill down into individual call records, since we don't store those.
If you would like to add Brightmetrics reporting for your archive database, it will create an additional data source that you will be billed for — but we can use the same agent that is already set up as long as it has access to the archive server. To set this up, follow the steps in our Adding Additional Data Sources article.
The 4GB CDR database limit
Mitel enforces a 4GB CDR database limit, which affects the amount of data available within your retention period. In larger environments, this limit can be hit within days or weeks. The way to maintain reporting is to set up a CDR archive.
To avoid hitting the 4GB limit, set your CDR retention period on the CDR database to 1 day (so there is no historical database on the main CDR server), set the archive retention period to 2 years, and configure your CDR archive to archive daily.
With this setup, the primary summary source will come from the archive and will be up to a day old. You won't be able to report on anything that happened today outside of Real Time, but you'll have access to all historical data with a one-day delay.
If it is also important to run detailed reports for the current day, a second subscription of Brightmetrics can be installed on the main CDR database to allow same-day detailed reporting.
Questions or feedback? Please email us at support@brightmetrics.com.