Frank Reay Posted December 18, 2020 Share Posted December 18, 2020 We have issues with users who do not have an assigned site, not in any Company or not in any Department. This has been caused by issues with the interface from our HR system. Is there any way I can find Users who do not have any value in Site, are not assigned to a Department/Company etc. For example can I extract a list of users into a csv with the relevant attributes so I can see who has the missing values? Can I also download a list of all Departments in HB? We have pages of them in HB and a csv list would also help in understanding our problems. Link to comment Share on other sites More sharing options...
Victor Posted December 18, 2020 Share Posted December 18, 2020 @Frank Reay build reports and set the report output to CSV. The table you need for users id h_sys_accounts. The companies (and departments which are technically companies) are stored in h_sys_groups table. 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