How to pull reports on inactive users with roles and group

[AP30]

Hello,

I am looking to pull a report on inactive users that still have roles and groups assigned to them. How do i query this report? Please help with a script if it is required.

Thank you.

[Dubz · Accepted solution]

report on the sys_user_grmember table and filter for where user.active is true.

Best practice is to assign roles to groups and have users inherit their roles that way. If you've assigned roles directly to users you'll need to report on the sys_user_has_role table as well.

[AP30]

Okay trying that now. Will let you know. 

How about using a Sys ID to pull the report?

Thanks

[AP30]

This is not pulling the correct report of inactive users with roles and groups.

[Dubz]

sorry, meant user.active = false. You know you can use your own intuition as well as getting input from people on the community you know 🙂