Cisco Unified Communications Manager V6.1.1 database access

Unanswered Question
Mar 12th, 2010
User Badges:

I need to list the use of all DNs, specifically those used for Hunt Groups (Pilot amd Members) and CTI Points.

I know you can get all phone details from Bulk Admin, but this does not identify the above.

I need to determine all possible DNs used in an incoming call, be they CTI Route Point or Hunt Group for running reports on a Tiger Call Logger.

If not accessable via Web Admin how do I access the Infomix database

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Aaron Harrison Fri, 03/12/2010 - 09:57
User Badges:
  • Super Bronze, 10000 points or more
  • Community Spotlight Award,

    Member's Choice, May 2015

Hi


If you can get your head around the schema, you can just do a :


Run sql select...


From the server CLI (console, or SSH to the server).


For example:


Run sql select first 10 dnorpattern, description from numplan


If you can clarify exactly what you need (i.e. which fields) I can assist more...


Regards


Aaron


Please rate helpful posts...

Rob Huffman Fri, 03/12/2010 - 10:01
User Badges:
  • Super Blue, 32500 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

Hi James,


one pretty good method is via the;


Route Plan Report



The route plan report lists all assigned and unassigned directory numbers (DN), call park numbers, call pickup numbers, conference numbers, route patterns, translation patterns, message-waiting indicators, voice mail ports, and Cisco CallManager Attendant Console pilot numbers in the system. The route plan report allows you to view either a partial or full list and to go directly to the associated configuration windows by clicking the Pattern/Directory Number, Partition, or Route Detail fields.


In addition, the route plan report allows you to save report data into a .csv file that you can import into other applications. The .csv file contains more detailed information than the web pages, including directory numbers for phones, route patterns, pattern usage, device name, and device description.





Hope this helps!

Rob

Paul James Fri, 03/12/2010 - 10:19
User Badges:

Thank you I had forgotten about the save to CSV, but that does not get me all I want.

I need to be able to supply a list of all DNs and associated destinations

ie, to get a good report from our call logger I have to identify all possible numbers a trace may contain

An incoming call may go via a CTI Route Point a Hunt Pilot then terminate with a Hunt Member

I know I can get this individually but would like to have a listing

Actions

This Discussion