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