steampipe plugin install azure

Table: azure_automation_account - Query Azure Automation Accounts using SQL

Azure Automation is a service in Microsoft Azure that allows you to automate your Azure management tasks and to orchestrate actions across external systems from right within Azure. It enables you to automate frequent, time-consuming, and error-prone cloud management tasks. Azure Automation account is a container for holding your automation resources in Azure.

Table Usage Guide

The azure_automation_account table provides insights into Automation Accounts within Microsoft Azure. As a cloud administrator, you can use this table to explore account-specific details, such as the configuration, status, and associated metadata. Leverage it to monitor and manage your automation resources, ensuring they are configured correctly and operating as expected.

Examples

Basic info

Explore which automation accounts are currently active within your Azure environment. This can be helpful for managing resources and understanding the types of automation accounts in use.

select
name,
id,
resource_group,
type
from
azure_automation_account;
select
name,
id,
resource_group,
type
from
azure_automation_account;

List accounts that are created in last 30 days

Explore which accounts were established in the past month. This can help in tracking recent activity and understanding the growth pattern of your accounts.

select
name,
id,
resource_group,
type,
creation_time
from
azure_automation_account
where
creation_time >= now() - interval '30' day;
select
name,
id,
resource_group,
type,
creation_time
from
azure_automation_account
where
creation_time >= datetime('now', '-30 day');

List accounts that are suspended

Determine the areas in your Azure automation accounts where accounts are suspended. This query can be useful in identifying potential issues or disruptions in your automation workflows.

select
name,
id,
resource_group,
type,
creation_time,
state
from
azure_automation_account
where
state = 'AccountStateSuspended';
select
name,
id,
resource_group,
type,
creation_time,
state
from
azure_automation_account
where
state = 'AccountStateSuspended';

Schema for azure_automation_account

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
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 account.
descriptiontextThe description for the account.
etagtextGets the etag of the resource.
idtextFully qualified resource ID.
last_modified_bytextThe account last modified by.
last_modified_timetimestamp with time zoneThe last modified time of the account.
nametext=The name of the resource.
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
sku_capacitytextThe SKU capacity of the account.
sku_familytextThe SKU family of the account.
sku_nametextThe SKU name of the account. Possible values include: 'SkuNameEnumFree', 'SkuNameEnumBasic'.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statetextThe status of account. Possible values include: 'AccountStateOk', 'AccountStateUnavailable', 'AccountStateSuspended'.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe type 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)" -- azure

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

steampipe_export_azure --config '<your_config>' azure_automation_account