ld

 SELECT cu.USER_NAME, cd.DIRECTORY_NAME, 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
JOIN cwd_membership m ON cu.id = child_user_id
JOIN cwd_group g ON m.parent_id = g.id
JOIN SPACEPERMISSIONS sp ON g.group_name = sp.PERMGROUPNAME
WHERE sp.PERMTYPE='USECONFLUENCE' AND cu.active = 'T' AND cd.active = 'T'
ORDER BY SUCCESSDATE; 

ldapsearch(1): LDAP search tool - Linux man page (die.net)

Find the last login date for a user in Jira server | Jira | Atlassian Documentation

Welcome to Apache Directory Studio — Apache Directory