Azure Resource Graph to retrieve Cost Recommendation with Resource ID and Part Number for both Current and Target SKU

This came up for us recently as well, and the important thing to know is that Azure Resource Graph simply does not store EA part numbers anywhere. Advisor recommendations will give you the resource ID, the current SKU, and the target SKU, but the commercial metadata (including EA part numbers or price list IDs) is not exposed in Resource Graph at all.

Because of that, there’s nothing you can “join” inside ARG to get the part numbers directly.

If you need EA pricing matched to Advisor’s recommendations, the only workable method is:

Query Advisor via Resource Graph to get • resourceId • currentSku • recommendedSku

Export your EA price sheet or call the PriceSheet / RateCard API.

Do the SKU --> EA part number mapping outside Azure using that price sheet.

Azure does not return EA part numbers through Advisor, Resource Graph, or the SKU metadata endpoints, so the join you’re trying to do isn’t possible inside ARG.

1. Run this KQL from Azure Resource Graph

This gives you the SKUs Azure Advisor recommends:

advisorresources
| where type == "microsoft.advisor/recommendations"
| project resourceId,
          currentSku = properties.extendedProperties.currentSku,
          recommendedSku = properties.extendedProperties.recommendedSku

Save the output as json or csv; advisor.json or advisor.csv.

2. Download your EA Price Sheet

Export the EA price sheet from the EA portal (CSV). This file contains the part numbers, SKUs, and EA pricing.

Save it as ea-prices.csv.

3. Run this PowerShell script to join them

This script does exactly what you need: load Advisor SKUs --> load EA sheet --> match them --> output both part numbers and SKUs.

# Load Advisor data export from Resource Graph
$advisor = Import-Csv ".\advisor.csv"

# Load EA price sheet containing Part Numbers
$ea = Import-Csv ".\ea-prices.csv"

$results = foreach ($row in $advisor) {

    # Match current SKU
    $current = $ea | Where-Object { $_.SkuId -eq $row.currentSku }

    # Match recommended SKU
    $recommended = $ea | Where-Object { $_.SkuId -eq $row.recommendedSku }

    [PSCustomObject]@{
        ResourceId             = $row.resourceId
        CurrentSku             = $row.currentSku
        CurrentPartNumber      = $current.PartNumber
        RecommendedSku         = $row.recommendedSku
        RecommendedPartNumber  = $recommended.PartNumber
    }
}

$results | Export-Csv ".\advisor-with-partnumbers.csv" -NoTypeInformation
Write-Host "Done. Output saved to advisor-with-partnumbers.csv"

Hello 51621659,

Here's what you can do:

1. Access Cost Recommendations: Start by accessing Azure Advisor. You’ll need to navigate to the Cost tab in Azure Advisor after signing in to the Azure portal. Ensure you have active virtual machines with at least 14 days of activity and appropriate read access on the subscription or resource group level.
2. Gather Cost Data: Once you're in the Azure Advisor's Cost section, you can view the cost recommendations related to your resources. This will give you insights into potential savings and help you identify which resources might be underutilized.
3. Use Resource Graph Queries: To specifically link Azure Advisor recommendations to resource IDs and part numbers, consider using Azure Resource Graph queries. A sample query might look something like this:

AdvisorResources
| where type == 'microsoft.advisor/recommendations'
| where properties.category == 'Cost'
| extend resources = tostring(properties.resourceMetadata.resourceId)
| project resources, properties.shortDescription.solution

1. Understand Enterprise Pricing: For EA pricing, ensure that the quantities and recommendations shown in Azure Advisor take into account any discounts that apply to your agreement. You may also want to look into the Azure pricing calculator for a more tailored estimate based on your usage.
2. Further Exploration: If you're looking to join this data with specific part numbers, you'd likely need to perform additional queries or look at the pricing documentation for the relevant resources you're using.

References:

• Azure Advisor - Cost Recommendations
• Azure Resource Graph Overview
• Azure Pricing Calculator

Hope this helps you get started on optimizing your Azure spend! If you have further questions or need more details on specific aspects, feel free to reach out! 

 Let us know if you have further questions?

Hello Adam,

I just ran but the EA Price SkuID is not equal to the Recommendation Sku's.

EA Price SkuID 0035

Recommendation is a totally different format: Standard D4s v4

Thank you

Hello 51621659,

Could you please let us know whether you got the chance to look into the answer we have provided?