!!!
This repository has been archived as this workbook code has been incorpoate into the Azure Advisor Cost Optimization workbook. If you need to provide any feedback or suggestion, please use the Advisor workbook feedback link to do that.
!!!!
The Azure Hybrid Benefit Workbook provides a detailed overview of Windows VMs, Linux VMs, and Windows VMSS with and without Azure Hybrid Benefit (AHUB) enabled. The workbook also allows you to filter the results by subscription, resource group, or tags.
-
Consider the following least-privilege (minimum) RBAC permissions when deploying the workbook:
- Reader and Workbook Contributor : allows you to import the workbook, view all of the workbook tabs and save the workbook in a resource group.
- Reader : allows you to import the workbook and view all of the workbook tabs.
Use the following link to deploy the AHUB Workbook:
The Azure Hybrid Benefit Workbook allows you to filter the results by subscription, resource group, or tags. This can be useful if you need to focus on specific parts of your environment
Note
The Resource Location parameter is required to load the SKU available in that region. Please note that not all the SKUs are available in all regions, so if you are using some specific SKUs, make sure this parameter is set to the correct location. By default, the parameter will pick any location.
The Resource Location parameter is important to ensure that the workbook displays accurate information about the SKUs available in your region. Be sure to set this parameter correctly to ensure that you are seeing the most relevant information.
In this tab, you can see the list of Windows VMs, Linux VMs and Windows VMSS with and without AHUB.
In this subtab, you can see the list of Windows VMs where AHUB is enabled and where it is not enabled.
The virtual machines (VMs) with less than 8 cores are categorized as Low Priority, while those with 8 or more cores are classified as High Priority. In situations where there are insufficient Azure Hybrid Benefit licenses to cover all the VMs in the environment, it is recommended to prioritize the High Priority VMs.
This workbook also provides you with the view of VMs that have enabled the Hybrid Benefit in the past 7 days. This can be useful for you to monitor and prioritize VMs that you will bring the biggest savings.
You can change the above parameters to see the list of all VMs that have AHUB enabled / disabled. It is also possible to download those results to a CSV file by clicking in the download button at the top right of each table.
In this tab, you can see the list of Linux VMs where AHUB is enabled and where it is not enabled.
In this tab, you can see the list of Windows VMSS where AHUB is enabled and where it is not enabled. For Windows VMSS, the same AHUB prioirtization rule applies. The Virtual Machines Scale Set(VMSS) with less than 8 cores are categorized as Low Priority, while those with 8 or more cores are classified as High Priority. In situations where there are insufficient Azure Hybrid benefit licenses to cover all the VMSS in the environment, it is recommended to prioritize the High Priority VMSS.
In this tab, you can see the list of SQL Databases, SQL Managed Instances and SQL on VMs with and without AHUB.
Ocasionally, some of the Workbook queries can get stuck loading, if that happens, click in the workbook "refresh" button.
We welcome any feedback or suggestions on this workbook! If you find any bugs or have ideas for improvements, please create an issue on this repository and we'll get back to you as soon as we can.
To create an issue, click on the "Issues" tab at the top of this page and then click the green "New Issue" button. Please provide as much detail as possible about the issue or suggestion you have, including any steps to reproduce the problem or implement the suggestion.
We appreciate your help in making this workbook better for everyone!