09-29-2014 02:01 PM
Hi,
Is there a documented way to Bulk Delete End users in CUCM using the AXL api? I have used the ExecuteSQLUpdate (https://developer.cisco.com/media/axl-schema-10-5/Files//AXLSoap_executeSQLUpdate.html#Link3FF) command to do this using the following query
DELETE FROM endUser WHERE fkucserviceprofile IN (SELECT pkid from ucserviceprofile WHERE name='{0}')
where "name" is the UC Service Profile that I want to delete the users for.
Now what I am wondering is
1) Does this delete all the user related content? (basically is it the same as calling the RemoveUser https://developer.cisco.com/media/axl-schema-10-5/Files//AXLSoap_removeUser.html#LinkC0F method in a loop)
2) Is there a recommended way of Bulk Deleting users?
Thanks
09-30-2014 02:40 PM
According to the data dictionary document, there are active rules that are triggered by the delete operation. Here's the data dictionary for 10.5: https://developer.cisco.com/media/UCM10.5DataDictionary/UCM10.5DataDictionary.htm
There are conditions where the related data wouildn't be deleted. It explains in the document linked above, under endUser.
SQL is the shortest method for a bulk delete. It shouldn't be hard to write code that deletes by UC Service Profile and removeUser, though. What language or method do you use to execute AXL requests?
10-01-2014 08:16 AM
Hey Nicholas,
Thanks for your reply. I am using SQL currently to bulk delete, I was wondering if this is a proper solution and from your comment it seems like it is correct given the conditions mentioned in the link you passed are met. I am using the ExecuteSQLUpdate method in the AXL API and calling it using C#. The query I am using is pasted in my original post.
Thanks a lot.
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