Audit
Retrieves audit log records, offering insights into changes and administrative actions performed within the Jira account.
Table Specific Information
Select
The add-in uses the Jira API to process some of the filters.
The add-in processes other filters within the add-in.
For example, the following queries are processed server side:
SELECT * FROM Audit WHERE Filter = 'ab'
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| RecordId | Integer | Common | The unique identifier of the audit record, used to distinguish individual audit log entries. | ||
| Summary | String | Common | A brief summary describing what change occurred, such as a permission update or user role change. | ||
| RemoteAddress | String | Common | The IP address from which the action was performed, providing traceability of the source system. | ||
| AuthorKey | String | Common | The unique internal key of the user or system that performed the audited action. | ||
| Created | Datetime | Common | The timestamp indicating when the change was recorded in the audit log. | ||
| Category | String | Common | The general category of the change, such as 'User Management', 'Project Configuration', or 'Workflow Edits'. | ||
| EventSource | String | Common | The origin of the event that triggered the audit record, such as a UI interaction or REST API call. | ||
| Description | String | Common | A detailed explanation of the change that was made, including the context and nature of the update. | ||
| ItemId | String | Common | A system-generated unique identifier of the item (such as a user, project, or setting) that was changed. | ||
| ItemName | String | Common | The name of the item affected by the audited change, such as a project name or field label. | ||
| ItemTypeName | String | Common | The type of the item that was changed, such as 'Custom Field', 'User', or 'Project'. | ||
| ItemParentId | String | Common | The unique identifier of the parent object, if the audited item is part of a hierarchy (such as a field within a project). | ||
| ItemParentName | String | Common | The name of the parent object related to the item, such as the project or configuration scheme name. | ||
| FieldName | String | Common | The name of the specific field that was changed, such as 'Permission Scheme' or 'Project Lead'. | ||
| ChangedFrom | String | Common | The original value of the field before the change was applied. | ||
| ChangedTo | String | Common | The new value of the field after the change was completed. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| Filter | String | A keyword filter used to return only audit records that contain a specified string in at least one field. For example, using 'permission' will return changes involving permission updates. |