You really mean a complete audit log with all user access to all areas of Jive and content.
- All pages visited in a session
- All documents viewed
- All other actions (upload/download)
- All user actions for a session for audit purposes (so it needs to be tied to their user id)
Much of that information is potentially captured in the Jive Advanced Analytics database if you've enabled it. Extracting the data for meaningful analysis may require some fancy Oracle Business Objects queries...
Yet another reason to get off MySQL -- who the @%@^!% stuck us with that DB when I recommended Oracle/PostgreSQL. That's right our hosting partner.