steampipe plugin install jira

Table: jira_advanced_setting - Query Jira Advanced Settings using SQL

Jira Advanced Settings is a feature within Atlassian's Jira that allows you to customize and configure the system to suit your organization's needs. It provides a way to set up and manage key-value pairs for various settings, including index path, attachment size, and more. Jira Advanced Settings helps you stay informed about the current configurations and take appropriate actions when modifications are needed.

Table Usage Guide

The jira_advanced_setting table provides insights into the advanced settings within Jira. As a system administrator, explore setting-specific details through this table, including the key and value pairs of each setting. Utilize it to uncover information about system configurations, such as attachment size, index path, and the possibility of potential modifications.

Examples

Basic info

Explore the advanced settings in your Jira instance to understand their types and associated keys. This can be useful in assessing the current configuration and identifying areas for optimization or troubleshooting.

select
id,
name,
key,
type
from
jira_advanced_setting;
select
id,
name,
key,
type
from
jira_advanced_setting;

list advanced settings that supports string type value

Explore advanced settings within Jira that support string type values. This can be useful for configuring and customizing your Jira environment to best suit your needs.

select
id,
name,
key,
type
from
jira_advanced_setting
where
type = 'string';
select
id,
name,
key,
type
from
jira_advanced_setting
where
type = 'string';

Schema for jira_advanced_setting

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
allowed_valuesjsonbThe allowed values, if applicable.
descriptiontextThe description of the application property.
idtext=The ID of the application property.
keytextThe key of the application property.
login_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier of the user login.
nametextThe name of the application property.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
titletextTitle of the resource.
typetextThe data type of the application property.
valuetextThe new value.

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_advanced_setting