2 Replies Latest reply on Jul 19, 2017 12:37 PM by jpadilla

To find space and sub-space admins

kranthi.chiluveru May 25, 2017 9:21 AM

Hi All,

I am trying to get list of spaces, sub-spaces and their admins. I have come across community discussions but did not see anyone had much success.

Just want to find out If anyone had achieved this using SQL query or API.

Appreciate If you could provide some inputs on this.

Thanks

Kranthi

Re: To find space and sub-space admins

Ryan Rutan May 25, 2017 9:29 PM (in response to kranthi.chiluveru)
Constructing 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:
https://developers.jivesoftware.com/api/v3/cloud/rest/PlaceService.html#getAppliedEntitlements(String, int, int, String)

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.
1 person found this helpful
Like (0)

Actions
- 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.
  
  Like (0)
  
  Actions

Go to original post