Jump to content

Recommended Posts

Posted

Hi,


We have noticed that a few of our users have no roles assigned (this would usually be done by api into hornbill) what is the easiest way of getting a list of people with no roles assigned or missing a certain role?

I have joined h_sys_accounts with h_sys_accounts_roles to get a list of people with roles assigned but can't see any way to see people that do not have either any roles or a defined role (i.e. 'Basic User Role' for example)

Posted

I'm not sure how you'd achieve this - you're basically asking for a list of things that don't exist, which reports are notoriously not good at.

I would do it by exporting a DISTINCT list of Users from the h_sys_accounts_roles table to compare against a list of Users from the h_sys_accounts table and the ones in the latter but not the former are those without Roles.

  • Like 1
Posted

Hi @will.good,

Here is the table setup to select users that do not have any roles associated to them. If you want to further filter by a specific role just add another filter on the role table and role name column.

Cheers


users-with-no-roles-tablesetup.PNG

  • Like 2
Posted
12 hours ago, NeilWJ said:

Hi @will.good,

Here is the table setup to select users that do not have any roles associated to them. If you want to further filter by a specific role just add another filter on the role table and role name column.

Cheers


users-with-no-roles-tablesetup.PNG

Brilliant, thank you

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...