---
title: "Activity Log Table"
canonical: "https://help.agiloft.com/space/A2508SD/134060054/Activity+Log+Table"
format: markdown
---
The Activity Log table maintains historical records of specified types of system usage events, such as system startups, user logins and logouts, and field or table deletions. Data in this table allows administrators to monitor and report on day-to-day activities of users and the system.

> ℹ️ Activity logs are unrelated to History entries for individual tables. Table history captures changes made to records in the table independent of Activity Log setup.

# Use Case

Activity logs are used to audit the system. You can generate reports or create dashboards that give administrators an overview of monitored activities, such as file downloads, changes to workflows or business rules, or failed login attempts. You can also configure rules based on activity logs, such as a notification rule that emails administrators if a user's account is locked. For information on the charts and reports provided out-of-the-box, see [Charts/Reports](#charts_reports) below.

The system generates all Activity Log records. No group has permission to create records in the table or change the table's permissions. Each record stores details about one occurrence of a tracked activity. Audit rules control which activities to log, how long to retain records of those activities, and which users to track. The out-of-the-box system includes the audit rules listed below. You can view the rules by going to **Setup > System > Configure Activity Log**.

- **System Events**: This rule captures all system restarts. Records are retained for 1 month.
- **All Logins**: This rule logs all user logins and logouts, including logouts due to timeouts. Records are retained for 6 months.
- **All Admin Actions Last Year**: This rule logs the following types of admin-level activities by all users. Records are retained for 1 year.
  - Edits to tables, groups, teams, columns, rules, workflows, and action bars
  - Creation of tables, groups, teams, rules, and columns, or adding columns to history
  - Deletion of columns or removing columns from history
- **All Deletions Last Month**: This rule logs deletions of records, files, tables, groups, teams, columns, and rules by all users. Records are retained for 1 month.

For more information and instructions on adding audit rules to monitor other activities, see [Activity Logs Setup](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43714435) in the Help Guide.

# Views

The Default View for the out-of-the-box Activity Log table shows the ID, Action, Description, Login, and Date fields.

![Default View for the Activity Log table](media://8af84e9b-6d1e-43f3-b1e4-8b8f1286b37d)

In addition to Default View and other [standard views](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43718574), the table includes a Detail View that adds the Table Label and Record ID columns to the Default View.

# > Macro (anchor)

Saved Searches

The out-of-the-box Activity Log table includes the following saved search in the navigation menu:

- **Login Actions Since Runtime Date**: Run-time search that finds all login events that occurred on or after the date you specify. Selecting the search displays a dialog box for entering the date run-time parameter. Specify the date to start the search from and click Go to run the search.

# > Macro (anchor)

Charts/Reports

In the out-of-the-box system, the Activity Log table includes the following charts and reports. For information on working with charts and reports, see [Create and Edit Charts and Reports](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43714395) in the Help Guide.

- **Login Actions Since Runtime Date**: Like the [saved search](#saved_searches) above, this option reports on the number of login events that have occurred since the specified start date. The bar chart shows the number of logins per user, and the report lists each login event for each user.
- **All Logins to the System**: Reports on all logins from the earliest Activity Log. The bar chart shows the number of logins per user, and the report lists each login event for each user.

> ℹ️ By default, the All Logins audit rule retains records for 6 months. That means the earliest Activity Log entry for the report falls within the last 6 months.

- **Runtime Activity by Login**: Reports on all tracked activities for a user in the current month. The bar chart shows the number of actions on each day of the month for the specified user, segmented by action. The report lists all events for the specified user sorted by action. Viewing the chart displays a dialog box for entering the run-time parameter. Specify the login to filter by and click Go to populate the chart and report.

# Fields

The out-of-the-box Activity Log table includes the following fields.

| **Field Label** | **Data Type** | **Description** |
| --- | --- | --- |
| Action | Choice:<br>To see all possible Action values, go to **Setup > System > Configure Activity Log** and edit or view an audit rule. Actions are shown as a list of checkboxes. | The tracked action. |
| Action Duration | Elapsed Time | The duration of the activity in seconds. |
| User Name  
User Login  
User Primary Team  
Company | Link to selected fields from other table: People | These fields identify the user who performed the action. |
| Cookie | Short Text | The cookie that identifies the source device. |
| Date | Base date/time domain | The date of the activity. |
| Description | Text | A description of the activity. |
| Groups | Short Text | The groups the user is a member of. |
| Interface | Choice:<br>- Admin
- Undefined
- End User
- Staff | The user interface where the activity was performed. |
| IP | Short Text | The IP address of the user who performed the activity. |
| Record Id | null | The identifier for the record that was affected. |
| Rule Id | null | The identifier for the rule that was affected. |
| Session duration | Elapsed Time | The duration of the user's session. |
| Session Id | null | The identifier for the user's session. |
| Table Label | Short Text | The name of the table that was affected. |

# Ownership

The system owns records in the Activity Log table. No group has permission to create records, and you can't change the permissions or reassign ownership.