You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
From your question is not clear what do you mean by "their users", but I will consider you are talking about what users or groups have permissions on those plan/projects.
This query will give you the build projects/plans:
BUILD_TYPE='CHAIN' ORDER BY FULL_KEY
This one will give you the deployment projects/environments:
The users and groups with permissions for them you can get from this page:
I hope that will allow you to retrieve the information you need from the Bamboo DB.