Bindplane

The Bindplane Developer Hub

Welcome to the Bindplane developer hub. You'll find comprehensive guides and documentation to help you start working with Bindplane as quickly as possible, as well as support if you get stuck. Let's jump right in!

Microsoft Azure Compute

Least Privileged User

Use the Azure CLI client to find the subscription ID and Tenant ID from your account list. Then create a custom RBAC role using the JSON provided by adding your subscription ID and renaming to azure.json. Finally, create an Active Directory Service Principal and assign the role to it.

Creating custom roles using the Azure CLI:
https://docs.microsoft.com/en-us/azure/role-based-access-control/custom-roles

Assigning roles using the Azure CLI:
https://docs.microsoft.com/en-us/azure/role-based-access-control/role-assignments-portal

{
  "Name": "Blue Medora Microsoft Azure Monitoring",
  "Description": "Monitor Microsoft Azure Environment by Blue Medora",
  "Actions": [
    "Microsoft.Compute/virtualMachines/*/read",
    "Microsoft.Sql/servers/*/read",
    "Microsoft.Storage/*/read",
    "Microsoft.Insights/metrics/*/read",
    "Microsoft.Authorization/*/read",
    "Microsoft.Resources/subscriptions/resourceGroups/read"
  ],
  "AssignableScopes": [
    "/subscriptions/[Subscription ID]"
  ]
}

Connection Parameters

Name
Required?
Description

Subscription ID

Required

GUID Subscription ID

Tenant ID

Required

GUID Tenant ID (also known as Directory ID)

Client ID

Required

GUID Client ID (also known as Application ID)

Secret

Required

The Secret (also known as Key) corresponding to the Client ID

Mode

Determines the focus of collection

Resource Group

If present, only collect resources which are present in the given Azure Resource Group

Max Threads

Determines the number of threads used for collection

Interval Length

The aggregation period, in minutes, for each metric

Intervals

Specifies how many intervals to request. Metrics are taken from the latest interval that returns data

Metrics

Elastic Pool

Name
Description

CPU Usage (%)

Percentage of CPU in use by the Elastic Pool.

Data IO (%)

Physical data read percentage of the Elastic Pool.

Database Count

Number of databases used by the Elastic Pool.

DTU Consumption (%)

Percentage of Database Transaction Units consumed by the Elastic Pool.

Elastic DTU Limit

Elastic Database Transaction Unit limit for the Elastic Pool.

Elastic DTU Used

Elastic Database Transaction Units used by the Elastic Pool.

In-Memory OLTP Storage (%)

Percentage of in-memory Online Transaction Processing storage in use by the Elastic Pool

Log IO (%)

Log write percentage of the Elastic Pool.

Maximum DTU

Maximum observed Database Transaction Unit of the Elastic Pool.

Minimum DTU

Minimum observed Database Transaction Unit of the Elastic Pool.

Name

Name of the Elastic Pool.

Server

Name of the SQL Server which is hosting the Elastic Pool.

Sessions (%)

Percentage of concurrent sessions in use. The maximum is determined by the service tier.

State

Current state of the Elastic Pool.

Storage (Megabytes)

Storage size, in megabytes, of the Elastic Pool.

Storage Limit (Bytes)

Storage limit, in bytes, of the Elastic Pool.

Storage Usage (%)

Percentage of storage in use by the Elastic Pool.

Storage Used (Bytes)

Storage used, in bytes, by the Elastic Pool.

Workers (%)

Percentage of concurrent workers (requests) which are running. The maximum is determined by the service tier.

Resource Group

Name
Description

Name

Name of the Resource Group.

SQL Data Warehouse

Name
Description

Blocked by Firewall (Connections)

Number of connections to the SQL Data Warehouse which are blocked by the firewall.

CPU Usage (%)

Percentage of CPU in use by the SQL Data Warehouse.

Data IO (%)

Physical data read percentage of the SQL Data Warehouse.

Database Size (Bytes)

The total size, in bytes, of the SQL Data Warehouse.

DWU Consumption (%)

Percentage of Data Warehouse Units consumed by the SQL Data Warehouse.

DWU Limit

Data Warehouse Units limit of the SQL Data Warehouse.

DWU Used

Data Warehouse Units used by the SQL Data Warehouse.

Failed Connections (Connections)

Number of failed connections to the SQL Data Warehouse.

Name

Name of the SQL Data Warehouse

Server

Name of the SQL Server hosting the SQL Data Warehouse.

Service Level Objective

Service level objective of the SQL Database.

Status

Status of the SQL Database.

Successful Connections (Connections)

Number of successful connections to the SQL Data Warehouse.

SQL Database

Name
Description

Active Time Ratio

Ratio of time the SQL Database is active.

Average DTU

Average observed Database Transaction Units of the SQL Database.

Blocked by Firewall (Connections)

Number of attempted connections to the SQL Database which were blocked by the firewall.

CPU Usage (%)

Percentage of CPU in use by the SQL Database.

Current Service Level Objective

Current service level objective of the SQL Database.

Data IO (%)

Physical data read percentage of the SQL Database.

Database Size (Bytes)

Total size, in bytes, of the SQL Database.

Database Size Usage (%)

Percentage of storage being used by the SQL Database.

Deadlocks

Number of deadlocks in the SQL Database.

DTU Consumption (%)

Percentage of Database Transaction Units consumed by the SQL Database.

DTU Limit

Database Transaction Unit limit of the SQL Database.

DTU Used

Database Transaction Units used by the SQL Database.

Failed Connections (Connections)

Number of failed connections to the SQL Database.

In-Memory OLTP Storage (%)

Percentage of In-Memory Online Transaction Processing storage in use by the SQL Database

Log IO (%)

Log write percentage of the SQL Database.

Max Database Size (Gigabytes)

Maximum size, in gigabytes, of the SQL Database.

Maximum DTU

Maximum observed Database Transaction Units of the SQL Database.

Minimum DTU

Minimum observed Database Transaction Units of the SQL Database.

Name

Name of the SQL Database.

Server

Name of the SQL Server on which the SQL Database is hosted.

Service Tier Name

Name of the current service tier of the SQL Database.

Sessions (%)

Percentage of concurrent sessions in use. The maximum is determined by the service tier.

Status

Current status of the SQL Database.

Successful Connections (Connections)

Number of successful connections to the SQL Database.

Workers (%)

Percentage of concurrent workers (requests) which are running. The maximum is determined by the service tier.

SQL Server

Name
Description

CPU Usage (%)

Average CPU usage by databases on the SQL Server.

Data IO (%)

Average physical data read percentage of databases on the SQL Server.

Database Size (Bytes)

Average size in bytes of databases on the SQL Server.

DTU Used

Average Database Transaction Units used by databases on the SQL Server.

In-Memory OLTP Storage (%)

Average percentage of In-Memory Online Transaction Processing storage in use by databases on the SQL Server.

Log IO (%)

Average log write percentage of databases on the SQL Server.

Name

Name of the SQL Server.

Sessions (%)

Percentage of concurrent sessions in use. The maximum is determined by the service tier.

Workers (%)

Percentage of concurrent workers (requests) which are running. The maximum is determined by the service tier.

Virtual Machine

Name
Description

CPU Usage (%)

Percentage of CPU in use by the Virtual Machine.

Disk Read (Bytes per Second)

Bytes per second read from disk by the Virtual Machine.

Disk Read Operations (Operations per Second)

Rate of disk read operations performed by the Virtual Machine.

Disk Write (Bytes per Second)

Bytes per second written to disk by the Virtual Machine.

Disk Write Operations (Operations per Second)

Rate of disk write operations performed by the Virtual Machine.

Fully Qualified Domain Names

List of fully qualified domain names of the Virtual Machine.

ID

Resource ID of the Virtual Machine.

IP Addresses

List of public IP addresses of the Virtual Machine.

Location

Location of the Virtual Machine.

Network In (Bytes per Second)

Bytes per second received by the Virtual Machine.

Network Out (Bytes per Second)

Bytes per second sent by the Virtual Machine.

OS Type

Type of Operating System running on the Virtual Machine.

OS Virtual Hard Disk

URI of the Virtual Hard Disk used by the Virtual Machine.

Power State

Power state of the Virtual Machine.

Private IP Addresses

List of private IP addresses of the Virtual Machine.

Provisioning State

Provisioning state of the Virtual Machine.

Resource Group

Resource group of the Virtual Machine.

Service Tier

Service Tier of the Virtual Machine.

Subnet Prefixes

List of subnet prefixes of the Virtual Machine.

Subnets

List of subnets of the Virtual Machine.

Tags

The tags assigned to the Virtual Machine in string representation of a JSON object.