Running CUCM ver 12.0 and everyone in my company uses extension mobility. Now we are rolling out Jabber to everyone but as I keep adding jabber profiles, my license count is increasing because auto registered phones do not have any owner user id assigned. I used the following sql query against a single MAC and it worked without any issues. However, when used the same query in bulk, ie without specifying a particular mac address but using the variable % sign, I got the error "System or internal error java.net.SocketTimeoutException: Read timed out"
run sql update device set fkenduser=(select fkenduser from extensionmobilitydynamic where fkdevice=device.pkid) where name like 'SEP%' and fkenduser IS NULL
If anyone could help that would be very much appreciated.
Thank you,
Khanal