Executing Repetative Commands UCM 7.1.5 telnet session

[Live2 Bicycle]

7.1.5 does not have the option to change the voicemail profile on a line by using a custom file.  I found a way to update the voicemail profle via a Run SQL statement via a SSH session to the Publisher.

I have five thousand (5000) of these to do a day over the next 7 days. 

My issue is when I try to copy more then one  line at a time the second line does not get pasted correctly and fails.  It appears the clip board is trying to paste the info in to fast.  I need to get a pause or something.

I have tried putting several carriage returns in after each line -- that did not work.

I have played with the CR - LF parameter in Tera Term -- that did not work.

Here is what I get when I paste in 9 lines:

admin:

admin:

admin:run sql update numplan set fkvoicemessagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550023'
Rows: 1
admin:ofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550024'

Executed command unsuccessfully
No valid command entered
admin:run sql update numplan set fkvoicemessagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550031'
Rows: 1
admin:kvoicemessagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550047'

Executed command unsuccessfully
No valid command entered
admin:run sql update numplan set fkvoicemessagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550108'
Rows: 1
admin:lan set fkvoicemessagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550110'

Executed command unsuccessfully
No valid command entered
admin:run sql update numplan set fkvoicemessagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550112'
Rows: 1
admin:ssagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550115'

Executed command unsuccessfully
No valid command entered
admin:run sql update numplan set fkvoicemessagingprofile='a2ed9a30-bd05-13b7-ad28-b104e2b33078' where numplan.dnorpattern='3175550122'
Rows: 1
admin:
admin:

Out of the 9 lines pasted in only 5 completed successfully.

Thanks in advance for any suggestions!

Del

[Aaron Harrison · Accepted solution]

Hi Del

Helpful Answer first :

Generally you should use the CLI for prototyping your commands, then download the 'AxlSqlToolkit' from the plugins page. You can embed multiple SQL commands into the input file, start it up and off it goes...

Check the readme as they've done a really poor job of making it user friendly. Test it out with some selects until you are confident!

Cisco-Sponsored Answer:

Don't change the DB directly, use AXL. Then use SQL when AXL fails :-)

Aaron

[Live2 Bicycle]

Thanks Aaron,  I will give that a whirl! 

This is what I got back from Cisco yesterday when I asked my account team to run my sql statement but the internal dev team.  I LOVE disclaimers

Direct updates to the ccm database via SQL statements are not supported by TAC. It is possible to do fast and irreparable damage with direct SQL statements.  Take a backup before attempting any update and be prepared to restore from backup in case of any failure.  PKIDs vary by install so statements must be tailored to the install.

[Aaron Harrison]

Hi

Yeah, don't sweat that. It's equally possible to do 'fast and irreparable' damage with BAT and a little imagination :-)

The DB is actually quite well structured and enforces links between tables so it's not so risky as people make out.

Aaron

[Live2 Bicycle]

I found the below links that helped me get the AxlSqlToolkit going.  I hope this helps others.

http://www.netcraftsmen.net/resources/blogs/running-sql-queries-on-cucm-6x7x-using-axl-soap-toolkit-part-1.html

http://www.netcraftsmen.net/resources/blogs/running-sql-queries-on-cucm-6x7x-using-axl-soap-toolkit-part-2.html

http://www.netcraftsmen.net/resources/blogs/axl-sql-toolkit-part-3-updating-cucm-dirsync-ldap-filter-by-example.html

Del