steampipe plugin install jira

Table: jira_group - Query Jira Groups using SQL

Jira Groups are a collection of users within an instance of Jira, a popular project management tool. Groups offer an efficient way to manage a collection of users. They can be used to set permissions, restrict access, and manage notifications across a Jira instance.

Table Usage Guide

The jira_group table provides insights into the user groups within a Jira instance. As a project manager or system administrator, you can explore group-specific details through this table, including group names, users within each group, and associated permissions. Utilize it to manage access control, set permissions, and streamline user management within your Jira instance.

Examples

Basic info

Explore the different groups present in your Jira setup, allowing you to manage and organize users more effectively. This can be particularly useful when you need to assign tasks to specific groups or manage permissions.

select
name,
id
from
jira_group;
select
name,
id
from
jira_group;

Get associated users

Discover the segments that are associated with specific users in a group. This can help in managing user access and permissions effectively.

select
name as group_name,
u.display_name as user_name,
user_id,
u.email_address as user_email
from
jira_group as g,
jsonb_array_elements_text(member_ids) as user_id,
jira_user as u
where
user_id = u.account_id
order by
group_name,
user_name;
select
g.name as group_name,
u.display_name as user_name,
user_id.value as user_id,
u.email_address as user_email
from
jira_group as g,
json_each(g.member_ids) as user_id,
jira_user as u
where
user_id.value = u.account_id
order by
group_name,
user_name;

Schema for jira_group

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
idtext=The ID of the group, if available, which uniquely identifies the group across all Atlassian products. For example, 952d12c3-5b5b-4d04-bb32-44d383afc4b2.
login_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier of the user login.
member_idsjsonbList of account ids of users associated with the group.
member_namesjsonbList of names of users associated with the group.
nametextThe name of the group.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
titletextTitle of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- jira

You can pass the configuration to the command with the --config argument:

steampipe_export_jira --config '<your_config>' jira_group