[cisco-voip] Developer - SQL help - Call forwaring

[Tor-Ivar Kristoffersen]

Hey
Thanks for your reply. It pointed our developer in the right direction :)

We have been trying to get the data that we are looking for out of the database, but we cannot seem to find the Directory Numbers.
Does anyone know the table name for directory numbers ?
Does anyone have a list of nice to know tablenames ?

Best regard
Tor-Ivar Kristoffersen


Fra: Azeer Mohinder [mailto:cucm at gawab.com]
Sendt: 18. mai 2009 13:10
Til: Tor-Ivar Kristoffersen
Emne: RE: [cisco-voip] Developer - SQL help - Call forwaring

Hi,

I can only help with the SQL part here. I am not sure whether what you want to do is actually doable. But I can tell you this, there is no direct way to connect to CUCM database remotely. The proper way would be running SQL statements using the (run sql) CLI command. An alternative would be using Cisco CallManager AXL SQL Toolkit which is actually a plug-in you can download from your CUCM server. You can also use AXL API and query and update your CUCM database using executeSQLQuery  and executeSQLUpdate.

Regards

________________________________
From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Tor-Ivar Kristoffersen
Sent: Monday, May 18, 2009 9:12 AM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Developer - SQL help - Call forwaring
Hi

We have a developer here. And we would like for him to integrate a call forwarding function in another web site.

The reason for it is we have lots of numbers that are forwarded to the person on after hours duty. And we have synced our AD with the call manager so users can login to the call manager to change these settings. But we would  like to be able to do this easier from another web site where users have to log inn anyways to do other tasks.
So the question is.

Where can we find out how to connect via SQL to the call manager (is that the preferred way ? ) ?
And where can we find some sort of definition of the sql tables so we know what to change  ?
Also all other tips and tricks are welcome :)

We are running CUCM 6.3

Best regards
Tor-Ivar Kristoffersen
Lufttransport AS
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090518/5d432809/attachment.html>