Cisco CUCM mass delete via SQL

Jeremy Worden
automate builders
Published in
1 min readFeb 26, 2020

Recently needed a way to delete a lot of end users from Call Manager. Normally you’d let the garbage collector do it over the course of a couple of days, however we were at the max (160,000) users and I wanted a clean slate before proceeding. Solution I came up with was deleting a thousand or so at a time via SQL with the following command:

run sql delete from enduser where pkid in (select * from (select first 1000 pkid from enduser))

--

--