turbot/jira

steampipe plugin install jirasteampipe plugin install jira

Table: jira_user

A User represents an entity that logs in to Jira.

Examples

Basic info

select
display_name,
account_type as type,
active as status,
account_id
from
jira_user;

Get associated names for a particular user

select
display_name,
active as status,
account_id,
jsonb_pretty(group_names) as group_names
from
jira_user
where
display_name = 'Confluence Analytics (System)';

.inspect jira_user

User in the Jira cloud.

NameTypeDescription
account_idtextThe account ID of the user, which uniquely identifies the user across all Atlassian products. For example, 5b10ac8d82e05b22cc7d4ef5.
account_typetextThe user account type. Can take the following values: atlassian, app, customer and unknown.
activebooleanIndicates if user is active.
avatar_urlsjsonbThe avatars of the user.
display_nametextThe display name of the user. Depending on the user’s privacy setting, this may return an alternative value.
email_addresstextThe email address of the user. Depending on the user’s privacy setting, this may be returned as null.
group_namesjsonbThe groups that the user belongs to.
selftextThe URL of the user.
titletextTitle of the resource.