-
Re: To find space and sub-space admins
Ryan Rutan May 25, 2017 9:29 PM (in response to kranthi.chiluveru)1 person found this helpfulConstructing that query will be difficult, but this page should help with the high-level structure.
SchemaSpy - Table dba800.public.jiveentitlement
Some key points to focus in a bit:
- Spaces are ObjectType[14], if you hardcode that as an object-type, you can bind results directly to the jivecommunity table ... all Object IDs from jiveCommunity will match Object IDs in other tables if the ObjectType locked to 14.
- Other tables you'll need : jiveCommunity, jiveEntitlement*, jiveperm*, jiveUser, jiveGroup, jiveGroupUser
As for the API, it is straight forward to check the Applied Entitlements using:
All you have to do is resolve the SecurityGroups and User references. It's a bit more traversing API calls, but it will definitely be a lot easier IMO.
Hope that helps.
-
Re: To find space and sub-space admins
jpadilla Jul 19, 2017 12:37 PM (in response to Ryan Rutan)I'm getting more security groups than i probably want. In the Jive UI for the space, I have a section labeled "SPACE ADMINISTRATORS:" with 10 people. When I query for unique appliedEntitlements for the space, I get 5 groups with thousands of users. I see 2 of those groups is what I need but dont see what logic can be applied to exclude the other 3 groups. I don't see how to filter for only "Administer" level permission.