Jive Databases in pgAdmin

Version 16

    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