Export Confluence Active & Inactive users list from POSTGRES database

[Mahesh Kallepalli]

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;