Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Executing Repetative Commands UCM 7.1.5 telnet session

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super Bronze

Executing Repetative Commands UCM 7.1.5 telnet session

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

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
4 REPLIES
Super Bronze

Executing Repetative Commands UCM 7.1.5 telnet session

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

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

Executing Repetative Commands UCM 7.1.5 telnet session

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.

Super Bronze

Executing Repetative Commands UCM 7.1.5 telnet session

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

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
375
Views
0
Helpful
4
Replies