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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
allowed_values	jsonb		The allowed values, if applicable.
description	text		The description of the application property.
id	text	=	The ID of the application property.
key	text		The key of the application property.
login_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier of the user login.
name	text		The name of the application property.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title of the resource.
type	text		The data type of the application property.
value	text		The 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