Users With Missing Roles Report

[will.good]

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)

[Steve Giller]

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.

[NeilWJ]

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

[will.good]

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

Brilliant, thank you