Review failed logins

From wikieduonline
Revision as of 11:04, 14 June 2020 by Welcome (talk | contribs)
Jump to navigation Jump to search


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' ;

Advertising: