CMS Data

[newglide]

I am not a data base guy so I apologize ahead of time for lack of detail.
We have 2 CMS ver 18, 1 is running in standby and the other is the primary.
What we would like to do is access the data to run reports on.
The CMS only stored detail data for 30 days. We would like to get detail for up to a year or more.
Is it possible for the CMS to push the data off of the cms and store the data externally somewhere?

 

[BIS]

Yes - look into ECHI, external call history.

 

[Stinney]

You can use the ODBC connection in CMS to allow an external database server to access the system and pull data from any of the historical tables. Your DBA group should be able to setup an automated process that grabs that data daily, weekly, monthly, however you want it setup.

- Stinney

“The man who asks a question is a fool for a minute, the man who does not ask is a fool for life.” - Confucius