UC USer delete

[mightyking]

Hello All,

Trying to delete a user mailbox in Unity Connection version10.5. I used the SQL command to find the Objet ID but failed to delete the user. I also used the Bulk User Delete tool to trace the dependencies but no dependency was found. Pleas see the attached document for the steps I have gone througth.  

Is there anything else that I can do to delete the user mailbox?

[mightyking]

Anybody with any idea?

Thanks,

MK

[mightyking]

I guess I need to go ahead and open a TAC case for this.

MK

[Brandon Buffin]

Try the CUDLI tool for a view of how data within the CUC tables relate. Looks like this user account is referencing or being referenced by something in the scheduleset table.

http://www.ciscounitytools.com/Applications/CxN/CUDLI/CUDLI.html

Brandon

[mightyking]

Hi Brandon,

I was able to find an entery in the DB for 038eded1-5092-4b42-9974-5e4a14eb47bb ObjectID using the CUDLI tool . Please see the attached file.

Now, I need to find the alias for the ObjectID which is being used as a reference. Tried the follwoing query with no luck.

run cuc dbquery unitydirdb select alias from vw_user where objectid = 'e711002-6474-4a85-ae2d-1cc1ce97013d'

Could you please advise?

Thanks,

MK

[mightyking]

Sorry, here's the info.

[Brandon Buffin]

Looks like this is referencing a notification device. Can you try deleting all notification devices for this user and then try to delete the user again?

[mightyking]

The notification devices are all disabled. The delete boxes are grayed out.

Notification Devices Status Display Name Type Destination Phone System

Delete SelectedAdd New
Disabled	Pager	Pager Device
Disabled	Mobile Phone	Phone Device
Disabled	Home Phone	Phone Device
Disabled	Work Phone	Phone Device
Disabled	SMTP	SMTP Device
Disabled	HTML	HTML Device
Delete SelectedAdd New

Thanks,

MK

[Brandon Buffin]

Do any of the notification devices have a destination configured?

[mightyking]

At the begining the SMTP was enabled with an email adress but I deleted the email adress and disabled the device. There's no destination configured on any of the devices at the moment.

Notification Devices Status Display Name Type Destination Phone System

Delete SelectedAdd New
Disabled	Pager	Pager Device	Destination	Phone System
Disabled	Mobile Phone	Phone Device
Disabled	Home Phone	Phone Device
Disabled	Work Phone	Phone Device
Disabled	SMTP	SMTP Device
Disabled	HTML	HTML Device
Delete SelectedAdd New

[Brandon Buffin]

OK. Sounds like a TAC case. I feel like there is some relation to the notification device entry in the database. This will likely need to be deleted.

[mightyking]

Thanks Brandon, I really appreciate your time.

MK

[mightyking]

Brandon,

Is there an SQL query that I can run to get the alias knowing the ojectid? I tried the following but no luck:

run cuc dbquery unitydirdb select alias from vw_user where objectid = 'd9922775-cf51-47e8-8e20-c754b00948f8'

Thanks,

MK

[Anthony Holloway]

That will depend on if the objectID you have is in fact a user object.
Can you try two things:
1) Use the vw_globaluser View instead of the vw_user View
2) Use * instead of limiting the columns returned to alias

[mightyking]

Yes Brandon, you are right. The object ID wasn't a valid one. The query returns the cortect alias as long as the objectid is valid.

Thanks again,

MK