Unity Connection SQL query for "inactive LDAP users"

[Paul McGurn]

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

[Sreekanth Narayanan]

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

[Paul McGurn]

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.

[Louis-Philippe Descamps]

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