steampipe plugin install azure

Table: azure_automation_variable - Query Azure Automation Variables using SQL

Azure Automation is a cloud-based service offered by Microsoft Azure that allows organizations to automate and configure certain tasks across their Azure and non-Azure environments. It provides a way to manage, monitor, and act upon the infrastructure resources in a scalable and reliable manner. Azure Automation Variables are entities within this service that store values which can be used in runbooks, DSC configurations, and other features of Azure Automation.

Table Usage Guide

The azure_automation_variable table provides insights into Azure Automation Variables within Azure Automation. As a DevOps engineer, explore variable-specific details through this table, including the type of value it holds, whether it is encrypted, and its associated metadata. Utilize it to uncover information about variables, such as their current values, and the automation accounts they are associated with.

Examples

Basic info

Analyze the settings to understand the encryption status of variables in your Azure automation accounts. This will help in assessing the security posture of your automation workflows.

select
id,
name,
account_name,
type,
is_encrypted,
value
from
azure_automation_variable;
select
id,
name,
account_name,
type,
is_encrypted,
value
from
azure_automation_variable;

List variables that are unencrypted

Discover the segments that are unencrypted within your Azure Automation variables. This can be beneficial in identifying potential security risks and ensuring data protection standards are met.

select
id,
name,
account_name,
type,
is_encrypted,
value
from
azure_automation_variable
where
not is_encrypted;
select
id,
name,
account_name,
type,
is_encrypted,
value
from
azure_automation_variable
where
not is_encrypted;

List variables created in last 30 days

Explore the recent changes in your Azure Automation environment by identifying variables that were created within the last 30 days. This can help you monitor and control your automation tasks, ensuring they align with your current needs and standards.

select
id,
name,
account_name,
creation_time,
type,
is_encrypted,
value
from
azure_automation_variable
where
creation_time >= now() - interval '30' day;
select
id,
name,
account_name,
creation_time,
type,
is_encrypted,
value
from
azure_automation_variable
where
creation_time >= datetime('now', '-30 day');

Get details of a variable

Discover the specifics of a particular variable within a given account and resource group. This is useful in understanding the variable's attributes, such as its type and encryption status, which can aid in managing and securing your Azure automation tasks.

select
id,
name,
account_name,
type,
is_encrypted,
value
from
azure_automation_variable
where
account_name = 'turbot_account'
and name = 'turbot'
and resource_group = 'turbot_rg';
select
id,
name,
account_name,
type,
is_encrypted,
value
from
azure_automation_variable
where
account_name = 'turbot_account'
and name = 'turbot'
and resource_group = 'turbot_rg';

Schema for azure_automation_variable

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_nametext=The name of the account.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
creation_timetimestamp with time zoneThe creation time of the variable.
descriptiontextThe description for the variable.
idtextFully qualified resource ID.
is_encryptedbooleanThe encrypted flag of the variable.
last_modified_timetimestamp with time zoneThe last modified time of the variable.
nametext=The name of the resource.
resource_grouptext=The resource group which holds this resource.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
titletextTitle of the resource.
typetextThe type of the resource.
valuetextThe value of the variable.

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)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_automation_variable