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 |