/SQL/Oracle list invalid password ORA-01017

Oracle list invalid password ORA-01017

-- Detects invalid password fails (ORA-01017)
SELECT username,
       os_username,
       userhost,
       client_id,
       trunc(timestamp),
       count(*) as failed_logins
FROM dba_audit_trail
WHERE returncode = 1017
  AND --1017 is invalid username/password
    timestamp > sysdate - 30
GROUP BY username, os_username, userhost, client_id, trunc(timestamp);

Similar codes

1 vote204 views1 answer
Round function in sql oracle
SQL
1 vote171 views1 answer
Unique vs distinct sql
SQL
2 votes225 views1 answer
Mysql cannot delete or update a parent row
SQL
3 votes200 views2 answers
Sql asc
SQL
9 votes221 views6 answers
Sql insert into
SQL
0 vote190 views1 answer
Oracle sql count occurrences of value in column
SQL
1 vote210 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote269 views1 answer
Fetching data from mysqldb
SQL
6 votes218 views2 answers
Postgresql pg_dump
SQL
0 vote206 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL