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';

Control examples

Resource logs in Logic Apps should be enabled

Schema for azure_logic_app_workflow

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
access_control	jsonb		The access control configuration.
access_endpoint	text		The access endpoint of the workflow.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
changed_time	timestamp with time zone		Specifies the time, the workflow was updated.
cloud_environment	text		The Azure Cloud Environment.
created_time	timestamp with time zone		The time when workflow was created.
definition	jsonb		The workflow defination.
diagnostic_settings	jsonb		A list of active diagnostic settings for the workflow.
endpoints_configuration	jsonb		The endpoints configuration.
id	text		The resource identifier.
integration_account	jsonb		The integration account of the workflow.
integration_service_environment	jsonb		The integration service environment of the workflow.
name	text	=	The resource name.
parameters	jsonb		The workflow parameters.
provisioning_state	text		The provisioning state of the workflow.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
sku_name	text		The sku name.
sku_plan	jsonb		The sku Plan.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
state	text		The state of the workflow.
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 resource type.
version	text		Version 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