[cisco-voip] Call Waiting on 4

[Robert Singleton]

On Wed, 2006-05-10 at 16:10 +1000, Xris Brunton wrote:
> Hi I was wondering if anyone knows where to set a cluster wide “Busy
> Trigger” setting in 4.1. The “How Multiple Calls Per Line Work in
> Cisco CallManager 4.x” document hints this can be done. But I am
> unable to find where in the CallManager to set it; can’t find any
> instructions on the Cisco site, forums, callmanager help or the
> callmanager its self.

I also could not find an existing method to fix this systemwide. I could
not even find a place to change the default, which doesn't work for our
shared line model, either.

> Also this may be me miss interpreting the text that states “This busy
> trigger is database configurable, per line appearance, per cluster”;
> though I can’t see how it could mean anything else with the per
> cluster comment since having a line appearance that is not per cluster
> isn’t possible.

In our particular situation, my helpers were hardly ever changing the
default MaxNumRings/BusyTrigger settings, so I had a fairly random
distribution of incorrect settings. I used a database query, which one
can do from SQL Server Enterprise Manager, to identify which lines
needed correction. I had a 2-3 page list of specific lines that needed
correction and started doing the changes manually. It was a tedious job,
but not a particularly hard one.

Since then, I've gained the SQL confidence to write such changes via SQL
query. Beware, however, for it is trivially easy to accidentally change
and/or delete *every* line in the database, so this may not be
appropriate or worth the risk.

While I use isql on my Linux workstation to do most SQL work, I
formulated a query to use from Enterprise Manager to report what the
MaxNumCalls and BusyTrigger settings are on most of my telephones. Now,
since I have corrected everything to not be 4/2 as default, I had to use
a query that would produce output. The query is included below. :)

Robert

----------------------

SELECT Device.Name, NumPlan.DNOrPattern, DeviceNumPlanMap.Display,
DeviceNumPlanMap.MaxNumCalls, DeviceNumPlanMap.BusyTrigger,
TypeModel.Name AS Expr1, DeviceNumPlanMap.NumPlanIndex

FROM DeviceNumPlanMap INNER JOIN
NumPlan ON DeviceNumPlanMap.fkNumPlan = NumPlan.pkid INNER JOIN
Device ON DeviceNumPlanMap.fkDevice = Device.pkid INNER JOIN
TypeModel ON Device.tkModel = TypeModel.Enum

WHERE (DeviceNumPlanMap.MaxNumCalls = '2') AND (Device.tkModel BETWEEN
'7' AND '8')