09-18-2002 02:05 AM - edited 03-12-2019 08:49 PM
What would be the best way to implement new phone service on over 500 phones without having to configure it manually for each phone ?
Solved! Go to Solution.
09-18-2002 03:30 AM
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
09-18-2002 03:30 AM
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
09-19-2002 07:07 AM
Thanks :-)
09-18-2002 07:06 AM
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
09-19-2002 07:09 AM
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 !
09-19-2002 10:16 AM
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
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: