Call Manager 5 and 6 SQL Query Handlers OFFER

Unanswered Question
Jun 24th, 2008
User Badges:
  • Silver, 250 points or more

Guys,


Attached are Perl script sources and outputs of my custom tool for executing SQL Queries against a CM Database.


CMDatabaseDumper.pl allows you to dump the database and table structure of a cm database to a text file to help you for queries. should do any version of informix


CMDatabaseQuerytoExcel.pl This file dumps a specific SQL Query to a very nice and readable CSV!



Hope someone else finds use in these!



HTH,


Chad



Attachment: 
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
ivillegas Tue, 07/01/2008 - 12:33
User Badges:
  • Silver, 250 points or more

In CallManager 3.3, 4.x the database is SQL 2000.

In CallManager 5.x and 6.x, the database is Informix.

In IPCCX the database is SQL 2000 or MSDE 2000.

In ICM version 7.x, the database is SQL 2000.

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00800e1529.shtml

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801d71c5.shtml


Chad Stachowicz Tue, 07/01/2008 - 15:11
User Badges:
  • Silver, 250 points or more

I understand, these are tools for created specifically for CCM5 and CCM6 whihc use informix. They do an executeSQLQuery and then it dumps the results into a nicely readable excel!


Cheers,


Chad

Ayodeji Okanlawon Tue, 07/15/2008 - 11:59
User Badges:
  • Super Bronze, 10000 points or more
  • Cisco Designated VIP,

    2017 IP Telephony

Chad,


How do we use this?

Chad Stachowicz Tue, 08/12/2008 - 13:12
User Badges:
  • Silver, 250 points or more

aoklawan, Would you like me to upload a precomiled version you can test running? It basically just executes a query and dump it into Excel, allows your to dump queries to reports pretty easy if your good with informix. I use the idea to write auto configuration puller of whole CCM..


Chad

rameshbalajiv Tue, 07/15/2008 - 11:52
User Badges:

I am new to Cisco world and am primarily perform DBA activitives.

I am looking to connect to the UCM 6.1 using Informix ODBC Driver. What is the Service name setup by default and port #.

I have the server name, database name but without above information, unable to test the connectivity.

If you have those information, please let me know.

Thanking You

Ramesh V.

anwar-ahmed Thu, 10/22/2009 - 09:45
User Badges:

Hi,


Did you resolve this issue. I am working callmanager 7.1 and need ODBC connection with informix.


What database name should we use.


Thanks in advance


anwar ahmed

Actions

This Discussion