Table: jira_user - Query Jira Users using SQL

Jira is a popular project management tool developed by Atlassian. It is primarily used for issue tracking, bug tracking, and project management. Jira allows teams to plan, track, and manage agile software development projects.

Table Usage Guide

The jira_user table provides insights into user accounts within Jira. As a project manager or system administrator, explore user-specific details through this table, including account statuses, email addresses, and associated metadata. Utilize it to uncover information about users, such as their account statuses, their last login details, and their group memberships.

Examples

Basic info

Explore which Jira users are active and understand their respective account types. This can help in managing user roles and access within your Jira environment.

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

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

Get associated names for a particular user

Explore the group affiliations of a specific user to understand their role and access permissions within the system.

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

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

Schema for jira_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text		The account ID of the user, which uniquely identifies the user across all Atlassian products. For example, 5b10ac8d82e05b22cc7d4ef5.
account_type	text		The user account type. Can take the following values: atlassian, app, customer and unknown.
active	boolean		Indicates if user is active.
avatar_urls	jsonb		The avatars of the user.
display_name	text		The display name of the user. Depending on the user's privacy setting, this may return an alternative value.
email_address	text		The email address of the user. Depending on the user's privacy setting, this may be returned as null.
group_names	jsonb		The groups that the user belongs to.
login_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier of the user login.
self	text		The URL of the user.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title 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_user