How to check the progress of evaluate user policy via SQL Query?

Question

Is there a query to get all the users that the Evaluate User Policies job is processing or needs to process?

Answer 1

Using following query if it does't produce output, nothing wrong in the query. That simply means there are no policy evaluation under progress or required.

 select USR.USR_LOGIN, USR.USR_KEY, USR.USR_STATUS, USER_PROVISIONING_ATTRS.POLICY_EVAL_IN_PROGRESS, USER_PROVISIONING_ATTRS.POLICY_EVAL_NEEDED from user_provisioning_attrs
    left outer join usr on USER_PROVISIONING_ATTRS.USR_KEY = USR.USR_KEY
    where POLICY_EVAL_IN_PROGRESS = 1 or POLICY_EVAL_NEEDED = 1
    order by usr_login desc