Query unregistered Active Directory user in ADSelfService Plus DB (MySQL)

Query unregistered Active Directory user in ADSelfService Plus DB (MySQL)

Hey guys,

I want to look for the unregistered Active Directory users in our ADSelfService Plus DB (MySQL). I know that it is possible to create a report, which contains these users, by using the GUI, but I would like to query them by using mysql. My problem is, that I fail to construct the appropriate select statement.

I would be pleased, if some could help me to create this sql statement.

best regards
witderr

Currently we are using ManageEngine ADSelfService Plus 4.5


              New to ADManager Plus?

                New to ADSelfService Plus?