Skip to content

Bots From Extension: azure-insights

Microsoft Azure Insights - Collect metrics and logs from Azure

This extension provides 25 bots.





Bot @azurein:ai-token-usage

Bot Position In Pipeline: Sink

AZURE Insights - Azure OpenAI token counts by deployment and model version.

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
subscription_id_column Text Column name which contains Azure subscription IDs. Used when discovering accounts.
resource_id_column Text Optional column of Cognitive Services account resource IDs. When set, only those accounts are
queried.
timestamp DateTime Time window. Default is the last 24h. Ex: timestamp is after -2days and timestamp is before
-1d
interval Text PT1H Azure Monitor interval. Minimum PT1M. Ex: PT15M, PT1H, P1D
series_limit Text 100 Max deployment/model series returned per account (1-1000). Azure returns 10 when this is omitted.
concurrent_discovery Text 5 Number of accounts to query concurrently
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:amortized-cost

Bot Position In Pipeline: Sink

AZURE Insights - Resource-level amortized cost in billing currency and USD.

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
subscription_id_column Text Column name which contains Azure subscription IDs. When omitted, every accessible subscription
is queried.
timeframe Text MonthToDate Cost Management timeframe when timestamp is omitted: MonthToDate, BillingMonthToDate, TheLastMonth,
TheLastBillingMonth, or WeekToDate.
timestamp DateTime Custom cost window. When set, the query uses timeframe Custom. Ex: timestamp is after -30d
granularity Text None Time breakdown: None (one total per resource, default), Daily, or Monthly.
concurrent_discovery Text 1 Number of subscriptions to query concurrently. The Cost Management query API is rate-limited;
default 1.
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:amortized-cost-details

Bot Position In Pipeline: Sink

AZURE Insights - Daily amortized cost details, including the savings plan effective price.

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
subscription_id_column Text Column name which contains Azure subscription IDs. When omitted, every accessible subscription
is queried.
timestamp* DateTime Required cost window. Each row is one day's charge inside this range. Ex: timestamp is after
-7d
concurrent_discovery Text 1 Number of subscriptions to query concurrently. Cost details reports are large; default 1.
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:billing-accounts

Bot Position In Pipeline: Sink

AZURE Insights - Billing accounts and the billing profiles on each account.

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:contract-price-sheet

Bot Position In Pipeline: Sink

AZURE Insights - Contract price sheet for an MCA billing profile or EA billing account. Writes to a pstream by default.

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
billing_account Text Billing account name. MCA: '<guid>:<guid>_YYYY-MM-DD'; EA: enrollment number. Discovered
when omitted.
billing_profile Text MCA billing profile id, e.g. 'W7FZ-F7YX-BG7-PGB'. Every profile of the account when omitted.
billing_period Text EA only: billing period as YYYYMM. Defaults to the current month.
meter_category Text Optional comma-separated meter categories to keep, e.g. 'Virtual Machines'
price_type Text Optional comma-separated price types to keep, e.g. 'Consumption'
meter_region Text Optional comma-separated meter regions to keep, e.g. 'EU West'
return_type Text pstream Where the rows go. 'pstream' (default) publishes each batch and returns a one-row summary.
'dataset' returns the rows to the pipeline.
pstream_name Text Pstream to write. Required when return_type is pstream. Set unique_keys to billing_account_id,
billing_profile_id, product_order_name, product_id, sku_id, meter_id, meter_name, price_type,
term, tier_minimum_units so the next run updates each price.
stream_batch_size Text 500 Rows per pstream publish.







Bot @azurein:cost-benefit-recommendations

Bot Position In Pipeline: Sink

AZURE Insights - List savings plan purchase recommendations.

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
subscription_id_column Text Column Name which contains Azure Subscription IDs
scope Text Shared Savings plan recommendation scope: Single or Shared
look_back_period Text Last60Days Usage period evaluated: Last7Days, Last30Days, or Last60Days
term Text P3Y Savings plan term: P1Y or P3Y
expand Text properties/usage,properties/allRecommendationDetails Related recommendation properties to expand. Without properties/allRecommendationDetails only
the proposed commitment is returned; set to an empty value to omit
concurrent_discovery Text 5 Number of subscriptions to collect concurrently
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:logs

Bot Position In Pipeline: Sink

AZURE Insights - Logs

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
subscription_id_column Text Column Name which contains Azure Subscription IDs
timestamp DateTime CFXQL for filtering the data for a specified time period. Default is last 24h. The start time
must be within the past 90 days. Ex: timestamp is after -2days and timestamp is before -1d
concurrent_discovery Text 10 Number of concurrent jobs to run
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:logs:analytics

Bot Position In Pipeline: Source

Azure Insights - Log Analytics data for a given workspace/table

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
WorkspaceID Text Azure WorkspaceID. If not provided, all workspaces across all subscriptions are queried.
timestamp* DateTime Time duration
Table Text InsightsMetrics Azure table name







Bot *azurein:logs:workspaces

Bot Position In Pipeline: Source

Azure LogAnalytics Workspaces

This bot expects a Full CFXQL.

Bot applies the Query on the data that is already loaded from previous bot or from a source.







Bot @azurein:metric-alarms

Bot Position In Pipeline: Sink

AZURE Insights Metric Alarms

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
subscription_id_column Text Column Name which contains Azure Subscription IDs
concurrent_discovery Text 10 Number of concurrent jobs to run
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:metric-data

Bot Position In Pipeline: Sink

Azure Insights - Metric Data

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
object_id_column* Text Column Name which contains Azure object ID for which metrics are to be fetched
metric_name_column* Text Column Name which contains Azure metrics name
timestamp* DateTime CFXQL for filtering the data for a specified time period. Default is last 24h. Ex: timestamp
is after -2days and timestamp is before -1d
aggregation Text average Azure metrics aggregation method
interval Text PT1H Azure Metrics Interval. Ex: PT15M, PT1H, P1D
concurrent_discovery Text 10 Number of concurrent jobs to run
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:metric-ids

Bot Position In Pipeline: Sink

AZURE Insights Metric Ids

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
subscription_id_column Text Column Name which contains Azure Subscription IDs
concurrent_discovery Text 10 Number of concurrent jobs to run
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:metrics-list

Bot Position In Pipeline: Sink

Azure Insights - Metrics List

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
subscription_id_column Text Column Name which contains Azure Subscription IDs
concurrent_discovery Text 10 Number of concurrent jobs to run
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:operations

Bot Position In Pipeline: Sink

AZURE Insights - List available cost management REST API operations.

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:price-sheet

Bot Position In Pipeline: Sink

AZURE Insights - Get the price sheet for a subscription

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
subscription_id_column Text Column Name which contains Azure Subscription IDs
concurrent_discovery Text 10 Number of concurrent jobs to run
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:prices

Bot Position In Pipeline: Sink

AZURE Insights - Get Azure Retail Prices.

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:savings-plan-utilization

Bot Position In Pipeline: Sink

AZURE Insights - Savings plan used and unused percentage over time.

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
savings_plan_resource_id_column Text Optional column of savings plan resource ids. When set, only those plans are queried.
include_archived Text false Include archived savings plans when discovering plans. Default false.
grain Text Daily Utilization grain: Hourly, Daily, or Monthly. Default Daily.
timestamp DateTime Usage-date window. Default is the last 7 days. Ex: timestamp is after -30d
concurrent_discovery Text 5 Number of savings plans to query concurrently
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:savings-plans

Bot Position In Pipeline: Sink

AZURE Insights - Owned savings plans and 1, 7, and 30 day utilization.

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
include_archived Text false Include archived savings plans. Default false.
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:subscription-metrics-ids

Bot Position In Pipeline: Sink

AZURE Insights - List of VMs in the subscription

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
subscription_id_column Text Column Name which contains Azure Subscription IDs
concurrent_discovery Text 10 Number of concurrent jobs to run
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:subscriptions

Bot Position In Pipeline: Sink

Azure Subscriptions accessible to the credentials

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:usage

Bot Position In Pipeline: Sink

AZURE Insights - List Azure Usage Details.

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
subscription_id_column Text Column Name which contains Azure Subscription IDs
timestamp DateTime Usage date range. Ex: timestamp is after -7d. Defaults to month-to-date.
concurrent_discovery Text 2 Number of subscriptions to collect concurrently. Keep low for usageDetails (rate-limited);
default 2
page_size Text 1000 Records per usageDetails page ($top, max 1000). Larger pages mean fewer sequential requests
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:vm-metrics

Bot Position In Pipeline: Sink

AZURE Insights - Get all VM Metric Data

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
subscription_id_column Text Column Name which contains Azure Subscription IDs
timestamp DateTime CFXQL for filtering the data for a specified time period. Default is last 24h. Ex: timestamp
is after -2days and timestamp is before -1d
interval Text PT15M Azure Metrics Interval. Ex: PT15M, PT1H, P1D
concurrent_discovery Text 10 Number of concurrent jobs to run
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:vm-pricing

Bot Position In Pipeline: Sink

AZURE Insights - List and contract hourly rate per VM size, read from the contract-price-sheet pstream.

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
pstream_name* Text Pstream written by contract-price-sheet.
region Text Optional comma-separated regions. ARM codes or price-sheet names, e.g. 'westeurope,eastus'
or 'EU West'.
vm_size Text Optional comma-separated VM sizes, e.g. 'Standard_D8ds_v5,Standard_D8ds_v6'.
vm_size_column Text Column in the input dataset holding VM sizes to price. Same role as instance_types_column on
ec2-pricing.
operating_system Text all all (default), Linux, or Windows.
include_low_priority Text no Include Low Priority / Spot meters. Default no.







Bot @azurein:vm-rates

Bot Position In Pipeline: Sink

AZURE Insights - Pay-as-you-go, negotiated, savings plan and effective hourly rate per VM size.

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
subscription_id_column Text Column name which contains Azure subscription IDs. When omitted, every accessible subscription
is queried.
timestamp* DateTime Required cost window. Ex: timestamp is after -30d
region Text Optional comma-separated resource locations, e.g. 'westeurope,northeurope'
vm_size Text Optional comma-separated VM sizes, e.g. 'Standard_D8ds_v5'
per_subscription Text yes 'yes' (default) for one row per subscription; 'no' to combine subscriptions
concurrent_discovery Text 1 Number of subscriptions to query concurrently. Cost details reports are large; default 1.
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka







Bot @azurein:vm-size-types

Bot Position In Pipeline: Sink

AZURE Insights - VM Size Types

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
subscription_id_column Text Column Name which contains Azure Subscription IDs
concurrent_discovery Text 10 Number of concurrent jobs to run
stream_type Text dataset Output target: 'dataset' (return to pipeline, default), 'pstream', or 'kafka'
stream_name Text Target pstream/kafka name. Required when stream_type is 'pstream' or 'kafka'
stream_batch_size Text 500 Records per publish batch when streaming to pstream/kafka