AFAIK only place this information is stored is the EAE DB. I haven’t done much poking around in that DB though.
P.S. #PostgreRocks! at least it’s better than Oracle…
Thanks again, Caton
It's really our network and the cumbersome process of downloading our large DB files and then opening in PostGres that's a pill. The client itself is good, definitely agree on the Oracle comment!
Just in case it helps someone, I *think* this is the SQL query for this against the EAE DB. I believe this specific query only shows email notifications for spaces (not groups).
to_timestamp(jivestreamconfiguration.createddate/1000) as Creationdate,
to_timestamp(jivestreamconfiguration.modifieddate/1000) as Modificationdate
join jivestreamconfiguration ON (jivestreamconfiguration.id = jivestreamassociation.streamid)
Where jivestreamassociation.objecttype=14 AND jivestreamassociation.receiveemails=1
order by createddate desc