How to erase a Unity account that was registered without an extension (n/a)

[switchlegit]

An IP phone user was registered to Unity without the extension saved in his account. On the extension number field, it's written n/a instead.

This user could be found as an existing user in Unity (without the extension number); however, he could be found as a new user as well.

We tried to find his account on GSM (Global Subscriber Management) and Remove Subscriber Properties; however, the account does not exist in either one.

We need to remove his account from Unity and then register him back and so we were wondering how to remove his account since it can't be found in GSM.

Thanks in advance.

[uversave]

Hi

Have you tried to run dbwalker to see if that gets rid of it? If not we will have to look directly into sql to remove it.

Ullie

[lindborg]

dbWalker wont remove subscriber records like that... I've contemplated adding such functionality but it's risky since accidents could be pretty bad.

If there's a subscriber in the subscriber table in UnityDB that is really "stranded" with no object for it in the directory, the directory monitor _should_ remove it on the fly but there are scenarios where we can miss a delete of an object in the directory and not fire that trigger so at this point you'll need to open up the database directly and remove the record in question.

You can do this using Enterprise manager if you have it installed or you can use CUDLE (you can get the latest off www.CiscoUnityTools.com) and use the query builder to enter a command that looks like this:

"DELETE FROM Subscriber WHERE Alias='jlindborg'"

and insert the alias of the user you want to remove. All the related rows in other tables for that subscriber (call handlers, contact rules, greeting rules etc...) will be cleaned up automatically by SQL triggers.

[switchlegit]

CUDLE worked!

Thank you so much lindborg and uversave for the tips.

[switchlegit]

This time it's almost the same type of case; however, the difference is when we tried to add a new user, the data could be imported and as soon as we assign an extension number which is the same with the Unity account number, we received an error message saying that the alias already exists in Unity's database. So then we looked up for this user's alias as already existed Unity user and we could find the account even though without any extension number assigned on this person's profile, instead it's written n/a. And since that first attempt to add the user a new Unity account, we would not be able to find this user's alias as a new user, or in other words we can find this user's alias only as an already existed user in Unity, even though without having a Unity account number.

This always happens for every user who has an account on the exchange server as well as the Active Directory (using the same alias which is the employee ID number), but does not have a Unity account yet.

There is one exception, however. One user's Unity account was deleted and was going to be recreated after the deletion. However, we could not find this user's alias nor his name which means this user's profile could not be imported.

We tried to find this user's profile as an already existed Unity user, but it could not be found either.

The two cases above might not be related, but they did happen at the same time, which probably means they are related?