Review failed logins

From wikieduonline
Jump to navigation Jump to search

https://confluence.atlassian.com/confkb/how-to-get-a-list-of-users-that-had-a-failed-login-895093845.html#:~:text=TOTALFAILED%20!%3D,successfully%20logged%20in%20to%20Confluence.

sudo -u postgres psql confluence
select  a.CURFAILED as Current_failed_logins, a.TOTALFAILED as Total_Failed_logins, a.SUCCESSDATE, a.FAILEDDATE, b.username from logininfo a join user_mapping b on a.username = b.user_key where a.CURFAILED != '0' or a.TOTALFAILED != '0' ;


See also[edit]

Advertising: