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

[Lelio Fulgenzi]

Your looking for the SOAP/AXL interface. If you do a search on this on CCO and include "developer" you'll eventually get to the section that you can download the index of SOAP commands. 

You should also look into the CUAE product which gives you access to more and delivers it in a GUI. 

--- 
Lelio Fulgenzi, B.A. 
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1 
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN) 
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
"Bad grammar makes me [sic]" - Tshirt 


----- Original Message ----- 
From: "Tor-Ivar Kristoffersen" <tik at lufttransport.no> 
To: cisco-voip at puck.nether.net 
Sent: Monday, May 18, 2009 9:06:13 AM GMT -05:00 US/Canada Eastern 
Subject: Re: [cisco-voip] Developer - SQL help - Call forwaring 




Hey 

Thanks for your reply. It pointed our developer in the right direction J 



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 J 



We are running CUCM 6.3 



Best regards 

Tor-Ivar Kristoffersen 

Lufttransport AS 
_______________________________________________ cisco-voip mailing list cisco-voip at puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090518/b3f44201/attachment.html>