Q. Can I extract usage information from Azure subscriptions using PowerShell?

Q. Can I extract usage information from Azure subscriptions using PowerShell?

Q. Can I extract usage information from Azure subscriptions using PowerShell?

A. The Azure module contains a number of cmdlets to fetch usage data, specifically Get-UsageAggregates and Get-UsageMetrics. Below is an example of fetching the usage data. Change the dates and subscription ID.

$reportStartTime = "2015-08-01"
$reportEndTime = "2015-08-31"
$filename = ".\usageData-$reportStartTime-$reportEndTime.csv"

$granularity = "Daily" # Also could be Hourly
$showDetails = $true
$appendFile = $false

$subscriptionID = '466c1a5d-e93b-4138-91a5-670daf44b0f8'

$continuationToken = ""

Do { 

    $usageData = Get-UsageAggregates `
        -ReportedStartTime $reportStartTime `
        -ReportedEndTime $reportEndTime `
        -AggregationGranularity $granularity `
        -ShowDetails:$showDetails `
        -ContinuationToken $continuationToken

    $usageData.UsageAggregations.Properties | 
        Select-Object `
            UsageStartTime, `
            UsageEndTime, `
            @{n='SubscriptionId';e={$subscriptionId}}, `
            MeterCategory, `
            MeterId, `
            MeterName, `
            MeterSubCategory, `
            MeterRegion, `
            Unit, `
            Quantity, `
            @{n='Project';e={$_.InfoFields.Project}}, `
            InstanceData | 
        Export-Csv `
            -Append:$appendFile `
            -NoTypeInformation:$true `
            -Path $filename

    if ($usageData.NextLink) 
    {
        $continuationToken = `
        [System.Web.HttpUtility]::`
        UrlDecode($usageData.NextLink.Split("=")[-1])
    }
    else 
    {
        $continuationToken = ""
    }
    $appendFile = $true

} until (!$continuationToken)

Once executed open the created CSV which shows all the usage data.

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish