Difference between revisions of "Review failed logins"
Jump to navigation
Jump to search
(Created page with " 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...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | 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' ; | 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 == | ||
| + | * {{Confluence}} | ||
| + | |||
| + | |||
| + | [[Category:Confluence]] | ||
Latest revision as of 11:04, 14 June 2020
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]
- Confluence, Install Confluence (PostgreSQL), Integrate Jira and Confluence, Confluence release notes, Confluence logs (catalina.out),
systemctl start confluence, systemctl restart confluence, systemctl status confluence, Confluence versions, Confluence: Restore Passwords To Recover Admin User Rights, OGNL
Advertising:
