Jump to content

Reporting on users who do not have a division in their organisation


Recommended Posts

I am looking into a problem where our user sync has been unable to map users organisation details fully.

I can see the reason is because a number of new divisions have been created internally which do not yet exist within Hornbill.

In order to identify each of these missing divisions it would be really useful if I could run a report that shows each user who is missing theirs.

Our structure is Company - Department - Division

Affected users are just showing Company - Department

I've been trying a few things but not having much success.

Any help is appreciated.

Link to comment
Share on other sites

I've had a go at modifying this one but wasn't successful.

I don't think I'd have any difficulty reporting on users without any roles as roles are a field I can point to directly.

The problem I have is that I want to say "show me the users who don't have an organisation type 4"

Perhaps this is better submitted as a database direct query?

Link to comment
Share on other sites

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...