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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
cloud_environment	text		The Azure Cloud Environment.
creation_time	timestamp with time zone		The creation time of the account.
description	text		The description for the account.
etag	text		Gets the etag of the resource.
id	text		Fully qualified resource ID.
last_modified_by	text		The account last modified by.
last_modified_time	timestamp with time zone		The last modified time of the account.
name	text	=	The name of the resource.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
sku_capacity	text		The SKU capacity of the account.
sku_family	text		The SKU family of the account.
sku_name	text		The SKU name of the account. Possible values include: 'SkuNameEnumFree', 'SkuNameEnumBasic'.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
state	text		The status of account. Possible values include: 'AccountStateOk', 'AccountStateUnavailable', 'AccountStateSuspended'.
subscription_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Subscription ID in which the resource is located.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
type	text		The 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