Cisco IMP SQL – Updating The Domain Names of Jabber Contacts

By 12th April 2018Cisco, IM & P

Do you need to change your IM & P domain ? How will you ensure that Jabber contacts work seamlessly following the change?

Sql Update
 
  1. UPDATE rosters
  2. SET contact_jid = REPLACE(contact_jid,"@olddomain.com", "@newdomain.com")
  3. WHERE contact_jid LIKE "%@olddomain.com"
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
"