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...") |
|||
Line 1: | Line 1: | ||
+ | |||
+ | |||
+ | 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' ; |
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' ;
Advertising: