Simple adhoc reporting tool for Call Manager

[LeendertV]

We are running on Call Manager 3.2 for the last 2 years now, and found it quite difficult to maintain the paperversion of the corperate phonebook in sync with the one on the CM. As information is partly stored in the DC Directory and party in the SQL database, I'm looking for an tool to retrieve information from these 2 sources in an integrated way. For example to generate reports like:
- Free (eg. unused) extensions in our numberplan
- create paper version of our internal phone list

I've been looking for such a tool a couple of times, but haven't been able to find one. Does anyone a good tool to use?

Leendert

 

[mia158]

Try using the Route plan report. You can save the report to a .csv file. Then do what you wan to it.

 

[LeendertV]

Thanks MIA. The CSV list give us indeed the possibility to see all used numbers. Netherless, I'm still looking for a simple tool to extract Ad-hoc data from the callmanager (something like Business Objects or Cognos).

Leendert

 

[AdmanOK]

It's a SQL database so you could just use Cognos to write your reports.

 

[LeendertV]

Thanks AdmanOK, yet the SQL database doesn't contain all info. A lot of (important) info is in the DC directory. Any other idears?