Query to count failed log in attempts

— to count failed log in attempts:

SELECT name, lcount FROM user$ WHERE lcount <> 0;