Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Easy way to distribute new Phone Service

What would be the best way to implement new phone service on over 500 phones without having to configure it manually for each phone ?

1 ACCEPTED SOLUTION

Accepted Solutions
New Member

Re: Easy way to distribute new Phone Service

Note: this is probably not a supported solution!

Note: This has only been tested on CM 3.1(3a), the Database structure may be different on other versions

The easiest way to do this is via a SQL query. E.g. manually add the service to one phone through CM admin web pages, then view the table "TelecasterSubscribedService" and find the one you have just added. For that record, make a note of the value for the "serviceURL" field (I will now refer to this value as varA), the "serviceName"(varB) and "fkTelecasterService"(varC).

You can then write a script which adds additional rows to this table for all devices returned from a query on "Devices" table.

The SQL to insert the new row is:

insert into TelecasterSubscribedService (pkid, fkDevice, serviceURL, serviceName, fkTelecasterService) VALUES (NEWID(),varD, varA, varB, varC)

varD = The pkid of the phone you wish to add the service to from the "Devices" table.

Obviously test it on 1 phone first!

Good Luck

5 REPLIES
New Member

Re: Easy way to distribute new Phone Service

Note: this is probably not a supported solution!

Note: This has only been tested on CM 3.1(3a), the Database structure may be different on other versions

The easiest way to do this is via a SQL query. E.g. manually add the service to one phone through CM admin web pages, then view the table "TelecasterSubscribedService" and find the one you have just added. For that record, make a note of the value for the "serviceURL" field (I will now refer to this value as varA), the "serviceName"(varB) and "fkTelecasterService"(varC).

You can then write a script which adds additional rows to this table for all devices returned from a query on "Devices" table.

The SQL to insert the new row is:

insert into TelecasterSubscribedService (pkid, fkDevice, serviceURL, serviceName, fkTelecasterService) VALUES (NEWID(),varD, varA, varB, varC)

varD = The pkid of the phone you wish to add the service to from the "Devices" table.

Obviously test it on 1 phone first!

Good Luck

New Member

Re: Easy way to distribute new Phone Service

Thanks :-)

New Member

Re: Easy way to distribute new Phone Service

The BAT->phone->modify phone screen gives you the option to create a query and add services to those devices. I've never actually used BAT for this purpose, but I think it should work.

Good luck,

Vance

New Member

Re: Easy way to distribute new Phone Service

Thanks Vance for your reply.

I think I can only use Bat and the Subscribe Service option when I need to configure a new template for new phones but not to add subscription to phones that are already registered !

New Member

Re: Easy way to distribute new Phone Service

Ok, but there's a whole ton of stuff you can do to phones that are already registered... Have you looked at the Update Phone page on the latest version of BAT? It's pretty cool.

My 2 cent.

Vance

268
Views
0
Helpful
5
Replies
CreatePlease login to create content