Skip to content

Instantly share code, notes, and snippets.

@ontouchstart
Created November 18, 2020 23:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ontouchstart/128aa590f52ce19baebc2e0181f1e8c3 to your computer and use it in GitHub Desktop.
Save ontouchstart/128aa590f52ce19baebc2e0181f1e8c3 to your computer and use it in GitHub Desktop.
Get-AzConsumptionUsageDetail | Select-Object -Property UsageQuantity, UsageStart, UsageEnd | Sort-Object -Property UsageQuantity | ConvertTo-Json | Out-File -Path /home/AzConsumptionUsageDetail.json
[
{
"UsageQuantity": 0.000008,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 0.000008,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 0.000027,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 0.000046,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 0.00005,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 0.000092,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 0.00011,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 0.00015,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 0.000305,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 0.000403,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 0.000461,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 0.000714,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 0.002778,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 0.003544,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 0.003834,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 0.004167,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 0.004167,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 0.004827,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 0.006945,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 0.008334,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 0.009636,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 0.009723,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 1.0,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 2.7833333333,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 3.0,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 3.03555555555556,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 3.083355,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 3.51,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 4.783349,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 4.800016,
"UsageStart": "2020-11-16T00:00:00Z",
"UsageEnd": "2020-11-16T23:59:59Z"
},
{
"UsageQuantity": 5.0,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 5.0,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 6.0,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
},
{
"UsageQuantity": 6.0,
"UsageStart": "2020-11-17T00:00:00Z",
"UsageEnd": "2020-11-17T23:59:59Z"
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment