How to find users that never logged in

[Aviram Gabay]

Hi,

I would like to get a list of all the (active) users who never logged in to the wiki.
I found the solution with the user macro that was posted here, but when trying to apply it to list all users it takes to much time to load.

is there a way to dig this information out via a DB query? my users are stored in crowd.

Thanks!

[Nic Brough -Adaptavist- · Accepted solution]

Have a look at https://confluence.atlassian.com/display/CONFKB/How+to+identify+inactive+users+in+Confluence+by+last+login+date - it's got more than just "never used"

[Pilar]

You can achieve this with the help of a join on the two database tables cwd_user and cwd_user_attribute

select * from cwd_user_attribute where attribute_name='lastAuthenticated';

select * from cwd_user;

All users will feature in cwd_user but only users who have authenticated at least once will feature in the cwd_user_attribute table.

Hope thishelps

Pilar