We have a Open DB access of Blackboard Learn.
We would like to know the time spent by the user in the system through Open DB. Can anyone please suggest how to get this.
A good starting point for investigation: activity accumulator | blackboardcodemonkey
I would add the use cases for tracking users to https://community.blackboard.com/community/developers/rest/pages/rest-api-ideas because as we move forward, Product Development is discouraging database access.
activity_accumulator can be a monster and if you don´t use the Stats Schema version you are limited to the last 6 months.
You can use some preprocessed materialized views populated with the ETL nigth process with interesting information such as :
Retrieving data ...