Page tree
Skip to end of metadata
Go to start of metadata

The Totara Log Data Source is a curated selection of LMS data that enables you to create Reports on the last action and access record in the log of your Totara LMS users. Relevant items in this Data Source include the Log Entry ID, IP Address, Real User ID, and the log Context data.

The Totara Log Data Source is located in the Public folder in the Zoola™ Repository. To locate the Data Source in either the Repository or the Data Chooser (when selecting a Data Source to create an Ad Hoc View), navigate to Public > Totara > Data Sources.

This Data Source contains LMS data organized to report on the log information of users in your Totara LMS. “Log information” consists of fields and measures that track the most recent session of your users, displaying records of their IP, actions, log times, and modules. Using  fields and measures from the two sets included in this Data Source, you can easily build out Reports and Views to track the access record of your Totara LMS users. 

All included sets are comprised of selections from the tables listed in the Totara table, located at the end of the right-hand column.

Specifically, the Totara Log Data Source is comprised of the following sets:

  • User: Items in the User set provide user identification information, such as user ID's, names, locations, and other LMS profile-related data.

  • Log: Items in the Log set provide session access records, such as log time, IP, and URL information.

  • Module: Items in the Module set provide module identification information, such as module ID's, instance names, and module types.

  • Related User: Items in the Related User set provide user records, allowing you to access information of users affected by identified actions.

  • Course: Items in the Course set provide course information, such as ID's, start dates, sort orders, and full course names.

Included LMS Tables

The following links will directly open visual representations of included tables in the Lambda Totara schema documentation. The Totara Log Data Source is comprised of elements from each of these tables. 

 

Totara

mdl_course

mdl_logstore_standard_log

mdl_user

modules (derived table)

  • No labels