Chris Deren Mon, 01/20/2014 - 07:56
User Badges:
  • Super Silver, 17500 points or more
  • Hall of Fame,
  • Cisco Designated VIP,

    2017 IP Telephony, Contact Center, Unified Communications

SQL update.


Chris

mightyking Thu, 05/18/2017 - 13:07
User Badges:

Hi Chris,

Could you please share the SQL query to update the User Owner ID. I have 10000 SCCP phones that I need to migrate to SIP and have issues to update the User Owner ID.


Thanks,


MK

Carlo Poggiarelli Mon, 01/20/2014 - 07:58
User Badges:
  • Green, 3000 points or more

Hi Chris.

Do you want to set the same owner for all 65 phones or one different owner per phone?


Let me know


Regards



Carlo




Please rate all helpful posts

"The more you help the more you learn"

Matt Domnick Tue, 02/25/2014 - 10:06
User Badges:

Any documented solution for this task?


As I see it, it will take 4 BAT jobs:

1.  Export the phone details and modify the CSV to include Owner IDs

2.  Run a BAT job to delete the exisiting phones

3.  Run a BAT job to re-add the phones with Owner IDs (from step 1 above)

4.  Run a BAT job to re-Associate the End Users to the Phones

Actions

This Discussion

Related Content