• Jive Databases in pgAdmin

    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 her...
    ReeceO
    last modified by ReeceO
  • content viewed in the last month by logged in users

    Here is a query I built that displays all content that was viewed in the last month.  This needs to be run against the analytics database.  It includes the time stamp, who the user was, what content was view...
    mnevill
    last modified by mnevill
  • Jive Analytics and Reporting Solutions

    Let's use this document to crowd-source a reference of available analytics and reporting solutions for Jive.  Please add to this based on your research and experience!   Name Vendor Jive-aware? Strengths Wea...
    bchamberlain
    last modified by bchamberlain
  • content viewed by logged in users with a specific e-mail domain

    Here is a query that displays all content that was viewed by anyone with a specified e-mail address domain (@company123.com) while they were logged in. This needs to be run against the analytics database.  It inc...
    mnevill
    last modified by mnevill
  • Installing Postgres for Jive DWH Implementation

    i put together this document which describes how a user can download the PostgreSQL database and ODBC driver, import the analytics file (*.dmp) from the Jive Cloud, and connect an ODBC driver to it. From here, a user ...
    bchamberlain
    last modified by bchamberlain
  • email addresses of enabled members

    select u.username, u.lastname, u.firstname, u.email  from jivedw_user u  where userenabled=1;    This is another handy query for if you want to do something not-social like send a mail to all ...
    jemjanik
    last modified by jemjanik
  • Jive Reporting Requirements

    We've been brain-storming metrics and reporting we'd love to get out of our Jive deployment, and this is what we came up with.  Our general functionality wishes include: Jive-aware Integrated within Jive itself...
    jmaaks
    last modified by jmaaks
  • Queries for Dashboard Reports

    This document captures the SQL behind the components of the admin dashbaord. (Thanks > MarkW).Cumulative Membership Trend & Cumulative Content TrendFor cumulative membership we run this query:   SELECT ...
    karlcyr
    last modified by karlcyr
  • Jive SBS data model.pdf

    df
    milind2
    last modified by milind2
  • Analytics Excel example

    corygagliardi
    last modified by corygagliardi
  • Example Analytics Queries

    corygagliardi
    last modified by corygagliardi
  • Jive SBS data model

    corygagliardi
    last modified by corygagliardi
  • AnalyticsDatabaseSchema.pdf

    corygagliardi
    last modified by corygagliardi