Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

Bronze

Unity Connection SQL query for "inactive LDAP users"

Hi,

I'm trying to find an easier way to view inactive LDAP users in Unity besides viewing each user's page to see the "inactive" message.  Is there a SQL query that'll point these out?

 

Unsing Unity 9.1 SU1

3 REPLIES
Cisco Employee

Hi Paul,You can use the data

Hi Paul,

You can use the data dictionary to achieve this. I am not a CUC guy, but on CUCM, there is a table called "enduser" that will have the required details. I'm guessing it should be the same on the CUC as well.

try

admin:run sql select * from enduser where status=0

Bronze

I can't find a Unity-specific

I can't find a Unity-specific data dictionary doc, and that query isn't quite right.  The users in Unity are not the same design as CUCM, as you have the concept of "local", "LDAP-synched", and "CUCM-synched".  I'm trying to find users that were LDAP-synched that are no longer active.

Hi,

Hi,

run sql SELECT * from enduser where status = '2'

if using putty, enable the logs to a file so you can see the table nicely

183
Views
0
Helpful
3
Replies
CreatePlease to create content