<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>The problem with making direct changes to the SQL database is
that the phone does not know the change happened. That's why it is recommended
to use SOAP/AXL because that process initiates an update process to CallManager
and/or the phones.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>If you try changing the callforwardall of a line, you will
notice nothing happens on the phone.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT
size=2>--------------------------------------------------------------------------------<BR>Lelio
Fulgenzi, B.A.<BR>Network Analyst (CCS) * University of Guelph * Guelph, Ontario
N1G 2W1<BR>(519) 824-4120 x56354 (519) 767-1060 FAX
(JNHN)<BR>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<BR>Sanity First : Number of days with fewer than<BR>50 messages in my inbox at
the end of the day: buffer overrun</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=rsingleton@novateck.com href="mailto:rsingleton@novateck.com">Robert
Singleton</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=cisco-voip@puck.nether.net
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, May 10, 2006 10:32
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [cisco-voip] Call Waiting on
4</DIV>
<DIV><BR></DIV><BR>On Wed, 2006-05-10 at 16:10 +1000, Xris Brunton
wrote:<BR>> Hi I was wondering if anyone knows where to set a cluster wide
“Busy<BR>> Trigger” setting in 4.1. The “How Multiple Calls Per Line Work
in<BR>> Cisco CallManager 4.x” document hints this can be done. But I
am<BR>> unable to find where in the CallManager to set it; can’t find
any<BR>> instructions on the Cisco site, forums, callmanager help or
the<BR>> callmanager its self.<BR><BR>I also could not find an existing
method to fix this systemwide. I could<BR>not even find a place to change the
default, which doesn't work for our<BR>shared line model, either.<BR><BR>>
Also this may be me miss interpreting the text that states “This busy<BR>>
trigger is database configurable, per line appearance, per cluster”;<BR>>
though I can’t see how it could mean anything else with the per<BR>>
cluster comment since having a line appearance that is not per cluster<BR>>
isn’t possible.<BR><BR>In our particular situation, my helpers were hardly
ever changing the<BR>default MaxNumRings/BusyTrigger settings, so I had a
fairly random<BR>distribution of incorrect settings. I used a database query,
which one<BR>can do from SQL Server Enterprise Manager, to identify which
lines<BR>needed correction. I had a 2-3 page list of specific lines that
needed<BR>correction and started doing the changes manually. It was a tedious
job,<BR>but not a particularly hard one.<BR><BR>Since then, I've gained the
SQL confidence to write such changes via SQL<BR>query. Beware, however, for it
is trivially easy to accidentally change<BR>and/or delete *every* line in the
database, so this may not be<BR>appropriate or worth the risk.<BR><BR>While I
use isql on my Linux workstation to do most SQL work, I<BR>formulated a query
to use from Enterprise Manager to report what the<BR>MaxNumCalls and
BusyTrigger settings are on most of my telephones. Now,<BR>since I have
corrected everything to not be 4/2 as default, I had to use<BR>a query that
would produce output. The query is included below.
:)<BR><BR>Robert<BR><BR>----------------------<BR><BR>SELECT Device.Name,
NumPlan.DNOrPattern,
DeviceNumPlanMap.Display,<BR>DeviceNumPlanMap.MaxNumCalls,
DeviceNumPlanMap.BusyTrigger,<BR>TypeModel.Name AS Expr1,
DeviceNumPlanMap.NumPlanIndex<BR><BR>FROM DeviceNumPlanMap INNER
JOIN<BR>NumPlan ON DeviceNumPlanMap.fkNumPlan = NumPlan.pkid INNER
JOIN<BR>Device ON DeviceNumPlanMap.fkDevice = Device.pkid INNER
JOIN<BR>TypeModel ON Device.tkModel = TypeModel.Enum<BR><BR>WHERE
(DeviceNumPlanMap.MaxNumCalls = '2') AND (Device.tkModel BETWEEN<BR>'7' AND
'8')<BR><BR><BR><BR>_______________________________________________<BR>cisco-voip
mailing list<BR><A
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><BR><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A><BR><BR></BLOCKQUOTE></BODY></HTML>