I use this query to keep track of groups:
select jgroup.groupid, jgroup.name, jgroup.displayname,jgroup.userid as "AdminID", juser.username as "AdminNT", to_timestamp(jgroup.creationdate/1000) as "creationdate",to_timestamp(jgroup.modificationdate/1000) as "modificationdate", jgroup.grouptype,jgprop.name, replace (jgprop.name, 'contentType.','')as "ContentType", jgprop.propvalue
from jivesgroup jgroup
join jiveuser juser on juser.userid = jgroup.userid
join jivesgroupprop jgprop on jgprop.groupid = jgroup.groupid
where jgroup.name is not null and jgprop.propvalue = 'true'
order by jgroup.name asc
I use this one for spaces it doesn’t include the creator or admin though:
select communityid, name, lft,rgt,to_timestamp(creationdate/1000) as "createdate"
order by communityid desc
Thanks Caton, sorry I didn't see this last week. Appreciate it.
What do you do then, when you want to reach the space admins? Maybe i'm missing something out of the UI that I could be using?
Great question, AFAIK there isn't anywhere in the UI or the system/analytics DB's that stores a 'space admin' value in version 4.5-6.1. Which version are you using?