to follow, share, and participate in this socialgroup. Not a member? Join Now!
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... 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... 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... 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... 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 ... select u.username, u.lastname, u.firstname, u.email
from jivedw_user u
This is another handy query for if you want to do something not-social like send a mail to all ... 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... 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