will.good Posted March 23, 2023 Posted March 23, 2023 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 Posted March 23, 2023 Posted March 23, 2023 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. 1
NeilWJ Posted March 23, 2023 Posted March 23, 2023 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 2
will.good Posted March 24, 2023 Author Posted March 24, 2023 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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now