microsoft / microsoft/finops-toolkit

Add a query for centrally managed Azure Hybrid Benefit for SQL Server

Open
#1,208 0 comments 1 reaction 1 assignee View on GitHub

@arthurclares is already working on this.

Since Dec 13, 2024.

Tool: Optimization workbook Tool: Workbooks Type: Feature 💎
Dominant language
PowerShell
Stars
603
Forks
248
Avg merge
7d 11h
Merged PRs (30d)
11

Description

📝 Scenario

As a FinOps practicioner, I need to use the COW as a central place to manage my AHB benefits. Today, it doesn't cover licenses enabled through Centrally Managed AHB.

https://learn.microsoft.com/en-us/azure/cost-management-billing/scope-level/create-sql-license-assignments#track-assigned-license-use

https://learn.microsoft.com/en-us/azure/cost-management-billing/scope-level/transition-existing

https://learn.microsoft.com/en-us/azure/cost-management-billing/scope-level/overview-azure-hybrid-benefit-scope

Centrally managing Azure Hybrid Benefit at a scope-level covers the following common Azure SQL resources:

SQL Databases
SQL Managed Instances
SQL Elastic Pools
SQL Server on Azure VMs

💎 Solution

Add a query to the AHB tab to check for SQL VMs where the benefit was enabled through Centrally Managed AHB .

📋 Tasks

### Required tasks
- [ ] Add the query
- [ ] Run tests
- [ ] Update the Advisor workbook
### Stretch goals
- [ ] TODO: Add Arc resources

ℹ️ Additional context

TODO: Add any other context or screenshots about the change request, including alternative solutions you considered and why you ruled them out.

🙋‍♀️ Ask for the community

We could use your help:

  1. Please vote this issue up (👍) to prioritize it.
  2. Leave comments to help us solidify the vision.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.