Find Amortized Cost for Azure resources via PowerShell

Question

Find Amortized Cost for Azure resources via PowerShell

olegarr 131

Hello:

I am trying to collect cost for Azure resources via Powershell. I have a script, but recently realized I am collecting actual, but not amortized cost. That means if any of my resources covered by Reserve Instance and/or Savings Plan I do not see real cost.

This is what I am using now, but again, it's collecting only actual cost, but I need amortized:

$ResourceConsumption = Get-AzConsumptionUsageDetail -StartDate $startDate -EndDate $endDate -InstanceId $resource.ID

Is it possible (and how) to collect Amortized cost for Azure resources via PowerShell?

Thank you!

olegarr 131 Reputation points

2025-06-16T14:23:10.06+00:00

Can someone help, please? Assuming it's possible :-)

1 answer

Your answer

olegarr 131 Reputation points

2025-06-16T14:23:10.06+00:00

Can someone help, please? Assuming it's possible :-)

Answer 1

MotoX80 36,181

I try to answer PS questions, but I don't use Azure and don't have a clue about amortized costs.

I did this search.

https://www.bing.com/search?q=azure%20amortized%20costs%20powershell%20example

CoPilot returned this script. I see that there is a IncludeAmortizedCost switch. Did you see that? Does this help?

# Connect to Azure account
Connect-AzAccount
# Set the subscription context (replace with your Subscription ID)
$SubscriptionId = "your-subscription-id"
Set-AzContext -SubscriptionId $SubscriptionId
# Define the time range for the cost query
$StartDate = (Get-Date).AddDays(-30).ToString("yyyy-MM-dd")  # Last 30 days
$EndDate = (Get-Date).ToString("yyyy-MM-dd")
# Query the cost details with amortized cost enabled
$CostDetails = Get-AzConsumptionUsageDetail -StartDate $StartDate -EndDate $EndDate -IncludeAmortizedCost
# Display the results
$CostDetails | Select-Object ResourceName, ResourceGroupName, AmortizedCost, UsageStart, UsageEnd | Format-Table

Rich Matheisen 47,886 Reputation points

2025-06-16T15:31:39.55+00:00
@MotoX80

CoPilot sometimes thinks it can do something, but I've seen it (quite a few times) conjure up parameters that don't exist. I don't see the "IncludeAmortizedCost" in the online help for that cmdlet.

Get-AzConsumptionUsageDetail [-BillingPeriodName <String>] [-Expand <String>] [-IncludeMeterDetails] [-IncludeAdditionalProperties] [-StartDate <DateTime>] [-EndDate <DateTime>] [-ResourceGroup <String>] [-InstanceName <String>] [-InstanceId <String>] [-Tag <String>] [-MaxCount <Int32>] [-Top <Int32>] [-DefaultProfile <IAzureContextContainer>] [<CommonParameters>]

I'd bet that if you followed up CoPilots answer with a question asking if that parameter actually exists that it would reply with something like "You're absolutely right . . ." or "Good catch" or "Thanks for your attention to detail". Sometimes it will then provide a usable answer to your follow-up. Sometimes it may take a few more tries at refining the question. Sometimes it just can't provide a workable answer.I'm pretty sure that "amortized costs" related to a service (Azure) doesn't refer to the reduction of an assets value over time. Given the OPs "Reserve Instance and/or Savings Plan" part of the question it's probably just the average cost (over whatever time period) of the "up-front" cost. IOW, instead of seeing a big balloon cost in the first time period you see just the code between the previous and current period.

Since I don't use Azure, either, the above is just a guess on my part (not the part about CoPilot providing a non-existent parameter, though!)

I'd guess it has to do more with the average cost of some aspects of using the service. Of course, both of those ae just guesses on my part.

MotoX80 36,181

I flunked out of Accounting 101 in college. Kept falling asleep out of boredom.

So when I first did that search, I misspelled Powershell and it gave me a different script. Before I posted the Bing link, I corrected it, and CoPilot gave me the script with that switch. It looked cleaner, so that's what I posted. Must be another CoPilot "feature".

Here's the first script.

@olegarr I have no way to test this.

Here’s an example of how you can use PowerShell to retrieve amortized costs from Azure using the Azure Cost Management API. This script assumes you have the necessary permissions and have installed the Azure PowerShell module.
Example: Retrieve Amortized Costs
Copy the code
# Login to Azure
Connect-AzAccount
# Set the subscription context
$SubscriptionId = "<Your-Subscription-ID>"
Set-AzContext -SubscriptionId $SubscriptionId
# Define the date range for the cost query
$StartDate = (Get-Date).AddDays(-30).ToString("yyyy-MM-dd")  # Last 30 days
$EndDate = (Get-Date).ToString("yyyy-MM-dd")                # Today
# Create the query body for amortized costs
$QueryBody = @{
    type = "Usage"
    timeframe = "Custom"
    timePeriod = @{
        from = $StartDate
        to   = $EndDate
    }
    dataset = @{
        granularity = "Daily"
        aggregation = @{
            totalCost = @{
                name = "Cost"
                function = "Sum"
            }
        }
        grouping = @(
            @{
                type = "Dimension"
                name = "ResourceGroup"
            }
        )
    }
} | ConvertTo-Json -Depth 10
# Call the Azure Cost Management API
$CostManagementEndpoint = "https://management.azure.com/subscriptions/$SubscriptionId/providers/Microsoft.CostManagement/query?api-version=2023-03-01"
$AccessToken = (Get-AzAccessToken -ResourceUrl "https://management.azure.com").Token
# Make the API request
$response = Invoke-RestMethod -Uri $CostManagementEndpoint -Method Post -Headers @{
    Authorization = "Bearer $AccessToken"
    "Content-Type" = "application/json"
} -Body $QueryBody
# Parse and display the results
$response.properties.rows | ForEach-Object {
    [PSCustomObject]@{
        Date          = $_[0]
        ResourceGroup = $_[1]
        AmortizedCost = $_[2]
    }
}
Key Notes:
Amortized Costs: Azure Cost Management API provides amortized costs, which distribute reservation and savings plan benefits across resources.
Permissions: Ensure you have the necessary permissions to access cost data.
API Version: The script uses the 2023-03-01 API version, which supports amortized costs.
This script retrieves daily amortized costs grouped by resource group for the last 30 days. Adjust the query body as needed for your specific requirements.

Share via

Find Amortized Cost for Azure resources via PowerShell

1 answer

Your answer