will.good Posted March 23 Share Posted March 23 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) Link to comment Share on other sites More sharing options...
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
Already have an account? Sign in here.Sign In Now