<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=811410214-05102006><FONT face=Arial
color=#0000ff size=2>All--</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=811410214-05102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=811410214-05102006><FONT face=Arial
color=#0000ff size=2>I have the same problem as TechGuy -- but I want to
discover the scope of the issue first, to see if just hand editing phones will
work.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=811410214-05102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=811410214-05102006><FONT face=Arial
color=#0000ff size=2>Is there a way for me to query <something> to find
out how many lines/phones have a SoftKey template setting -other- than 'none' or
'default' ??</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=811410214-05102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=811410214-05102006><FONT face=Arial
color=#0000ff size=2>Tim</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <B>On Behalf Of </B>Wes
Sisk<BR><B>Sent:</B> Wednesday, October 04, 2006 10:00 AM<BR><B>To:</B> Tech
Guy<BR><B>Cc:</B> cisco-voip@puck.nether.net<BR><B>Subject:</B> Re: [cisco-voip]
Making phone changes through SQL ?<BR></FONT><BR></DIV>
<DIV></DIV>1. not supported by Cisco. You're on your own. there are
*MANY* dependencies in the SQL database and data validation rules are
implemented in DBL not directly in SQL. This is why updates should go
through BAT, AXL, or CCMAdmin to pass through DBL and data validation.
This means you are allowed to insert garbage directly into SQL. CM does
not validate data so the effects of your changes could be interesting.<BR>2.
depending on CM version you *MAY* not get change notification. In 4.x CN
is generated by Insert/Update/Delete triggers on the tables in SQL. This
means any update directly to SQL will generate a change notification. Same
is true of 5.x. Same is not true of 3.x. For 3.x you would have to
make the changes and then reboot the server. Also changes must be made on
the publisher to replicate down to subscribers. Updating a subscriber will
only update the local subscriber DB and that will not replicate to any other
server in the cluster. Also, when the system is working properly the
subscriber DB will never be read anyway.<BR><BR>I know admins of several large
systems who depend on direct mods to SQL due to lack of features in BAT.
Those admins follow 3 rules to be successful:<BR>1. be very good at SQL's
tri-valued logic i.e. True, False, and NULL<BR>2. verify changes on a lab box
first<BR>3. backup the CCM database before making changes. If anything goes awry
restore the backup and go back to the lab.<BR><BR>/Wes<BR><BR>Tech Guy wrote:
<BLOCKQUOTE cite=middef9a76c0610040623u15442e44p44b1820e70ab33c3@mail.gmail.com
type="cite">
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>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. </DIV>
<DIV> </DIV>
<DIV>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. </DIV>
<DIV> </DIV>
<DIV>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. </DIV>
<DIV> </DIV>
<DIV>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? </DIV>
<DIV> </DIV>
<DIV>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.</DIV><PRE wrap=""><HR width="90%" SIZE=4>
_______________________________________________
cisco-voip mailing list
<A class=moz-txt-link-abbreviated href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A>
<A class=moz-txt-link-freetext href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A>
</PRE></BLOCKQUOTE></BODY></HTML>