Saturday, August 16, 2008

Find Unsuccessful Logins in the last 24 hours

select fu.user_name||' '||to_char(ful.attempt_time,'DD-MON-YYYY:HH24:MI')||' '||ful.login_name||' '||ful.terminal_id
from fnd_user fu, FND_UNSUCCESSFUL_LOGINS ful
where ful.user_id = fu.user_id (+)
and ful.attempt_time > sysdate - 1;