This content has been marked as final. Show 1 reply
What version are you on? Anything 6+ moved the follow stuff into streams tracked via the EAE DB.
Here is the query I use for spaces in 6.03
select Streamid, jivestreamassociation.userid, jivestreamassociation.objectid, jivestreamassociation.objecttype, jivestreamassociation.receiveemails, jivestreamconfiguration.name, to_timestamp(jivestreamconfiguration.createddate/1000) as Creationdate, to_timestamp(jivestreamconfiguration.modifieddate/1000) as Modificationdate From jivestreamassociation join jivestreamconfiguration ON (jivestreamconfiguration.id = jivestreamassociation.streamid) Where jivestreamassociation.objecttype= 14 -- Community (Space object type) and jivestreamassociation.objectid= 3418 -- Community (Space) ID order by createddate desc