3 Replies Latest reply on Jul 1, 2020 7:19 AM by pkethireddy1717

    Need to know relevant Jive database table information to fetch the reports

    Intermediate

      Hi,

       

      Can anyone help me in understanding how below reports can be fetched from Jive database and Relevant db tables to fetch below data?

       

      "Number of communities; work groups; new thread Discussions; Blogs being created on a month by month basis  (since Jan 2014)"

       

      I have found the details for (Number of communities; work groups; Blogs) like below:

       

      select *,to_timestamp(creationdate/1000) from jivecommunity where status =1

      select * from jiveblogpost where status =1

      select * from jivesgroup where status =1

       

      But i am struggling with "new thread Discussions". Where i can find it?