Audit
Retrieves audit log records, offering insights into changes and administrative actions performed within the Jira account.
テーブル固有の情報
Select
connector はJira API を使用して一部のフィルタを処理します。
connector は他のフィルタをconnector 内で処理します。
例えば、次のクエリはサーバー側で処理されます。
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. |