user LDAP audit

[moiras_mom]

Running unity connection 8.5 integrated w/ cucm 8.5 and ldap. I have over 2000 users, and some have been manually made, others through LDAP. How can I run an audit to tell which accounts have been made manually, and which ones have been made via LDAP and CUCM? I've tried running the unity reports, BAT user export files, and the user dump tool from ciscounitytools.com but I can't find the flag in those fields. I found one user with LDAP integration and one without, did a stare and compare using all available flags and nothing was different.

Any assistance would be greatly appreciated....

Message was edited by: Elizabeth Cope

[testeven · Accepted solution]

Hi,

You can try running these queries via CLI:

To find local users:

run cuc dbquery unitydirdb select firstname, lastname, displayname from tbl_user where ldapccmpkid is NULL

To find LDAP users:

run cuc dbquery unitydirdb select firstname, lastname, displayname from tbl_user where ldapccmpkid is not NULL

Hoe this helps!

Regards, 

Tere. 

If you find this post helpful, please rate!

[moiras_mom]

Perfect. Thank you. Worked like a charm