Finding users with no roles

[Andrew_TND]

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.

[Andrew_TND]

I'm glad this was helpful its always the way its something simple. 

[Sujit4]

Hi,

Yes its working. I have associated with Group, but in report i could not able to find to add Group name. Need suggestions.

[Randall King]

All that this seems to do is return a list of all users. It's not filtering out the ones that have a role.

[Eeson]

Finding active users without a role, this has worked for me over the years...