A tracker displays recently accessed records in the Last Viewed bar below the module tabs. Trackers also enable users to navigate back and forth between previously accessed records.
Tracker reports provide administrators and supervisors with visibility into user actions and system performance. Tracker reports show actions such as the records views and other page views such as records saves. For example, you can run a report on the number of modules a specific user accessed on a particular day and the actions performed in those modules. Trackers allow users to keep track of records that they access during their current session.
The data that you can view in a Tracker report depends on your team membership.
When viewing tracker reports on user activity, you can only view your own data and data for users who report to you. For example, supervisors can view their own activities as well as the activities of their subordinates. Administrators can track activities for everybody.
To enable a user to view tracker data and create tracker reports, the administrator must assign the Tracker role to that individual.
Tracker reports are broadly classified into the following types:
Trackers: .This report, which tracks all page requests from users, displays the following information:
Tracker Queries:This report, which tracks queries that exceed the slow query time limit, displays the following information:
Tracker Sessions: .This report, which tracks user access session data, displays the following information:
Columns Description
Action Pages viewed and records saved
Date of Last Action The date and time when the action was performed
Item ID The record ID
Item Summary The record name or description Session ID The ID assigned to the session
Team ID The ID of the user’s private team
User ID The ID of the user who performed the action Record Visible If set to True, the records display as breadcrumbs Monitor ID Related Tracker Performance information
Columns Description
Date Last Run The date when a particular query that was over the threshold was last run
Query Count Number of times the query was run SQL Text The pattern of a particular SQL statement Average Seconds The average time taken to run the query
Total Seconds The cumulative time taken to run the query. That is, if a query was run more than once, the cumulative time reflects the total of all the query runs.
Columns Description
Session Active If set to True, an action has been tracked for the user within the last 20 minutes. An active user is defined as a user that has taken action w/in
Date Start The date that the session started. That is, when the first action was tracked.
Date of Last Action The date and time that the last recorded trackable action occurred.
Reports Module
Tracker Performance:This report, which tracks performance-related information, displays the following information:
Sugar provides several pre-defined reports for your use. You cannot edit these reports.
Some of the pre-defined reports, based on the most frequently used queries such as module usage, are available through the Tracker tab on your Home page. Other pre-defined reports, listed below, are available through the Reports module. To view the Tracker tab and to run and create tracker reports, you need access permissions from the administrator.
1. My Usage Metrics: A report that shows the cumulative sum for the server response time (in seconds), total database round trips and total files opened by the user for a specified time period such as a day, week, or month.
2. My Module Usage: A report that shows the cumulative sum for each module you accessed for a specified time period such as a day, week, or month.
3. Slow Queries: A query report that lists SQL queries that were slow to execute, along with the time it took for execution.
Seconds Active The total number of seconds between the Date Start (login) and Date of Last Action
Session ID The ID assigned to the session. If a user starts another session without logging out of an existing session, a new session ID is assigned to the user, and the new session is marked as Active (Active = True).
Client IP Address The IP Address of the client.
User ID The ID of the user who performed the action Record Visible If set to True, the records display as breadcrumbs Monitor ID Related Tracker Performance information
Columns Description
Date of Last Action The date and time that an action was performed.
Database Roundtrips The number of database calls that the action involved.
Files Accessed The number of php files used to perform the action.
Memory Usage The amount of memory used, in bytes, to perform the action
Server Response Time
The time, in seconds, taken by the server to respond.
Columns Description
4. Users Usage Metrics: A sessions report that lists the cumulative sum for the server response time (in seconds), total database round trips, and total files opened by the user.
5. My Records Modified: A report listing the modules whose records you modified in the past week.
6. My Recently Modified Records: A report that shows modules in which you recently modified records.
7. Modules Used by My Direct Reports: A report that shows the cumulative sum of each module used during the last 30 days by your direct reports. Modules that each reportee used are grouped together and presented in a separate horizontal bar.
8. Records Modified by My Direct Reports: A report that shows the modules in which your direct reports recently modified records.
9. Active User Sessions: A report that shows active sessions for a specific user during the last 7 days.
10. User Sessions: A report that shows active sessions for all users during the last 7 days.
To create a tracker report
1. On the Shortcuts menu of the Reports module, click Create Report.
2. On the Report Wizard page, select the report type such as Summation or Matrix.
3. Select the Tracker Report type of your choice and follow the process described in
“Creating Reports” on page 162.