While working with a client recently, I was asked to create a new JTAPI application user and associate a little over 600 users to it. I couldn’t find a clean way to do this with BAT, so I decided to use SQL.
Follow these easy steps
- Learn the associations between the applicable fields. We needed to get a device linked to an application user in my case. CUCM Data Dictionary
- run some select statements to verify everything looks how you expect. I also make changes in the GUI, then check my selects again to ensure I know how CUCM expects data to look.
- Make your change
- Verify