Azure plugin

Visit our website to see the data that you can access if you use this plugin to add the data source to SquaredUp:

Azure

Monitor your Azure environment, VMs, Functions, Cost and more.

How to add an Azure data source

  1. To add a data source click on the + next to Data Sources on the left-hand menu in SquaredUp. Search for the data source and click on it to open the Configure data source page.

  2. Display Name:

    Enter a name for your data source. This helps you to identify this data source in the list of your data sources.

  3. Authentication:

    You have two options to choose from for authentication, using the Sign-in button or entering Explicit application credentials:

    Sign-in button

    This will allow the Azure data source instance to access Azure from the point of view of a given user account. This gives less granular control over the permissions the data source runs with. This is not ideal from a "least privilege" point of view, but can be useful when experimenting with the data source against non-production environments. For production environments, using explicit application credentials, as described below, is recommended.

    After you click the Sign in with Microsoft button you can choose to login as an administrator of the target tenant or a non-administrator:

    See Microsoft: Manage consent to applications and evaluate consent requests

    Explicit application credentials

    For more granular control over the permissions the data source runs with, you may create a specific application for this purpose with only the Reader role on the areas of your tenant you wish.

  4. Install Sample Dashboards:

    Select whether you would like to install sample dashboards with the data source. By default, this is set to on.

  5. Optionally, select whether you would like to restrict access to this data source instance. By default, restricted access is set to off.

  6. Click Test and add to validate the data source configuration.

    You can also add a data source from Settings > Data Sources > Add data source, but sample dashboards are not added when using this method.

Using the Azure data streams

There are several data streams available for this data source:

Application Insights Query

Allows you to run an Application Insights KQL query. This data stream calls the api.applicationinsights.io endpoint, and allows you to enter a custom application insights KQL query.

  1. Scope to a Azure workspace, object that supports KQL queries, or the data source instance itself.

    If you scope to an Azure Application Insights workspace, the name of the data stream will be KQL Query. If you scope to an Azure object or the data source itself, the name of the data stream will be Application Insights Query.

  2. Depending on what you have scoped to, select Application Insights Query or KQL Query from the data stream list.

  3. For a Application Insights Query select an Application Insights Workspace Name from the dropdown. This the name of the workspace that you wish to query. You will not need to select a name if you have already scoped to a workspace.

  4. KQL Query:

    Mustache parameters are only supported if you have scoped to an Azure object and selected the Application Insights Query. Mustache parameters are not supported if you have scoped to a workspace or the data source instance itself.

  5. Optionally, enter a Timeframe, for example: PT12H.

    You must also tick Ignore dashboard timeframe if you want to use the custom timeframe you have entered here.

  6. Optionally, enter an API Version, for example: 2017-10-01.

    If an API Version is specified, the data stream will call the endpoint https://management.azure.com/{{workspace ID}}/query.

Budget Overview

Scope

  • For an individual budget

  • For a scope that a budget can apply to:

    • Subscription

    • Resource Group

    • Billing Profile

    • etc.

Cost

This data stream gives you the daily cost over the timeframe you selected for your objects in your scope. You are able to get the total cost of the timeframe for the objects in your scope by grouping them together.

Cost (configurable)

This data stream calls the Azure Cost Management query Microsoft: Query - Usage - REST API (Azure Cost Management).

  1. Select the configurableCost data stream (indicated by the Configurable data stream cog). Click Next to go to the Objects tab.

  2. On the Objects tab scope to Azure subscriptions, resource groups or management groups. Click Next to go to the Query tab.

  3. Optionally, select a Group By entry from the dropdown. You can group the data by any dimension/s, for example ResourceGroupName.

  4. Optionally, select a Filter from the dropdown. By default the data is not being filtered. Create a filter if you want to filter data to a specific type of Resources.

  5. Select Granularity from the dropdown. Available options are: Daily and None. Daily granularity is useful for when you want to see cost over time in the form of a line graph. None should be selected if you want to show the total cost in the form of donuts and bar charts.

Cost (Amortized)

  • Includes costs that are paid up front for the year/month/etc.

  • If $365 is paid up front, $1 per day is added to the cost to give a more representative view of what something is costing the organization.

Cost (Invoice)

  • Similar to the 'Invoice details' cost view in the Azure portal

  • Configurable

    • Amortized or Actual cost

Cost (Service)

  • Cost broken down by Service/Service Family

  • Configurable

    • Amortized or Actual cost

Cost (Location)

  • Cost broken down by Location

  • Configurable

    • Amortized or Actual cost

Cost (By Tag)

  • Cost broken down by tag

  • Configurable

    • Group by specific tag key

    • (Optional) Filter by tag value

    • Amortized or Actual cost

Cost with forecast

For the Cost - Forecast data stream to work you will need to set it to a date in the future, for example: This Month, This Quarter, This Year. The line graph will show 2 lines:

  • Daily cost over the selected time as Active cost up to today’s date.

  • Forecast line for the rest of the period.

Cost with forecast (accumulated)

Targets each node in the scope and shows actual and forecast accumulated cost over time. Each day is summary of the total cost so far. Set this data stream to a date in the future like: This Month, This Quarter, This Year. Shows the Actual cost for the timeline in the past and Forecast for the timeline in the future.

Invoice History

Scope

  • Billing Account

  • Billing Profile

The breakdown of what a user has been charged by Microsoft

  • Tax break down

  • Free credit deductions

  • etc.

Invoice Payment History

Scope

  • Billing Account

  • Billing Profile

The breakdown of what a user has paid to Microsoft

  • The type of payment

  • Installments

Log Analytics Query

Allows you to run a Log Analytics KQL query. This data stream calls the api.loganalytics.io endpoint, and allows you to enter a custom log analytics KQL query.

  1. Scope to a Azure workspace, object that supports KQL queries, or the data source instance itself.

    If you scope to an Azure Log Analytics workspace, the name of the data stream will be KQL Query. If you scope to an Azure object or the data source itself, the name of the data stream will be Log Analytics Query.

  2. Depending on what you have scoped to, select Log Analytics Query or KQL Query from the data stream list.

  3. For a Log Analytics Query select a Log Analytics Workspace Name from the dropdown. This is the name of the workspace that you wish to query. You will then have the option to use a Saved query or enter a Custom KQL query.

  4. Custom KQL Query:

    Mustache parameters are only supported if you have scoped to an Azure object and selected the + Log Analytics Query. Mustache parameters are not supported if you have scoped to a workspace or the data source instance itself.

  5. Optionally, enter a Timeframe, for example: PT12H.

    You must also tick Ignore dashboard timeframe if you want to use the custom timeframe you have entered here.

  6. Optionally, enter an API Version, for example: 2017-10-01.

    If an API Version is specified, the data stream will call the endpoint https://management.azure.com/{{workspace ID}}/query.

Monitor Metric

Queries Azure Metrics. This data stream calls the /{{sourceId}}/providers/microsoft.insights/metrics endpoint, and allows you to select a custom metric name.

  1. Scope to an Azure object.

  2. Select Monitor Metric from the data stream list.

  3. Select a Metric Name from the dropdown, for example: AverageResponseTime.

    Any data stream you have created can later be edited from Settings > Data Streams. For example, you may wish to change the shape for timeseries metrics from number to milliseconds.

Reservation Normalized Hours History

Scope

  • Reservation

  • Billing Profile

  • Billing Account

Gets a historical summary of how a reservation has been applied to other resources.

  • e.g. what virtual machine has this reduced the cost of

Reservation Percent Utilization History

Scope

  • Reservation

  • Billing Profile

  • Billing Account

Gets a historical summary of how effectively a reservation (or group of reservations) is being used.

Reservation Recommendations

Scope

  • Subscription

  • Resource Group

  • Billing Profile

Get recommendations for how to save costs using recommendations.

Configurable

  • Scope

    • A single use reservation or a shared reservation

  • Resource type

    • Virtual Machine

    • Database

    • etc.

Savings Plan Percent Utilization History

Similar to Reservation Percent Utilization History.

Savings Plan Recommendations

Similar to Reservation Recommendations, with the main difference being that savings plans only support Compute so you don’t get a choice of type.

Configurable

  • Scope

    • A single use plan or a shared plan

  • Term

    • A 1 year or a 3 year plan

Subscription Charges Overview

Scope

  • For Subscriptions when billing types are imported

  • For ‘Billing types’ that support them

    • Billing Accounts

    • Billing Profiles

    • Invoice Sections

    • Customers

Gets a quick now and next view of charges last month and this month

  • Intended to be a faster and more reliable replacement to cost where a 'total cost' is required.

Transactions

Scope

  • Billing Accounts

  • Billing Profiles

  • Invoice Sections

  • Customers

The breakdown of charges that have (or will go into) an invoice.

Utilization Summary

Scope

  • Reservations

  • Savings Plans

Gets a summary of how effectively you are currently using your reservations.


Have more questions or facing an issue?