AlexOnTheHill Posted March 20 Share Posted March 20 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 More sharing options...
Steve Giller Posted March 24 Share Posted March 24 You might be able to adapt Neil's solution to a similar question for this. Link to comment Share on other sites More sharing options...
AlexOnTheHill Posted March 28 Author Share Posted March 28 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 More sharing options...
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