steampipe plugin install azure

Table: azure_logic_app_workflow - Query Azure Logic App Workflows using SQL

Azure Logic Apps is a cloud service that helps you schedule, automate, and orchestrate tasks, business processes, and workflows when you need to integrate apps, data, systems, and services across enterprises or organizations. Logic Apps simplifies how you design and build scalable solutions for app integration, data integration, system integration, enterprise application integration (EAI), and business-to-business (B2B) communication, whether in the cloud, on premises, or both. You can build workflows that automatically trigger and run whenever a specific event occurs or when new data meets the conditions that you defined.

Table Usage Guide

The azure_logic_app_workflow table provides insights into Logic App Workflows within Azure. As a DevOps engineer, explore workflow-specific details through this table, including configuration, status, and associated properties. Utilize it to monitor and manage automated business processes, ensuring efficient data and system integration.

Examples

Basic info

Explore which Azure Logic App workflows are active or inactive and their associated types. This can be beneficial for identifying workflows that may need attention or tracking the variety of workflow types in use.

select
name,
id,
state,
type
from
azure_logic_app_workflow;
select
name,
id,
state,
type
from
azure_logic_app_workflow;

List disabled workflows

This query allows you to identify all disabled workflows within your Azure Logic App, helping to manage and optimize your workflow processes. This could be particularly useful for troubleshooting, auditing, or improving efficiency by identifying unused or unnecessary workflows.

select
name,
id,
state,
type
from
azure_logic_app_workflow
where
state = 'Disabled';
select
name,
id,
state,
type
from
azure_logic_app_workflow
where
state = 'Disabled';

List suspended workflows

Determine the areas in which Azure Logic App workflows are currently suspended. This is useful for troubleshooting and identifying workflows that may need attention or modification.

select
name,
id,
state,
type
from
azure_logic_app_workflow
where
state = 'Suspended';
select
name,
id,
state,
type
from
azure_logic_app_workflow
where
state = 'Suspended';

Schema for azure_logic_app_workflow

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
access_controljsonbThe access control configuration.
access_endpointtextThe access endpoint of the workflow.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
changed_timetimestamp with time zoneSpecifies the time, the workflow was updated.
cloud_environmenttextThe Azure Cloud Environment.
created_timetimestamp with time zoneThe time when workflow was created.
definitionjsonbThe workflow defination.
diagnostic_settingsjsonbA list of active diagnostic settings for the workflow.
endpoints_configurationjsonbThe endpoints configuration.
idtextThe resource identifier.
integration_accountjsonbThe integration account of the workflow.
integration_service_environmentjsonbThe integration service environment of the workflow.
nametext=The resource name.
parametersjsonbThe workflow parameters.
provisioning_statetextThe provisioning state of the workflow.
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
sku_nametextThe sku name.
sku_planjsonbThe sku Plan.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statetextThe state of the workflow.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe resource type.
versiontextVersion of the workflow.

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_logic_app_workflow