cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
377
Views
5
Helpful
14
Replies

UC USer delete

mightyking
Frequent Contributor
Frequent Contributor

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?

14 Replies 14

mightyking
Frequent Contributor
Frequent Contributor

Anybody with any idea?

 

Thanks,

 

MK

mightyking
Frequent Contributor
Frequent Contributor

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

 

MK

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

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
Frequent Contributor
Frequent Contributor

Sorry, here's the info.

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?

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

Do any of the notification devices have a destination configured?

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

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.

Thanks Brandon, I really appreciate your time.

 

MK

mightyking
Frequent Contributor
Frequent Contributor

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

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

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 

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers