[cisco-voip] Making phone changes through SQL ?

[Matt Slaga (US)]

You need to read up on AXL.  While you could directly edit the SQL
database, and perhaps for this one field it would not be an issue but if
you inadvertently remove the wrong field you could render your system
inoperable, and I don't think TAC will be excited about helping you fix
a self-inflicted bombshell like that.

 

You should also look into Unimax, they have a very interesting product
which is great for making changes like this.  It may be worth looking
into.

 

You should almost never make individual settings on phones that are
available in device pools for this exact reason.

 

 

________________________________

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Tech Guy
Sent: Wednesday, October 04, 2006 9:24 AM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Making phone changes through SQL ?

 

I am no SQL guru, hell not even a CallManager guru.  Though I knew alot
about it, but the more I talk to others and see the way others do things
the more you come to realize just how little you know.

 

This leads me to want to confirm some thing.  I am almost 99.9% positive
that you can change just about anything you want through SQL, if it is
in the database you can change it and as long as you do it right there
shouldn't be a problem. 

 

Earlier this week I asked about changing the phone softkey field through
BAT.  Can't seem to find an option to do this within BAT, people
informed me that you could kinda do this through the device pool.
Helpful yes, but not exactly. 

 

See the problem with the device pool is that only works if the phones
are set to "none" for the softkey field so then they inherit the setting
from the device pool.  Well apparently when they had CallManager setup
over here someone set all the softkey fields on each phone to the same.
So, changes to the device pool are not taking affect for me. 

 

So this is all part of why I am wanting to confirm things in regards to
making edits directly through SQL instead of through CallManager.  It
should be a simple task through SQL to make this sort of mass change.
After all isn't that alot of what CallManager and BAT are, just front
ends to SQL database?  I am referring to the web pages like ccmadmin of
course, I know they do more but the essence of the web pages for
ccmadmin and BAT are just easy ways to manipulate the SQL database
right? 

 

Thanks for the help so far, its a pleasure to be a part of such an
active and informative mailing list.  By far the best one I have been a
part of in the past 15 or so years.




-----------------------------------------
Disclaimer:

This e-mail communication and any attachments may contain
confidential and privileged information and is for use by the
designated addressee(s) named above only.  If you are not the
intended addressee, you are hereby notified that you have received
this communication in error and that any use or reproduction of
this email or its contents is strictly prohibited and may be
unlawful.  If you have received this communication in error, please
notify us immediately by replying to this message and deleting it
from your computer. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20061004/135fba90/attachment-0001.html