users-with-mfa-and-last-login-date.sql

select id, name, email, user_type, is_mfa_activated,
lifecycle_state,
case COALESCE(inactive_status,-1)
        when -1 then 'N/A'
        when 0  then 'SUSPENDED'
        when 1  then 'DISABLED'
        when 2  then 'BLOCKED'
end inactive_status, last_successful_login_time
from oci_identity_user
order by last_successful_login_time desc