Difference between revisions of "Review failed logins"

From wikieduonline
Jump to navigation Jump to search
 
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
 
  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

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: