<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Navigate to the softkey template under device, device setttings,
softkey template. select your softkey templates one at a time<br>
click the 'dependency records' link in the upper right hand corner.<br>
<br>
if 'dependency records' is not shown enable it under enterprise
parameters.<br>
<br>
/Wes<br>
<br>
Tim Reimers wrote:
<blockquote
cite="mid050944EE48FF384F9C663F7048C47DA70503E4D6@webmail.asheville.k12.nc.us"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
<div dir="ltr" align="left"><span class="811410214-05102006"><font
color="#0000ff" face="Arial" size="2">All--</font></span></div>
<div dir="ltr" align="left"><span class="811410214-05102006"></span> </div>
<div dir="ltr" align="left"><span class="811410214-05102006"><font
color="#0000ff" face="Arial" 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"></span> </div>
<div dir="ltr" align="left"><span class="811410214-05102006"><font
color="#0000ff" face="Arial" 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"></span> </div>
<div dir="ltr" align="left"><span class="811410214-05102006"><font
color="#0000ff" face="Arial" size="2">Tim</font></span></div>
<br>
<div class="OutlookMessageHeader" dir="ltr" align="left" lang="en-us">
<hr tabindex="-1"><font face="Tahoma" size="2"><b>From:</b>
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip-bounces@puck.nether.net">cisco-voip-bounces@puck.nether.net</a>
[<a class="moz-txt-link-freetext" href="mailto:cisco-voip-bounces@puck.nether.net">mailto:cisco-voip-bounces@puck.nether.net</a>] <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> <a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> Re: [cisco-voip] Making phone changes through SQL ?<br>
</font><br>
</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 size="4" width="90%">
_______________________________________________
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>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
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>