Hello,

This may be old news for some but I still see some people struggling with this type of report.

Finding users with no roles

I thought I'd of got away with it for a while until the requirement landed on my lap... After trawling through the community I did see a lot of creative ways to achieve this however, after some research I found a script which I'm surprised isn't an out of the box report (Might be now though)

Use script: javascript:getRoledUsers();

To put this in context,

Create a report on the sys_user table

And the conditions

The above is to find active users with no roles however you could adapt it to find inactive users with roles if you're doing audits or you could use combinations depending on your requirements it could be really helpful to you.

Labels:

• Multiple Versions
• Performance Analytics
• Reporting