Azure Excel Definitions

Field

Description

VM Name

Virtual Machine Resource name

ID

Virtual Machine Resource Id

vmId

Specifies the VM unique ID which is a 128-bits identifier that is encoded and stored in all Azure IaaS VMs SMBIOS and can be read using platform BIOS commands.

VM Status

The resource power state information.

VM Size

Specifies the size of the virtual machine. For more information about virtual machine sizes, see Sizes for virtual machines.

Note: The available VM sizes depend on region and availability set.

CPU Cores

The number of cores supported by the virtual machine size.

Memory (MiB)

The amount of memory, in MiB, supported by the virtual machine size.

OS Disk Size (GiB)

The OS disk size, in MiB, allowed by the virtual machine size.

Resource Disk Size (MiB)

The resource disk size, in MiB, allowed by the virtual machine size.

Max Data Disk Count

The maximum number of data disks that can be attached to the virtual machine size.

Total Data Disks Size (GiB)

This is the sum of the disksizeGiB of all the data disks attached to a VM

diskSizeGiB: Specifies the size of an empty data disk in gigabytes. This element can be used to overwrite the size of the disk in a virtual machine image.

This value cannot be larger than 1023 GiB

Image URN

A Marketplace image in Azure has the following attributes:

·       Publisher: The organization that created the image. Examples: Canonical, MicrosoftWindowsServer

·       Offer: The name of a group of related images created by a publisher. Examples: UbuntuServer, WindowsServer

·       SKU: An instance of an offer, such as a major release of a distribution. Examples: 18.04-LTS, 2019-Datacenter

·       Version: The version number of an image SKU. Specifies the version of the platform image or marketplace image used to create the virtual machine. The allowed formats are Major.Minor.Build or 'latest'. Major, Minor, and Build are decimal numbers. Specify 'latest' to use the latest version of an image available at deploy time. Even if you use 'latest', the VM image will not automatically update after deploy time even if a new version becomes available.

·       Exact Version: Specifies in decimal numbers, the version of platform image or marketplace image used to create the virtual machine. This readonly field differs from 'version', only if the value specified in 'version' field is 'latest'.

URN, which combines these values, separated by the colon (:) character: Publisher:Offer:Sku:Version. In a URN, you can replace the version number with "latest", which selects the latest version of the image.

Location

Virtual Machine Resource Location

Virtual Network ID

Virtual Network Resource ID

Virtual Network Name

Virtual Network Resource Name

Network interface ID

Network Interface Resource Id

Network Interface Name

Network Interface Resource Name

Subnet ID

Subnet Resource Id

Subnet Name

Subnet Resource Name

Public IP

Public IP address bound to the IP configuration.

Private IP

Private IP address of the IP configuration.

Availability Set ID

Availability Set Resource Id

Availability Set Name

Availability Set Resource name

Update Domain Count

Update Domain count.

Fault Domain Count

Fault Domain count.

Field

Description

VM Name

Virtual Machine Resource Name

InstanceId

The instance ID of the virtual machine. Each VM in a scale set gets an instance ID that uniquely identifies it. This instance ID is used in the scale set APIs to do operations on a specific VM in the scale set.

The instance IDs may be reused for new instances once old instances are deleted.

ID

Virtual Machine Resource ID

vmId

Azure VM unique ID. Which is a 128-bits identifier that is encoded and stored in all Azure IaaS VMs SMBIOS and can be read using platform BIOS commands.

VM State

The resource power state information.

SKU

Describes a virtual machine scale set sku.

Note: If the new VM SKU is not supported on the hardware the scale set is currently on, you need to deallocate the VMs in the scale set before you modify the SKU name.

OS Disk Size (GiB)

Specifies the size of an empty data disk in gigabytes. This element can be used to overwrite the size of the disk in a virtual machine image.

This value cannot be larger than 1023 GiB

Total Data Disks Size (GiB)

This is the sum of the disksizeGiB of all the data disks attached to a VM

Data Disk: Specifies the size of an empty data disk in gigabytes. This element can be used to overwrite the size of the disk in a virtual machine image.

This value cannot be larger than 1023 GiB

Image URN

A Marketplace image in Azure has the following attributes:

·       Publisher: The organization that created the image. Examples: Canonical, MicrosoftWindowsServer

·       Offer: The name of a group of related images created by a publisher. Examples: UbuntuServer, WindowsServer

·       SKU: An instance of an offer, such as a major release of a distribution. Examples: 18.04-LTS, 2019-Datacenter

·       Version: The version number of an image SKU. Specifies the version of the platform image or marketplace image used to create the virtual machine. The allowed formats are Major.Minor.Build or 'latest'. Major, Minor, and Build are decimal numbers. Specify 'latest' to use the latest version of an image available at deploy time. Even if you use 'latest', the VM image will not automatically update after deploy time even if a new version becomes available.

·       Exact Version: Specifies in decimal numbers, the version of platform image or marketplace image used to create the virtual machine. This readonly field differs from 'version', only if the value specified in 'version' field is 'latest'.

URN, which combines these values, separated by the colon (:) character: Publisher:Offer:Sku:Version. In a URN, you can replace the version number with "latest", which selects the latest version of the image.

Location

Resource Location

Virtual Network ID

Virtual Network Resource ID

Virtual Network Name

Virtual Network Resource Name

Network Interface ID

Network Interface Resource ID

Network Interface Name

Network Interface Resource Name

Subnet ID

Subnet Resource Id

Subnet Name

Subnet Resource Name

Scale Set ID

Scale Set Resource ID

Scale Set Name

Scale Set Resource Name

Field

Description

Scale Set Name

Resource Name

Scale Set ID

Resource ID

SKU

Describes a virtual machine scale set sku. NOTE: If the new VM SKU is not supported on the hardware the scale set is currently on, you need to deallocate the VMs in the scale set before you modify the SKU name.

Scale Set Capacity

Specifies the number of virtual machines in the scale set.

Unique ID

Specifies the ID which uniquely identifies a Virtual Machine Scale Set.

Image URN

A Marketplace image in Azure has the following attributes:

·       Publisher: The organization that created the image. Examples: Canonical, MicrosoftWindowsServer

·       Offer: The name of a group of related images created by a publisher. Examples: UbuntuServer, WindowsServer

·       SKU: An instance of an offer, such as a major release of a distribution. Examples: 18.04-LTS, 2019-Datacenter

·       Version: The version number of an image SKU. Specifies the version of the platform image or marketplace image used to create the virtual machine. The allowed formats are Major.Minor.Build or 'latest'. Major, Minor, and Build are decimal numbers. Specify 'latest' to use the latest version of an image available at deploy time. Even if you use 'latest', the VM image will not automatically update after deploy time even if a new version becomes available.

·       Exact Version: Specifies in decimal numbers, the version of platform image or marketplace image used to create the virtual machine. This readonly field differs from 'version', only if the value specified in 'version' field is 'latest'.

URN, which combines these values, separated by the colon (:) character: Publisher:Offer:Sku:Version. In a URN, you can replace the version number with "latest", which selects the latest version of the image.

Location

Resource Location

Number of VMs

The count of number of VMs in the Scale Set

Field

Description

VM Name

The Resource Name of the VM the Disk is attached to.

VM ID

The Resource ID of the VM the Disk is attached to.

Location

The Location of the VM the Disk is attached to

VM Status

The resource power state information of the VM the Disk is attached to.

VM Size

Specifies the size of the virtual machine the disk is attached to.

Note: The available VM sizes depend on region and availability set.

Disk Name

The Disk Resource Name

Disk ID

The Disk Resource ID

Disk Type

To Display whether this is an OS Disk or a Data Disk

Possible values

·       OS Disk

·       Data Disk

Disk Size (GiB)

The size of the disk in gigabytes. 

Disk IOPS Cap

The number of IOPS allowed for this disk; only settable for UltraSSD disks. One operation can transfer between 4k and 256k bytes.

Disk Throughput Cap (MB/s)

The bandwidth allowed for this disk; only settable for UltraSSD disks. MBps means millions of bytes per second - MB here uses the ISO notation, of powers of 10.

SKU

The disks sku name. Can be Standard_LRS, Premium_LRS, StandardSSD_LRS, or UltraSSD_LRS.

·       Premium_LRS: Premium SSD locally redundant storage. Best for production and performance sensitive workloads.

·       StandardSSD_LRS: Standard SSD locally redundant storage. Best for web servers, lightly used enterprise applications and dev/test.

·       Standard_LRS: Standard HDD locally redundant storage. Best for backup, non-critical, and infrequent access.

·       UltraSSD_LRS: Ultra SSD locally redundant storage. Best for IO-intensive workloads such as SAP HANA, top tier databases (for example, SQL, Oracle), and other transaction-heavy workloads.

Tier

Performance tier of the disk (e.g, P4, S10) as described here: https://azure.microsoft.com/en-us/pricing/details/managed-disks/. Does not apply to Ultra disks.

Disk State

The state of the disk.

Encryption Type

The type of key used to encrypt the data of the disk.

·       EncryptionAtRestWithCustomerKey: Disk is encrypted at rest with Customer managed key that can be changed and revoked by a customer.

·       EncryptionAtRestWithPlatformAndCustomerKeys: Disk is encrypted at rest with 2 layers of encryption. One of the keys is Customer managed and the other key is Platform managed.

·       EncryptionAtRestWithPlatformKey: Disk is encrypted at rest with Platform managed key. It is the default encryption type. This is not a valid encryption type for disk encryption sets.

Field

Description

Disk Name

The Disk Resource Name

Disk ID

The Disk Resource ID

Location

To Display wheather this is an OS Disk or a Data Disk

Possible values

·       OS Disk

·       Data Disk

Disk Size (GiB)

The size of the disk in gigabytes. 

Disk IOPS Cap

The number of IOPS allowed for this disk; only settable for UltraSSD disks. One operation can transfer between 4k and 256k bytes.

Disk Throughput Cap (MB/s)

The bandwidth allowed for this disk; only settable for UltraSSD disks. MBps means millions of bytes per second - MB here uses the ISO notation, of powers of 10.

SKU

The disks sku name. Can be Standard_LRS, Premium_LRS, StandardSSD_LRS, or UltraSSD_LRS.

·       Premium_LRS: Premium SSD locally redundant storage. Best for production and performance sensitive workloads.

·       StandardSSD_LRS: Standard SSD locally redundant storage. Best for web servers, lightly used enterprise applications and dev/test.

·       Standard_LRS: Standard HDD locally redundant storage. Best for backup, non-critical, and infrequent access.

·       UltraSSD_LRS: Ultra SSD locally redundant storage. Best for IO-intensive workloads such as SAP HANA, top tier databases (for example, SQL, Oracle), and other transaction-heavy workloads.

Tier

Performance tier of the disk (e.g, P4, S10) as described here: https://azure.microsoft.com/en-us/pricing/details/managed-disks/. Does not apply to Ultra disks.

Disk State

The state of the disk.

Encryption Type

The type of key used to encrypt the data of the disk.

·       EncryptionAtRestWithCustomerKey: Disk is encrypted at rest with Customer managed key that can be changed and revoked by a customer.

·       EncryptionAtRestWithPlatformAndCustomerKeys: Disk is encrypted at rest with 2 layers of encryption. One of the keys is Customer managed and the other key is Platform managed.

·       EncryptionAtRestWithPlatformKey: Disk is encrypted at rest with Platform managed key. It is the default encryption type. This is not a valid encryption type for disk encryption sets.

Field

Description

VM Name

The Resource Name of the VM the Disk is attached to.

VM ID

The Resource ID of the VM the Disk is attached to.

Location

The Location of the VM the Disk is attached to

VM Size

The resource power state information of the VM the Disk is attached to.

VM Status

Specifies the size of the virtual machine the disk is attached to.

Note: The available VM sizes depend on region and availability set.

Network Interface ID

Network Interface Resource ID

Network Interface Name

Network Interface Resource Name

Virtual Network ID

Virtual Network Resource ID

Virtual Network Name

Virtual Network Resource Name

Subnet ID

Subnet Resource ID

Subnet Name

Subnet Resource Name

Public IP

Public IP address bound to the IP configuration.

Private IP

Private IP address of the IP configuration.

Primary

Whether this is a primary customer address on the network interface.

Field

Description

VM Name

The Resource Name of the VM the Disk is attached to.

VM ID

The Resource ID of the VM the Disk is attached to.

VM State

The resource power state information of the VM the Disk is attached to.

Load Balancer Name

Resource Name

Load Balancer ID

Resource ID

SKU

Name of a load balancer SKU.

Location

Load Balancer Location

Backend Pool Name

The name of the resource that is unique within the set of backend address pools used by the load balancer. This name can be used to access the resource.

Backend pool ID

Resource ID.

Public IP

Public IP address bound to the IP configuration.

Attached to Scale Set VM ?

Whether the VM connected to the Load balancer is a Scale Set VM or an Azure VM.

Field

Description

Storage Account Name

Resource Name

Storage Account ID

Resource ID

Location

Resource Location

Kind

Kind of resource.

SKU

Storage Account SKU name

Storage Account Used Capacity (MiB)

The amount of storage used by the storage account. For standard storage accounts, it's the sum of capacity used by blob, table, file, and queue. For premium storage accounts and Blob storage accounts, it is the same as BlobCapacity or FileCapacity.

Blob Count

The number of blob objects stored in the storage account.

Blob Used Capacity (MB)

The amount of storage used by the storage account’s Blob service in megabytes.

Blob Container Count

The number of containers in the storage account

File Count

The number of files in the storage account.

File Share Capacity Quota (MiB)

The upper limit on the amount of storage that can be used by Azure Files Service in megabytes.

File Used Capacity (MiB)

The amount of File storage used by the storage account in megabytes.

File Share Count

The number of file shares in the storage account.

File Share Snapshot Count

The number of snapshots present on the share in storage account’s Files Service.

File Share Snapshot Size (MiB)

The amount of storage used by the snapshots in storage account’s File service in megabytes.

Table Count

The number of tables in the storage account.

Table Used Capacity (MiB)

The amount of Table storage used by the storage account.

Table Entity Count

The number of table entities in the storage account.

Field

Description

Server Name

Server Resource Name

Server ID

Server Resource ID

Server State

The state of the server

Location

Server Resource location.

Server Kind

Kind of sql server. This is metadata used for the Azure portal experience.

Database Name

Database Resource Name

ID

Database Resource ID

Database Kind

Kind of database. This is metadata used for the Azure portal experience.

databaseId

The ID of the database.

Database Max Size (GiB)

The max size of the database expressed in Gigabytes.

Database Status

The status of the database.

Default Secondary Location

The default secondary region for this database.

Edition

The database edition

Service Objective

The service level Objective of the database

Elastic Pool Name

The resource name of the Elastic pool the database belongs to.

Field

Description

Elastic Pool Name

Elastic Pool Resource Name

ID

Elastic Pool Resource ID

State

The state of the elastic pool.

·       Creating

·       Disabled

·       Ready

Location

Elastic Pool Resource location.

Edition

The Elastic Pool Edition

DTU

The requested DTU for the pool if available.

Max DTU

The requested max DTU per database if available.

Min DTU

The requested min DTU per database if available.

Storage(GB)

The requested storage limit for the pool in GB if available.

Field

Description

Managed Instance Name

Managed Instance Resource Name

ID

Managed Instance Resource ID

State

The state of the managed instance.

Location

Managed Instance location

SKU

An ARM Resource SKU name

Tier

he tier or edition of the particular SKU, e.g. Basic, Premium.

vCores

The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.

Storage Size (GiB)

Storage size in GiB. Minimum value: 32. Maximum value: 8192. Increments of 32 GiB allowed only.

Virtual Network Name

Virtual Network resource name for the managed instance.

Subnet Name

Subnet resource name for the managed instance.

Subnet ID

Subnet resource ID for the managed instance.

Instance Pool Name

The name of the instance pool this managed server belongs to.

Instance Pool ID

The Id of the instance pool this managed server belongs to.