CUCM 12.5 SQL to remove UDP from End User

[FPENTEADO]

Hi

Is there a possibility by SQL make a query to remove UDP from specific user, or from user remove UDP that are linked with him?

Kind Regards

[Nithin Eluvathingal]

Do this using  bulk. Export remove the UDP profile and import the enduser. 

With SQL it's doable, but need to make custom query. And if the list of users are huge  we need a python script to loop the query. 

[FPENTEADO]

I tried do it  but doesn´t work. It´s not possible do it by bulk.

The Bulk Administration Tool (BAT) cannot be used to disassociate devices that are already associated to an end user.

https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/bat/12_0_1/cucm_b_bulk-administration-guide-1201/cucm_b_bulk-administration-guide-1201_chapter_010010.html

Bulk Administration Guide for Cisco Unified Communications Manager, Release 12.0(1) - User Updates [Cisco Unified Communications Manager Version 12.0]

Bulk Administration Guide for Cisco Unified Communications Manager, Release 12.0(1) -User Updates

[Nithin Eluvathingal]

When I said bulk, I didn't mean the option which you are referring. what I mean is  Export the end users, make the change and import the endusers again with override  config.