I am trying to create reporting around discussions.
In order to supplement analytic data on message, I am using the viewcount and answer operational tables. The answer table tells me when a message answered or helps answer the thread. I can not seem to find where you store/how I know that a thread has been marked "assumed answered". I have looked at the thread and moderation tables - but am not getting close.
fyi that I am rolling this information to a space by time level (counts) - using the detail to get these counts.
Check the jivequestion table - resolutionDate and resolutionState columns