AnsweredAssumed Answered

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

Question asked by gauravg on Jul 16, 2014
Latest reply on Jul 1, 2020 by pkethireddy1717

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?

Outcomes