Cisco CUCM SQL – Set Extension Mobility Button Label

By 19th April 2018Cisco, CUCM, SQL

Over time with many hands on a system it is possible for configuration standards to fall out of sync, accessing the CUCM database is a great way to locate and fix incorrect configuration values easily. The example below was part of a multi parameter tidy up for a client who required a consistent label on handsets for their Extension Mobility Login service.


UPDATE telecastersubscribedservice
SET urllabel = "Login"
WHERE (
fkdevice IN (
SELECT 
ts.fkdevice AS fkdevice
FROM telecastersubscribedservice AS ts
INNER JOIN device AS d ON d.pkid = ts.fkdevice
WHERE ts.urllabel != "Login" AND d.name LIKE "SEP%")
)
Mitch

Author Mitch

I am an independent IT Consultant with specialities in Software Development, Enterprise Unified Communication, Network and Security platforms. In addition to my day to day work, I develop bespoke applications and I hope that through ucdevops.com I can build relationships with clients, business partners and fellow engineers by providing solutions to complex problems through the use of programming.

More posts by Mitch