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

Community Helping Community

237
Views
5
Helpful
7
Replies
Highlighted

CUCM sql question

Hi,

How can I run several repeating commands in CUCM sql ? Can I just copy the list of command and paste , like i do with cisco router IOS ? Or is there way to run TCL script ?

Thank you 

 

 

Everyone's tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Contributor

Re: CUCM sql question

Don't reinvent the wheel. Check the 'offiical' python script examples:

https://www.vandyke.com/support/securecrt/python_examples.html

 

The Send.Data.py example looks like what you're after.

View solution in original post

7 REPLIES 7
VIP Advisor

Re: CUCM sql question

I used some time back..CUCM using the Cisco AXL API you can use that for scripting.

BB
*** Rate All Helpful Responses ***
Contributor

Re: CUCM sql question

It's either AXL or you can script SecureCRT or whatever terminal client you're using or a whole lot of copy/pasting.
VIP Advisor

Re: CUCM sql question

what are you looking, Hope if i understand correctly you looking to automate and execute the SQL right ?

and store the results either email or file. ( success or failure).

BB
*** Rate All Helpful Responses ***

Re: CUCM sql question

I have to turn off display name on about 200 cisco codecs. I have made sql command and tested successfully but it's just one line and I'd need to copy paste 200 times :D . U mentioned securecrt , I have it , how to automate with it or  script on it? , sorry guys im not good with AXL and think is freaking complicated as every cisco stuff.

 

securecrt , I have it , how to automate with it or  script on it? 

Thank you 

Re: CUCM sql question

Looks like I found way to do in SecureCRT, there is embedded functionality u can record script and save as vbs or python and then edit and run it. Its very good for  people like me not so expereinced with scripting :) .

I ll try to solve my problem and send SQL command to CUCM and see how it will work . I just need to recall  now how to make pause and wait  response from sql serevr in the python script before to send next line.

Contributor

Re: CUCM sql question

Don't reinvent the wheel. Check the 'offiical' python script examples:

https://www.vandyke.com/support/securecrt/python_examples.html

 

The Send.Data.py example looks like what you're after.

View solution in original post

Re: CUCM sql question

Yeeees, u r right, Thank you bro :) 

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here