[CUCM] AXL API - Bulk Delete End Users

[hsheikh01]

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

[npetrele]

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?

[hsheikh01]

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.