Hello Team,
I'm executing below DB query to get active & In active user list. I'm getting duplicate results and problem with last login date. Could anyone guide me to the proper query.
SELECT cu.user_name,
cd.directory_name,
cu.display_name,
cu.email_address,
cu.active,
li.successdate
FROM logininfo li
JOIN user_mapping um ON um.user_key = li.username
JOIN cwd_user cu ON um.username = cu.user_name
JOIN cwd_directory cd ON cu.directory_id = cd.id
ORDER BY successdate;
