turbot/jira

steampipe plugin install jirasteampipe plugin install jira

Table: jira_group

A Group is a collection of users. Administrators create groups so that the administrator can assign permissions to a number of people at once.

Examples

Basic info

select
name,
id
from
jira_group;

Get associated users

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;

.inspect jira_group

Group is a collection of users. Administrators create groups so that the administrator can assign permissions to a number of people at once.

NameTypeDescription
idtextThe ID of the group, if available, which uniquely identifies the group across all Atlassian products. For example, 952d12c3-5b5b-4d04-bb32-44d383afc4b2.
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.
titletextTitle of the resource.