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?