A few tips to get things out of the core application system database and the ActivityEngine database. Things that are not available in the Analytics database
For pgAdmin installation guide, follow pages 2-8 here Installing Postgres for Jive DWH Implementation
Some SQL queries gathered from discussions in the Jive community include...
- User points
- Terms & Conditions: See which version users have accepted
- Space permissions: All Spaces and the users who are set as the admins/moderators for each
- Group Admins: All Groups and the users who are set as admins for each
- Email notifications: Find out who is receiving email notifications for a place