Skip to content

Bots From Extension: azure-insights

Microsoft Azure Insights - Collect metrics and logs from Azure

This extension provides 15 bots.





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: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
concurrent_discovery Text 10 Number of concurrent jobs to run
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-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