Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Forward Unregistered Internal with sql for all deviceprofile

Dear Expert,

I have a Call Manager 4.2. i creat users and userDevice profile.

Now i need a forward on field "Forward Unregistered Internal" and "Forward Unregistered External" on all userDeviceProfile.

Althouth, the forward is the for the same number of line but with another Calling search space.

if it s possible to give me a sql code to apply on the SQL Query Analyser of callmanager to do it for all deviceProfile.

Thank you in advance.

2 REPLIES

Re: Forward Unregistered Internal with sql for all deviceprofile

direct DB updates are not supported, but you can use the AXL SOAP API to update the Lines on the UDP's

Re: Forward Unregistered Internal with sql for all deviceprofile

Supported or not, it works like charm and I've done it a couple of times for things that bulk admin cannot handle.

The query itself is highly environment dependant so it makes little sense to post whatever was used in the past. Get a copy of the database diagram, and look for the CFUR columns.. then look up the proper CSS' uuid, and form the query accordingly.

For this kind of scenario, AXL may be the proper way but it's also going to take an unreasonable amount of time both in terms of development and execution time (unless you have CCM 5 where AXL is the only way but you can do sql updates via AXL there).

339
Views
0
Helpful
2
Replies