Oracle detect invalid password

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

0 vote299 views2 answers
Replace null with 0 in sql
SQL
0 vote277 views1 answer
Oracle procedure teamplate
SQL
0 vote345 views1 answer
Delete ids between sql
SQL
0 vote301 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote291 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote288 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote254 views1 answer
T sql return on letters only
SQL
25 votes350 views5 answers
Mysql replace text
SQL
0 vote366 views1 answer
Sqlite display data in separated columns
SQL
13 votes298 views2 answers
Oracle select into and inner join
SQL