SSIS Components for Jira

Build 25.0.9434

ApplicationRoles

Retrieves all configured application roles, which control user access and are managed through Jira's Application Access settings.

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 ApplicationRoles WHERE Key = 'jira-software'

Columns

Name Type References SupportedOperators Platform Description
Key [KEY] String = Common A unique identifier used to reference the application role programmatically. This value is used in API calls and internal configuration.
Name String Common The user-friendly display name of the application role, such as 'Jira Software' or 'Jira Service Management'.
Groups String Common A comma-separated list of Jira groups associated with this application role. Users in these groups gain access to the role's features.
DefaultGroups String Common A comma-separated list of groups automatically assigned this role when new users are created, providing them with default application access.
SelectedByDefault Boolean Common If the value is 'true', this application role is automatically selected for new users during account creation unless otherwise specified.
NumberOfSeats Integer Common The total number of user licenses allocated to this application role, as defined by your Jira subscription.
RemainingSeats Integer Common The number of user licenses still available for this application role, based on current usage and subscription limits.
UserCount Integer Common The total number of active users currently consuming seats under this application role.
UserCountDescription String Common A brief description of the user types included in the seat count, such as active users or users with specific group memberships.
HasUnlimitedSeats Boolean Common If the value is 'true', there is no limit to the number of users who can be assigned this application role.
Platform Boolean Common If the value is 'true', this application role is part of the Jira platform core (jira-core), as opposed to an add-on like Jira Software or Jira Service Management.

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