cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
181
Views
0
Helpful
0
Replies
Highlighted
Participant

Bulk update owner user id for EM Users

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

 

0 REPLIES 0
Content for Community-Ad