cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

367
Views
25
Helpful
3
Replies
Highlighted

SQL for Phone Creation

Hello all,

I am new to SQL in general and to SQL on Call Manager. I have managed to use SQL Queries to run various reports

for example show DNs with CFA enabled.

run sql
SELECT CallForwardDynamic.cfadestination , numplan.dnorpattern
from CallForwardDynamic, numplan
where CallForwardDynamic.fknumplan = numplan.pkid and CallForwardDynamic.cfadestination!='' and CallForwardDynamic.cfadestination is not NULL

or change database values

run sql update enduser set userid='1000' where userid = 'theo'

I was wondering is there is way to insert phones.


At the moment, I am using the Bulk Administration Tool, where I have specified a Phone Template. So when I want to create new Phones, I have to upload a new CVS file and then create a Job Schedule.

 

Can I use SQL to do the same thing?

Thank you

 

Everyone's tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions

Re: SQL for Phone Creation

I rarely pitch a 3rd-party product but if you really want to script/automate provisioning off-box I suggest a tool such as Akkadian PME. Writing to the CUCM database is complicated, risky, and not supported unless you have a developer support contract with Cisco. The /ccmadmin GUI has extensive input validation that is not present at the database of AXL level. Pay for someone else to figure out all of that for you. Akkadian’s product has a RESTful northbound API for you to trigger provisioning jobs with.

3 REPLIES 3
Hall of Fame Cisco Employee

Re: SQL for Phone Creation

You need to use AXL if you want that, or any of the GUI options from CUCM.

HTH

java

if this helps, please rate

Re: SQL for Phone Creation

I rarely pitch a 3rd-party product but if you really want to script/automate provisioning off-box I suggest a tool such as Akkadian PME. Writing to the CUCM database is complicated, risky, and not supported unless you have a developer support contract with Cisco. The /ccmadmin GUI has extensive input validation that is not present at the database of AXL level. Pay for someone else to figure out all of that for you. Akkadian’s product has a RESTful northbound API for you to trigger provisioning jobs with.

Hall of Fame Master

Re: SQL for Phone Creation

I concur with my colleagues (+5) here on not using SQL directly and if you have some development experience using AXL SOAP API instead, there are many example out there on the web on how to do that with different programming languages i.e. Python.  SOAP API is not as simple as REST APIs, but Cisco does have decent documentation for it if you are willing to go that route.  I also agree on Akkadian which is superior to Cisco collaboration Provisioning product.

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards