In which table failed user login attempts will be there?
Please mentioned here the exact query.
Goto SUIM-> User-> With Unsuccessfull Logons
u didn't tell the exactly status. usr02 table stores clients and users and passwords information. goto database level check the status of users
You can monitor unsuccessful logon attempts with basis reports. These reports records the number of incorrect logon attempts by a user and user locks.
However, you can use records from table USR02 if you are specifically looking for a table.
LOCNT - Counter for incorrect logons per user
UFLAG - User Lock Status
Login to follow, like, comment, share and bookmark content.