0 Replies Latest reply on Mar 9, 2016 4:39 PM by rvs_narayana

    Looking for query to report user activity on discussions




      We currently use Jive version 7.0,2 and would like to track discussion thread activity by users.


      We are looking for a custom query that can be used on Jive Analytics database

      to report following information for each message posted by a user  :


      • Container(Community) Name
      • Object ID
      • Object Type
      • Object Name
      • Whether message corresponds to a new thread/discussion or reply to an existing discussion thread
      • Whether the message was marked as helpful
      • Username
      • Any unique User ID stored by Jive
      • User full name
      • Message Creation Date



      thanks in advance