Table: ini_section - Query Config INI Sections using SQL
An INI Section is a part of the INI file format that is used for configuration settings. INI files are simple text files with a basic structure composed of sections, properties, and values. The sections, denoted by the square bracket syntax, categorize the properties and values for easy retrieval and readability.
Table Usage Guide
The ini_section
table provides insights into INI sections within configuration files. As a DevOps engineer, explore section-specific details through this table, including associated properties and values. Utilize it to uncover information about configuration settings, such as those with undefined properties, the organization of sections, and the verification of property values.
Examples
Basic info
Explore the structure and comments of your configuration files to better understand their organization and purpose. This can be particularly useful when troubleshooting or optimizing your system setup.
select path, section, commentfrom ini_section;
select path, section, commentfrom ini_section;
List sections for a specific file
Explore which sections and associated comments are present in a specific configuration file. This is useful for understanding the configuration and settings of your applications.
select path, section, commentfrom ini_sectionwhere path = '/Users/myuser/configs/main.ini';
select path, section, commentfrom ini_sectionwhere path = '/Users/myuser/configs/main.ini';
List subsections for a specific section
Discover the segments that fall under a particular category in your configuration files. This can be useful when you need to understand the structure of a specific section for easier navigation and management.
select path, section, commentfrom ini_sectionwhere section like 'settings.%';
select path, section, commentfrom ini_sectionwhere section like 'settings.%';
Schema for ini_section
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
comment | text | The short notes used to describe the key. | |
path | text | = | Specifies the path of the INI file. |
section | text | Specifies the name of the section. |
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)" -- config
You can pass the configuration to the command with the --config
argument:
steampipe_export_config --config '<your_config>' ini_section