SSIS Components for Jira

Build 25.0.9434

Audit

Retrieves audit log records, offering insights into changes and administrative actions performed within the Jira account.

Table Specific Information

Select

The component uses the Jira API to process some of the filters.

The component processes other filters within the component.

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434