Azure Data Stream Parameters
The Azure plugin provides configurable data streams to fetch cost data and service metrics.
Each configurable data stream exposes a set of parameters that lets you filter the data you retrieve. The following information describes the available configurable data streams and their parameters in detail.
Alerts
Parameter | Description |
|---|---|
Monitor condition | Optionally, specify a monitor condition to filter results by. |
Severity | Optionally, specify the severity of the alert to filter results by. |
Availability History
Parameter | Description |
|---|---|
Timeframe column | Select which field to apply the dashboard / tile timeframe to. This will filter results that fall within that given timeframe. |
Cost
Parameter | Description |
Group By | Optionally, select a grouping dimension to organize cost data. The chosen fields determines how costs are aggregated and segmented. |
Filter | Select a resource type to filter cost data by. This limits the data stream to costs associated only with the chosen Azure resource type, helping you focus on specific areas of spend. |
Granularity | Choose the level of time detail for cost data. Granularity determines how costs are broken down over time. A finer granularity gives more detailed insights, while a coarser granularity provides broader cost trend |
Metric type | Select the cost measurement to retrieve. Metric type determines whether the data stream returns actual usage-based costs, amortized costs, or other supported cost metrics, allowing you to analyze spend from different perspectives. |
Cost (By Tag)
Parameter | Description |
|---|---|
Group by tag | Organize cost data based on up to two a specified tag keys. Costs are aggregated by the values of the selected tag, allowing you to analyze spending across categories. |
Filter by tag | Optionally, select a tag value to filter by. This narrows the cost data to resources tagged with the chosen key, helping focus analysis on relevant groups. This field is only enabled when Group by tag is populated. |
Metric type | Select the cost measurement to retrieve, allowing you to analyze spend from different perspectives. Choose from:
|
Cumulative cost | Select to enable cumulative aggregation. When enabled, costs are summed over time to show running totals, providing a continuous view of spending trends rather than isolated intervals. |
Cost (Invoice Details)
Parameter | Description |
|---|---|
Metric type | Select the cost measurement to retrieve, allowing you to analyze spend from different perspectives. Choose from:
|
Cost (Location)
Parameter | Description |
|---|---|
Metric type | Select the cost measurement to retrieve, allowing you to analyze spend from different perspectives. Choose from:
|
Cost (Service)
Parameter | Description |
|---|---|
Metric type | Select the cost measurement to retrieve, allowing you to analyze spend from different perspectives. Choose from:
|
Data Explorer KQL Query
Parameter | Description |
|---|---|
Cluster | Select the cluster that contains the data you want to query. The cluster determines the endpoint where the KQL query will be executed. |
Database | Choose the database within the selected cluster that holds the data. This scopes the query to a specific dataset and ensures accurate results. |
KQL query | Enter the KQL query to retrieve and analyze data. The query defines the metrics, filters, and transformations applied to the selected database. It is recommended that you first run the query in Azure to ensure that it isn't retrieving too many results. If the query displays the "Your query is consuming excessive resources" message in Azure, then the SquaredUp tile using that query will timeout. |
Guest VM Metrics
Parameter | Description |
|---|---|
Metric name | Select a metric name to return data for. |
Log Analytics KQL Query
Parameter | Description |
|---|---|
KQL Query | Enter a KQL query to retrieve log analytics data. It is recommended that you first run the query in Azure to ensure that it isn't retrieving too many results. If the query displays the "Your query is consuming excessive resources" message in Azure, then the SquaredUp tile using that query will timeout. |
Ignore dashboard timeframe | If selected, the Timeframe entered below will be used instead. |
API version | Optionally, enter an API Version, for example: 2017-10-01. |
Timeframe | Optionally, supply an ISO duration to override the dashboard timeframe |
Log Analytics KQL Query (object aware)
Parameter | Description |
|---|---|
KQL Query | Enter a KQL query to retrieve log analytics data. It is recommended that you first run the query in Azure to ensure that it isn't retrieving too many results. If the query displays the "Your query is consuming excessive resources" message in Azure, then the SquaredUp tile using that query will timeout. |
Ignore dashboard timeframe | If selected, the Timeframe entered below will be used instead. |
Timeframe | Optionally, supply an ISO duration to override the dashboard timeframe |
Metrics
Parameter | Description |
|---|---|
Metric mode | Choose whether to query a single metric or multiple metrics. Advanced options are only available when selecting a single metric. |
Metric name | Select a metric from the dropdown to query, for example: TotalRequests. |
Aggregation | Optionally, select an aggregation to group the data by. |
Advanced (split and filter) | Select to display the Split by dimension and Filter by dimension field sections. |
(Split by dimension) Dimension name | Select the Azure metric dimension you want to break down the data by. The dimension is added as a new column containing the dimension values. |
Limit | Define the maximum number of dimension values to return. Useful when a dimension has many values but you only want to chart the top N. |
(Filter by dimension) Dimension name | Choose the Azure metric dimension you want to filter on. |
Dimension values | Select one or more specific values of the chosen dimension to include in your dataset. This helps narrow the data to only relevant subsets. |
Roll up filtered values | Enable to roll up filtered values to the next level up. For example, if you are using a Count aggregation filtered to multiple dimension values, selecting this option will return a single aggregated Count across both values. |
Reservation Recommendations
Parameter | Description |
|---|---|
Recommendation scope | Choose whether to view recommendations for a Single subscription or across Shared scope (multiple subscriptions). |
Resource type | Specify the Azure resource type for which you want to see reservation recommendations. |
Resource Compliance
Parameter | Description |
|---|---|
Compliance state | Specify compliance states to filter results by. |
Policy Assignments | Select policy assignments to filter results by. |
Resource Graph KQL Query
Parameter | Description |
|---|---|
KQL Query | Enter the KQL query to retrieve and analyze data. The query defines the metrics, filters, and transformations applied to the selected database. It is recommended that you first run the query in Azure to ensure that it isn't retrieving too many results. If the query displays the "Your query is consuming excessive resources" message in Azure, then the SquaredUp tile using that query will timeout. |
API version | Optionally, enter an API Version to use for the query, for example: 2017-10-01. |
Resource Graph KQL Query (object aware)
Parameter | Description |
|---|---|
KQL Query | Enter the KQL query to retrieve and analyze data. The query defines the metrics, filters, and transformations applied to the selected database. It is recommended that you first run the query in Azure to ensure that it isn't retrieving too many results. If the query displays the "Your query is consuming excessive resources" message in Azure, then the SquaredUp tile using that query will timeout. |
API version | Optionally, enter an API Version to use for the query, for example: 2017-10-01. |
Savings Plan Recommendations
Parameter | Description |
|---|---|
Recommendation Scope | Select the type of scope to use in recommendations. Choose from:
|
Recommendation Term | Select the length of the commitment. |