Dear Partners,
Would it be possible to find the information of each account login counts ? Thank you.
Best Regards
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
<a href="http://u.id" rel="nofollow noopener noreferrer">u.id</a> = 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
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
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
It looks like you're new here. Sign in or register to get started.
