AzureStack/getsubusage.ps1 at master · bekimd-ms/AzureStack · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
<#
    .Synopsis
    Exports usage meters from Azure Stack to a csv file
    .DESCRIPTION
    Long description
#>

Param
(
    [Parameter(Mandatory = $true)]
    [datetime]
    $StartTime,
    [Parameter(Mandatory = $true)]
    [datetime]
    $EndTime ,
    [Parameter(Mandatory = $false)]
    [ValidateSet("Hourly", "Daily")]
    [String]
    $Granularity = 'Daily',
    [Parameter(Mandatory = $false)]
    [Switch]
    $Force
)

#Initialise meter hashtable
$meters = @{
    'F271A8A388C44D93956A063E1D2FA80B'     = 'Static IP Address Usage'
    '9E2739BA86744796B465F64674B822BA'     = 'Dynamic IP Address Usage'
    'B4438D5D-453B-4EE1-B42A-DC72E377F1E4' = 'TableCapacity'
    'B5C15376-6C94-4FDD-B655-1A69D138ACA3' = 'PageBlobCapacity'
    'B03C6AE7-B080-4BFA-84A3-22C800F315C6' = 'QueueCapacity'
    '09F8879E-87E9-4305-A572-4B7BE209F857' = 'BlockBlobCapacity'
    'B9FF3CD0-28AA-4762-84BB-FF8FBAEA6A90' = 'TableTransactions'
    '50A1AEAF-8ECA-48A0-8973-A5B3077FEE0D' = 'TableDataTransIn'
    '1B8C1DEC-EE42-414B-AA36-6229CF199370' = 'TableDataTransOut'
    '43DAF82B-4618-444A-B994-40C23F7CD438' = 'BlobTransactions'
    '9764F92C-E44A-498E-8DC1-AAD66587A810' = 'BlobDataTransIn'
    '3023FEF4-ECA5-4D7B-87B3-CFBC061931E8' = 'BlobDataTransOut'
    'EB43DD12-1AA6-4C4B-872C-FAF15A6785EA' = 'QueueTransactions'
    'E518E809-E369-4A45-9274-2017B29FFF25' = 'QueueDataTransIn'
    'DD0A10BA-A5D6-4CB6-88C0-7D585CEF9FC2' = 'QueueDataTransOut'
    'FAB6EB84-500B-4A09-A8CA-7358F8BBAEA5' = 'Base VM Size Hours'
    '9CD92D4C-BAFD-4492-B278-BEDC2DE8232A' = 'Windows VM Size Hours'
    '6DAB500F-A4FD-49C4-956D-229BB9C8C793' = 'VM size hours'
    '190c935e-9ada-48ff-9ab8-56ea1cf9adaa' = 'App Service Virtual core hours'
    '957e9f36-2c14-45a1-b6a1-1723ef71a01d' = 'Shared App Service Hours'
    '539cdec7-b4f5-49f6-aac4-1f15cff0eda9' = 'Free App Service Hours'
    'db658d61-ef2d-4888-9843-72f5c774fd3c' = 'Small Basic App Service Hours'
    '27b01104-e0df-4f30-a171-f1b00ecb76b3' = 'Medium Basic App Service Hours'
    '50db6a92-5dff-4c9b-8238-8ea5fb1be107' = 'Large Basic App Service Hours'
    '88039d51-a206-3a89-e9de-c5117e2d10a6' = 'Small Standard App Service Hours'
    '83a2a13e-4788-78dd-5d55-2831b68ed825' = 'Medium Standard App Service Hours'
    '1083b9db-e9bb-24be-a5e9-d6fdd0ddefe6' = 'Large Standard App Service Hours'
    '26bd6580-c3bd-4e7e-8092-58b28eb1bb94' = 'Small Premium App Service Hours'
    'a1cba406-e83e-45c3-bd36-485191c215d9' = 'Medium Premium App Service Hours'
    'a2104a9d-5a78-4f8f-a2df-034bd43d602d' = 'Large Premium App Service Hours'
    'a91eed6c-dbbc-4532-859c-86de776433a4' = 'Extra Large Premium App Service Hours'
    '73215a6c-fa54-4284-b9c1-7e8ec871cc5b' = 'Web Process'
    '5887d39b-0253-4e12-83c7-03e1a93dffd9' = 'External Egress Bandwidth'
    '264acb47-ad38-47f8-add3-47f01dc4f473' = 'SNI SSL'
    '60b42d72-dc1c-472c-9895-6c516277edb4' = 'IP SSL'
    'd1d04836-075c-4f27-bf65-0a1130ec60ed' = 'Functions Compute'
    '67cc4afc-0691-48e1-a4b8-d744d1fedbde' = 'Functions Requests'
    'CBCFEF9A-B91F-4597-A4D3-01FE334BED82' = 'DatabaseSizeHourSqlMeter'
    'E6D8CFCD-7734-495E-B1CC-5AB0B9C24BD3' = 'DatabaseSizeHourMySqlMeter'
    'EBF13B9F-B3EA-46FE-BF54-396E93D48AB4' = 'Key Vault transactions'
    '2C354225-B2FE-42E5-AD89-14F0EA302C87' = 'Advanced keys transactions'
    '380874f9-300c-48e0-95a0-d2d9a21ade8f' = 'Managed Disk S4 (Disk * Month)'
    '1b77d90f-427b-4435-b4f1-d78adec53222' = 'Managed Disk S6 (Disk * Month)'
    'd5f7731b-f639-404a-89d0-e46186e22c8d' = 'Managed Disk S10 (Disk * Month)'
    'ff85ef31-da5b-4eac-95dd-a69d6f97b18a' = 'Managed Disk S15 (Disk * Month)'
    '88ea9228-457a-4091-adc9-ad5194f30b6e' = 'Managed Disk S20 (Disk * Month)'
    '5b1db88a-8596-4002-8052-347947c26940' = 'Managed Disk S30 (Disk * Month)'
    '14496322-39cb-4d33-b67d-39b0c2de0c8e' = 'Managed Disk S40 (Disk * Month)'
    '8c003d25-afb4-4f21-b1fa-86a5b0f001c7' = 'Managed Disk S50 (Disk * Month)'
    '7660b45b-b29d-49cb-b816-59f30fbab011' = 'Managed Disk P4 (Disk * Month)'
    '817007fd-a077-477f-bc01-b876f27205fd' = 'Managed Disk P6 (Disk * Month)'
    'e554b6bc-96cd-4938-a5b5-0da990278519' = 'Managed Disk P10 (Disk * Month)'
    'cdc0f53a-62a9-4472-a06c-e99a23b02907' = 'Managed Disk P15 (Disk * Month)'
    'b9cb2d1a-84c2-4275-aa8b-70d2145d59aa' = 'Managed Disk P20 (Disk * Month)'
    '06bde724-9f94-43c0-84c3-d0fc54538369' = 'Managed Disk P30 (Disk * Month)'
    'eecb2657-e7e6-47f9-9b00-7f58fa8839cb' = 'Managed Disk P40 (Disk * Month)'
    '43626c21-849b-40fe-8c01-e19666059c38' = 'Managed Disk P50 (Disk * Month)'
    '7ba084ec-ef9c-4d64-a179-7732c6cb5e28' = 'Managed Disk ActualStandardDiskSize (GB * Month)'
    'daef389a-06e5-4684-a7f7-8813d9f792d5' = 'Managed Disk ActualPremiumDiskSize (GB * Month)'
    '75d4b707-1027-4403-9986-6ec7c05579c8' = 'Managed Disk ActualStandardSnapshotSize (GB * Month)'
    '5ca1cbb9-6f14-4e76-8be8-1ca91547965e' = 'Managed Disk ActualPremiumDiskSize (GB * Month)'
    '5d76e09f-4567-452a-94cc-7d1f097761f0' = 'Managed Disk S4 (Disk * Hour) (Deprecated)'
    'dc9fc6a9-0782-432a-b8dc-978130457494' = 'Managed Disk S6 (Disk * Hour) (Deprecated)'
    'e5572fce-9f58-49d7-840c-b168c0f01fff' = 'Managed Disk S10 (Disk * Hour) (Deprecated)'
    '9a8caedd-1195-4cd5-80b4-a4c22f9302b8' = 'Managed Disk S15 (Disk * Hour) (Deprecated)'
    '5938f8da-0ecd-4c48-8d5a-c7c6c23546be' = 'Managed Disk S20 (Disk * Hour) (Deprecated)'
    '7705a158-bd8b-4b2b-b4c2-0782343b81e6' = 'Managed Disk S30 (Disk * Hour) (Deprecated)'
    'd9aac1eb-a5d1-42f2-b617-9e3ea94fed88' = 'Managed Disk S40 (Disk * Hour) (Deprecated)'
    'a54899dd-458e-4a40-9abd-f57cafd936a7' = 'Managed Disk S50 (Disk * Hour) (Deprecated)'
    '5c105f5f-cbdf-435c-b49b-3c7174856dcc' = 'Managed Disk P4 (Disk * Hour) (Deprecated)'
    '518b412b-1927-4f25-985f-4aea24e55c4f' = 'Managed Disk P6 (Disk * Hour) (Deprecated)'
    '5cfb1fed-0902-49e3-8217-9add946fd624' = 'Managed Disk P10 (Disk * Hour) (Deprecated)'
    '8de91c94-f740-4d9a-b665-bd5974fa08d4' = 'Managed Disk P15 (Disk * Hour) (Deprecated)'
    'c7e7839c-293b-4761-ae4c-848eda91130b' = 'Managed Disk P20 (Disk * Hour) (Deprecated)'
    '9f502103-adf4-4488-b494-456c95d23a9f' = 'Managed Disk P30 (Disk * Hour) (Deprecated)'
    '043757fc-049f-4e8b-8379-45bb203c36b1' = 'Managed Disk P40 (Disk * Hour) (Deprecated)'
    'c0342c6f-810b-4942-85d3-6eaa561b6570' = 'Managed Disk P50 (Disk * Hour) (Deprecated)'
    '8a409390-1913-40ae-917b-08d0f16f3c38' = 'Managed Disk ActualStandardDiskSize (Byte * Hour) (Deprecated)'
    '1273b16f-8458-4c34-8ce2-a515de551ef6' = 'Managed Disk ActualPremiumDiskSize (Byte * Hour) (Deprecated)'
    '89009682-df7f-44fe-aeb1-63fba3ddbf4c' = 'Managed Disk ActualStandardSnapshotSize (Byte * Hour) (Deprecated)'
    '95b0c03f-8a82-4524-8961-ccfbf575f536' = 'Managed Disk ActualPremiumDiskSize (Byte * Hour) (Deprecated)'
}

#Build a subscription hashtable
$subtable = @{}
$subs = Get-AzsUserSubscription
$subs | ForEach-Object {$subtable.Add($_.SubscriptionId, $_.Owner)}

$StartTime = ("{0:yyyy-MM-ddT00:00:00.00Z}" -f $StartTime)
$EndTime   = ("{0:yyyy-MM-ddT00:00:00.00Z}" -f $EndTime)

Write-Output ("Getting data for period " + $StartTime + " to " + $EndTime)
$result = Get-AzsSubscriberUsage -ReportedStartTime $StartTime  -ReportedEndTime $EndTime -AggregationGranularity $Granularity

Write-Output "Processing result"
$usageSummary = @()
$result  | ForEach-Object {
    $record = New-Object -TypeName System.Object
    $resourceInfo = ($_.InstanceData | ConvertFrom-Json).'Microsoft.Resources'
    $resourceText = $resourceInfo.resourceUri
    $subscription = $resourceText.Split('/')[2]
    $resourceType = $resourceText.Split('/')[7]
    $resourceGroup = $resourceText.Split('/')[4]
    $resourceName = $resourceText.Split('/')[8]
    $record | Add-Member -Name UsageStartTime -MemberType NoteProperty -Value $_.UsageStartTime
    $record | Add-Member -Name UsageEndTime -MemberType NoteProperty -Value $_.UsageEndTime
    $record | Add-Member -Name MeterName -MemberType NoteProperty -Value $meters[$_.MeterId]
    $record | Add-Member -Name Quantity -MemberType NoteProperty -Value $_.Quantity
    $record | Add-Member -Name resourceType -MemberType NoteProperty -Value $resourceType
    $record | Add-Member -Name location -MemberType NoteProperty -Value $resourceInfo.location
    $record | Add-Member -Name resourceGroup -MemberType NoteProperty -Value $resourceGroup
    $record | Add-Member -Name resourceName -MemberType NoteProperty -Value $resourceName
    $record | Add-Member -Name subowner -MemberType NoteProperty -Value $subtable[$subscription]
    $record | Add-Member -Name tags -MemberType NoteProperty -Value $resourceInfo.tags
    $record | Add-Member -Name MeterId -MemberType NoteProperty -Value $_.MeterId
    $record | Add-Member -Name additionalInfo -MemberType NoteProperty -Value $resourceInfo.additionalInfo
    $record | Add-Member -Name subscription -MemberType NoteProperty -Value $subscription
    $record | Add-Member -Name resourceUri -MemberType NoteProperty -Value $resourceText
    $usageSummary += $record
}
$usageSummary