06-07-2012 02:14 AM - edited 03-16-2019 11:33 AM
In our current setup we don't sync call manager with LDAP so the various CTI services we are running have used end user accounts (this has been upgraded from 3 > 4 > 6 > 8 over the years)
We now have a need to sync our cluster with LDAP for users so I need to move the CTI accounts over to be application users to ensure that the device associations also follow.
Is there a way to easy migrate from one to the other?
Thanks
Solved! Go to Solution.
06-07-2012 02:21 AM
Hi
Not really - they're seperate types of users in seperate DB tables. You might be able to use AXL to do a getUser, modify the XML object and resubmit it as a createAppUser.. or do some DB work. If it's only a handful of users you'll probably be best to do it manually.
Regards
Aaron
06-07-2012 02:21 AM
Hi
Not really - they're seperate types of users in seperate DB tables. You might be able to use AXL to do a getUser, modify the XML object and resubmit it as a createAppUser.. or do some DB work. If it's only a handful of users you'll probably be best to do it manually.
Regards
Aaron
06-07-2012 02:53 AM
Be aware that when you sync your users it will wipe all existing End Users (and stop Extn Mobility working).
Rich
06-07-2012 03:00 AM
Thanks, I was aware of the wiping of hte end users, that's why I need to make sure the CTI accounts don't get deleted.
making the accounts manually sounds like the best option, it's the 2,000 device associations I'm not looking forward to!
06-07-2012 03:08 AM
Hi
If it's a matter of 'associate everything' then it's not too painful. Just set 'results per page' to as high as poss and hammer away.
If you have specific devices to associate then it might be worth spending some time with the AxlSqlToolkit. You can grab the end user device associations for a user like so:
select e.userid,eud.* from enduserdevicemap eud join enduser e on eud.fkenduser = e.pkid where userid = 'enduserid'
You could then take the data from that and use Excel to generate a bunch of insert statements that you can inject using AxlSqlToolkit...
Aaron
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide