How to find out users who have not logged in for last 30 days in an instance

ALL

Log into the instance

• Go to Users table (sys_user.list)
• In the filter condition, set the conditions as active = true and the last login before last 30 days
• Run the filter and you will get the desired result.
• Depending upon the requirement for e.g. to find out for the last 90 days, you can change the condition as last login before last 90 days