For resource manageent we have created an OBS to reflect the differnet areas of the business. All resources are assigned to a part of the OBS.
We have then assigned OBS level access rights onto the group that is assigned to our Prject Managers to control what resources can be Soft Boked by them and those that can be Hard Booked.
Due to the limited view within the Groups view of OBS Rights it is difficult to maintain this going forward as the only level visible to the bottom level of the OBS.
I am trying to find a way to extract this infortmation via a query but have found very little information on the tables that store this information.
Has anyone else encountered this issue or have knowledge of what tables/fields that can be used to extract this information?