• Active users' data for a month

    Hello,   I am new to jive analytics and is trying to generate a report with details of users who accessed our site in the month of January (active users). I would like to confirm if the modification timestamp (m...
    last modified by vishnu_nair04
  • How to get a list of user_id's followed by each user_id in either the Analytics or Application database?

    What's the best way to get a list of user_id's followed by each user_id in either the Analytics or Application database?   I know that a follow is activity_type 270 and based on that I can pull fields like  ...
    Jason Miller
    last modified by Jason Miller
  • Number of Content Follows, Content Shares, Friend requests

    Can someone guide me on how to get the following metrics from jive databases- 1. Number of Followers for Content (threads, questions, blogs etc.) 2. Number of Shares for Content It would be good to have the numbers...
    Donna 840
    last modified by Donna 840
  • Does anybody know how to get analytics for the Skills and Expertise field?

    I haven't been able to find a way to get any data around usage of the Skills & Expertise field in the profiles (where users can tag themselves and others with skills, and create endorsements for others like in Lin...
    last modified by cservilio
  • Search Results Count

    Hello Everyone,   We have integrated Jive with SiteCatalyst, and are currently capturing internal search terms in a custom evar (search internal to our community). We would like to also capture a count of the nu...
    Krystal Solcich
    last modified by Krystal Solcich
  • What is the implementation process for connecting Adobe SiteCatalyst with Jive

    We are looking at reviewing our options and would like to better understand the steps involved with implementing SiteCatalyst with Jive.  Any feedback from others is appreciated.   Thanks,
    last modified by ac255026
  • Measuring customers helping other customers

    Hi-   We have a support community on SBS and one of the things we are really interesting in measuring is the percentage of customer questions that get answered by other customers rather than by our own employees...
    last modified by arose
  • Canned "Cohort Analysis" Report?

    Reading Eric Ries article on "Vanity Metrics vs. Actionable Metrics" got me inspired to create a "Cohort Analysis" report for our installation of Jive.   The idea is to group your users according to when they jo...
    Neil Mussett
    last modified by Neil Mussett
  • SocialID Data?

    Do you know if you can extract the social ID for anyone that registered an account in Jive using a social sign on authentication from either the analytics or App DB's?
    Jason Miller
    last modified by Jason Miller
  • Mobile user flag?

    Hi,   I heard there's a flag for mobile users somewhere in Jive(?). I don't see it offhand though and when I search the information schema on column names like '%mobile%' nothing comes up.   Thanks!
    Jason Miller
    last modified by Jason Miller
  • Trying to locate the table where the status for invites is documented

    In the Jiveinvite table, we can see who has been invited to a group - there is a status indicator with values 1-3. I can't see a table where these status values are dfined. Anyone have anything on this?   Also,...
    Andy Wooler
    last modified by Andy Wooler
  • Jive Cloud Admin Analytics Issue

    Lately whenever I'm trying to restore .dmp files from JCA to our reporting server's PostgreSQL pgAdmin III tool, the tables won't restore to my database and it will instead time out and freeze the program. When I go t...
    last modified by ernichols
  • Jive Ban Flag Locations

    My Jive community had a bit of spam and thus we're banning people. Someone asked me about the traceability of bans in the Application and Analytics DB's.   I see the jiveban table, so for the most part I think t...
    Jason Miller
    last modified by Jason Miller
  • Query for Activity on Specific piece of content?

    Hi, I'm wondering if anyone has a query that will give me the activity for a specific piece of content or object ID?  I can't seem to find anything that will narrow down the activity to just one document.  ...
    Erin Clements
    last modified by Erin Clements
  • Has anyone been able to query ideas/discussions?

    Ultimately, what I want do is be able to export a list of comments or users who have commented in a thread or an idea. Any good SQL queries that would help with this? Thanks in advance!!
    alice yang
    last modified by alice yang
  • 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...
    last modified by ReeceO
  • Distinguishing Jive User Profile Fields

    I'm trying to filter users based on their profiles. I see that profiles are stored in jivedw_userprofile and that the names of field_id's are given in jivedw_profilefield. I noticed that there are several with the sam...
    Jason Miller
    last modified by Jason Miller
  • How do I disable the viewers panel for Impact Metrics?

    If you want to see the total unique viewers but not the names of viewers...
    Josh Richau
    last modified by Josh Richau
  • User v. Admin Activities

    Can anyone provide clarity on which activities in Jive can be performed only by admin's (i.e. MODIFY) instead of users and admin? Is this in the documentation? If so, I'm not seeing it.   Thanks in advance!
    Jason Miller
    last modified by Jason Miller
  • Dates in a user and userprofile table

    Hi,   Can anyone explain to me, what does the different dates fields exatly mean in the user and userprofile table?   In the user table: initlogin_ts| creation_ts| modification_ts   In the userpr...
    last modified by nsandor