powershell - Azure EA 订阅 - 计费报告

Question

尝试通过 powershell 获取 azure 计费报告，在开始之前它会要求输入注册号和访问 key ，注册 key 可以从 https://ea.azure.com 找到，但是访问 key 没有在任何地方明确提及，如果可以从存储帐户获取，那么我有超过20个存储帐户用于不同的资源，

任何致力于通过 powershell 检索计费 EA 详细信息的建议。

Answer 1

我希望您浏览一下Gordon Byers

示例:

$baseurl = "https://ea.azure.com/rest/"
$enrollmentNo ="100"
$accesskey ="eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6Il92ZHZieDJYRUkyb2l5N09abVpVelZGelM2TSJ9.eyJpc3MiOiJlYS5taWNyb3NvZnRhenVyZS5jb20iLCJhdWQiOiJjbGllbnQuZWEubWljcm9zb2Z0YXp1cmUuY29tIiwibmJmIjoxNDI4NDYwOTgxLCJleHAiOjE0NDQyNzIxODEsIkVucm9sbG1lbnROdW1iZXIiOiIxMDAiLCJJZCI6Ijk3OGQ5MGRjLTEyZjUtNDVmZC1hZWY2LWNiZTQ0ZDE0NmFmNiIsIlJlcG9ydFZpZXciOiJTeXN0ZW0iLCJQYXJ0bmVySWQiOiIifQ.QEHdbHmUz4TXO8Ljhn8ktnt5m7rHO0hsRrDLTvoQP4luL-8gy98CywFi2OByhfPL6UY5Vx8MYtwTQhMbzefS6Cd8hNopP74AL1ENLT-WGn42JG2mWesizIuN1QHV-obZR5rKDT57leurgEWy3LscWlwM0v5vhtk-9e5p8_9YgYqnF3rC05l1kUBQYzEIeYeMxcp8YxsqlnQNoEdCIA4UN08Py7zjr0ohCYbkm76a0-XdquqOTdSKGrnFkmwPxzjWMkuX3f2zpck_Ps8x8TVBpfvywly0QjUbN0ssmLV20zrS8FqkKSdx13uQVzM3MXCBylu5WvhTKE_ogRJdxPpfiA"
$authHeaders = @{"authorization"="bearer $accesskey";"api-version"="1.0"}

Write-Host "Summary info"
$url= $baseurl + $enrollmentNo + "/usage-reports"
$sResponse = Invoke-WebRequest $url -Headers $authHeaders
$sContent = $sResponse.Content | ConvertFrom-Json 
#$sContent.AvailableMonths

Write-Host "Detailed Month info"
#$month="2015-04"
$month=$sContent.AvailableMonths[0].Month
$url= $baseurl + $enrollmentNo + "/usage-report?month=$month&type=detail"
$mResponse = Invoke-WebRequest $url -Headers $authHeaders

#Split the response up into an array from a string
$mContent = ($mResponse.Content -split '[rn]')

#Convert from CSV to object
$mCsv = $mContent | Where-Object { [regex]::matches($_,",").count -gt 28} | ConvertFrom-Csv
#$mCsv = $mcontent[4..$($mcontent.count)] | ConvertFrom-Csv

#$mCsv | Select-Object ServiceResource, Service, Product, date, ResourceQtyConsumed, ResourceRate, ExtendedCost  | ft

$filterDay =$mCsv[-1].Date
Write-Host "Examining for single day $filterDay"
$aday = $mCsv | Where-Object {$_.date -eq $filterDay}
$aday | Select-Object  Product, date, ResourceQtyConsumed, ResourceRate, ExtendedCost | Sort-Object ExtendedCost -Descending | ft

$adayCost = [math]::round($($aday | Select-Object -ExpandProperty ExtendedCost | Measure-Object -Sum).sum,2)
Write-Host "Azure Cost for $filterDay = £$adayCost" 

$monthCost = [math]::round($($mCsv | Select-Object -ExpandProperty ExtendedCost | Measure-Object -Sum).sum,2)
Write-Host "Azure Cost for $month = £$monthCost"

注意: 那里给出的链接中也提到了 API 指南。这是 Azure Billing API 的最佳方式之一

希望有帮助。