08-25-2004 04:29 AM - edited 03-15-2019 03:00 AM
Is there a way to bulk add a new Service to all the phones without having to manually go to each phone and make it available?
08-25-2004 05:32 PM
The Batch Administration Tool (BAT) can do this to some extent, in at least 3.3(3) and above, and maybe below too. Go to the Configure menu, then Phones, then the Update Phones link on the right. You can build a query specifying which phones to subscribe, and then you use the "IP Services" (not "Services") option to pick the service to add and specify its parameters.
If the service you want to add requires no Parameters, it's pretty easy. If it requires Parameters but they are constant across all user subscriptions, it can also be done but you should try it on a very small group of phones first. The syntax for doing this is not obvious, poorly documented, and easy to screw up, but you'll see how it works if you try it a few times.
If your service requires parameters that vary for each user, like Personal Address Book and Fast Dials, there aren't any easy answers. You could still use BAT to do the service subscriptions and static Parameters, and fill in some arbitrary value for the variable Parameter. I've done this before when I needed to subscribe large numbers of phones to PAB/FD. You still have to go touch every phone, but you usually only have to correct one or two parameters on an existing service now, rather than subscribe the service for everyone and fill in every parameter by hand.
If your SQL-fu is strong, the Parameter retouching can be done faster by going directly into the service subscription database, but this would of course be unsupported. I set up a SQL view once that joined the phone description and the service names and parameters together into one virtual table, and that made it pretty easy to run down the list like a spreadsheet and fix the Parameter values rapidly right in SQL Enterprise Manager - I knew everyone's username based on their name, and the Description on each phone was the person's name. The service subscription table can be updated perfectly safely while CallManager is running.
There's no way to remove service subscriptions with BAT, so you want to make sure they go on right the first time when you do a large group. BAT will also happily subscribe a phone to the same service again even if it's already subscribed, so keep this needed cleanup in mind when you do your test groups and if your first import doesn't do what you want.
04-23-2005 12:09 PM
i'm working on some retouching of the parameters, bringing out some excellent SQL-fu, but what i've got is...
the Telecasterparamter database has the parameters and then the other telecaster table has the actual URL, but I need to somehow link this to the user or device table, but have found no linking parameter
04-25-2005 09:13 AM
Other than SQL....Has Cisco ever come up w/ a fix for this...I am in the same boat w/ about 2000-2500 sets all w/ PAB and Fast Dials...retouching reallt stinks!!
04-25-2005 12:53 PM
I still know of no way to do PAB/FD subscriptions conveniently in bulk. At this point, we simply don't advertise their presence on new installs. Abbreviated Dialing in CallManager 4.X has largely supplanted the Fast Dials service, and Webdialer has taken away some of the pressure to have PAB. If people really want them, we've taken to providing instructions so that people can subscribe themselves through CCMUser.
04-25-2005 12:29 PM
I cobbled up something quick and dirty with SQL Enterprise Manager. If you run this query or add it as a view, SQL EM will let you go in and change the parameter Values you see, which should hopefully make it easier on you to fix up subscriptions once they're already added (this is not for adding new subscriptions). No warranty, express or implied. May eat your database. May be harmful to small animals. Void where prohibited. Run a backup first.
I'm attaching it as a text file because the forum's word wrapping will make it more unintelligble than it already is. This was tested on a CallManager 4.0(2) database.
04-25-2005 01:56 PM
Would it be possible for you to explain what you're doing in that query? It's a little hard to follow.
Thanks!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide