User login information

[Hsu Yao Chang]

Dear Partners, 

Would it be possible to find the information of each account login counts ? Thank you. 

Best Regards

[waynewong]

Hi there,

I am sorry that Confluence does not store successful login count in the database.

For more info, you can refer to this document here :

https://docs.atlassian.com/atlassian-confluence/latest/com/atlassian/confluence/security/persistence/dao/hibernate/UserLoginInfo.html

Hope this will help.

Regards,

Wayne Wong

[Hsu Yao Chang]

Thank you for your kindly reply.

But it only get the information of user login failed count, not success count. 

login information.jpg

Best Regards, Anderson Hsu

[waynewong]

Hi there,

Kindly run below query to see the current failed login attempt of the USERNAME you want to reset:

SELECT u.user_name, a.attribute_name, a.attribute_value, a.attribute_lower_value

FROM cwd_user_attribute a inner join cwd_user u on u.id = a.user_id

WHERE a.attribute_name = 'invalidPasswordAttempts'

AND u.user_name = 'USERNAME';

Reference: https://confluence.atlassian.com/display/CONFKB/How+to+reset+failed+login+count+from+Confluence+Database

Hope this will help.

Regards,

Wayne Wong