How to find out users who have not logged in for last 30 days in an instance
Release or Environment
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