UMN-Azure.psm1
|
### # Copyright 2017 University of Minnesota, Office of Information Technology # This program is free software: you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation, either version 3 of the License, or # (at your option) any later version. # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # You should have received a copy of the GNU General Public License # along with Foobar. If not, see <http://www.gnu.org/licenses/>. #region Basic Azure VM build function New-AzureRGTempateComplete { <# .Synopsis Create Resource Group Templete to build VM .DESCRIPTION Create Resource Group Templete to build VM .PARAMETER resourceGroupName, Resource group VM is to belong to. .PARAMETER Location Azure zone, Central US and so forth. .PARAMETER vm Name of the VM .PARAMETER localUserName Name of the new local user .PARAMETER localPswd Local administrator password .PARAMETER storageAccountName Storage account name for VM storage .PARAMETER storageAccountKey Storage account key .PARAMETER vmSize Basic size of VM, such as A0 .PARAMETER sku OS SKU -- such as 2012-R2-Datacenter .PARAMETER netSecGroup network security group - plan ahead .PARAMETER netSecRG network security resource group template .PARAMETER virtNetName Name of virtual network to be access on .PARAMETER vnetRG Name of virtual network gateway resource group .PARAMETER scriptPath Path in Azure Storeage where Powershell file resides that will be run on vm at build time .PARAMETER scriptFile Name of File in scriptPath location that will be run on vm at build time .EXAMPLE New-AzureRGTempateComplete -resourceGroupName $resourceGroupName -Location $Location -vm $vm -vmSize $vmSize -storageAccountName $storageAccountName -netSecGroup $netSecGroup -netSecRG $netSecRG -virtNetName $virtNetName -vnetRG $vnetRG -localUserName $localUserName -localPswd $localPswd .EXAMPLE Another example of how to use this cmdlet .Notes Author: Travis Sobeck #> [CmdletBinding()] Param ( [ValidateNotNullOrEmpty()] [string]$resourceGroupName, [ValidateSet("eastus", "eastus2", "westus","centralus")] [string]$Location, [ValidateNotNullOrEmpty()] [string]$vm, [ValidateNotNullOrEmpty()] [string]$localUserName, [ValidateNotNullOrEmpty()] [string]$localPswd, [ValidateNotNullOrEmpty()] [string]$storageAccountName, [ValidateNotNullOrEmpty()] [string]$storageAccountKey, [string]$vmSize, [string]$sku, [string]$netSecGroup, [string]$netSecRG, [string]$virtNetName, [string]$vnetRG, [string]$scriptPath, [string]$scriptFile ) $virtNetObject = Get-AzureRmVirtualNetwork -ResourceGroupName $vnetRG -Name $virtNetName $ipPrefix = $virtNetObject.AddressSpace.AddressPrefixes $subnets = $virtNetObject.Subnets foreach ($subnet in $subnets){ if ($subnet.Name -eq 'default'){$subnetPrifix = $subnet.AddressPrefix;$subnetRef = $subnet.Id} } if ($subnetPrifix -eq $null){throw "Failed to find default subnet"} $netSecGroupID = (Get-AzureRmNetworkSecurityGroup -Name $netSecGroup -ResourceGroupName $netSecRG).Id $netIntName = $vm + "-nic-1"# + (Get-Random -Minimum 100 -Maximum 999) $pubIPName = $vm + "-PubIP"# + (Get-Random -Minimum 100 -Maximum 999) $pubDNSName = $vm# + "umn" $diskUri = "https://$storageAccountName" + ".blob.core.windows.net/vhds/$vm" + (Get-Random -Minimum 10000 -Maximum 99999) + '.vhd' $vmTemplate = @{type = "Microsoft.Compute/virtualMachines";name = $vm;apiVersion = "2015-06-15";location = $location;dependsOn = @("Microsoft.Network/networkInterfaces/$netIntName"); properties = @{osProfile = @{computerName = $vm;adminUsername = $localUserName;adminPassword = $localPswd;windowsConfiguration = @{provisionVmAgent = 'true'}}; hardwareProfile = @{vmSize = $vmSize}; networkProfile = @{networkInterfaces = @(@{id="[resourceId('Microsoft.Network/networkInterfaces', '$netIntName')]"})}; storageProfile = @{imageReference = @{publisher = "MicrosoftWindowsServer"; offer = "WindowsServer"; sku = $sku; version = "latest"}; osDisk = @{name = $vm;vhd = @{uri = $diskUri};createOption = "fromImage"}; dataDisks = @()} } } if ($scriptFile -and $scriptPath){ $customScript = @{type = "Microsoft.Compute/virtualMachines/extensions";name = "$vm/BuildScript";apiVersion = "2016-03-30";location = $location;dependsOn = @("Microsoft.Compute/virtualMachines/$vm"); properties = @{publisher = "Microsoft.Compute";type = "CustomScriptExtension";typeHandlerVersion = "1.8";autoUpgradeMinorVersion = "true"; settings = @{fileUris = @(($scriptPath+$scriptFile));commandToExecute = "powershell.exe -ExecutionPolicy Unrestricted -File $scriptFile"}; protectedSettings = @{storageAccountName = $storageAccountName;storageAccountKey = $storageAccountKey} } } } $netInterfaceTemplate = @{type = "Microsoft.Network/networkInterfaces";name = $netIntName;apiVersion = "2015-06-15";location = $location;dependsOn = @("Microsoft.Network/publicIpAddresses/$pubIPName"); properties = @{primary = $true; ipConfigurations = @(@{ name = "ipconfig1";properties = @{subnet = @{id = $subnetRef};privateIPAllocationMethod = "Dynamic";publicIpAddress = @{id = "[resourceId('$resourceGroupName','Microsoft.Network/publicIpAddresses', '$pubIPName')]"}} }); networkSecurityGroup = @{id = $netSecGroupID} } } $pubIpTemplate = @{type = "Microsoft.Network/publicIpAddresses";name = $pubIPName;apiVersion = "2015-06-15";location = $location; properties = @{publicIpAllocationMethod = "Dynamic";dnsSettings = @{domainNameLabel = $pubDNSName}} } @{'$schema'='http://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#';contentVersion="1.0.0.0"; parameters = @{}; variables = @{}; resources = @($vmTemplate;$customScript;$netInterfaceTemplate;$pubIpTemplate); outputs = @{}; } | ConvertTo-Json -Depth 7 | Out-File -FilePath .\$vm.json -Force Test-AzureRmResourceGroupDeployment -ResourceGroupName $resourceGroupName -TemplateFile .\$vm.json -Mode Incremental -Verbose } ## Build VM function New-AzureVMcomplete { <# .Synopsis Build VM .DESCRIPTION Build a VM along with required resources .PARAMETER resourceGroupName, Resource group VM is to belong to. .PARAMETER Location Azure zone, Central US and so forth. .PARAMETER vm Name of the VM .PARAMETER localUserName Name of the new local user .PARAMETER localPswd Local administrator password .PARAMETER storageAccountName Storage account name for VM storage .PARAMETER storageAccountKey Storage account key .PARAMETER vmSize Basic size of VM, such as A0 .PARAMETER sku OS SKU -- such as 2012-R2-Datacenter .PARAMETER netSecGroup network security group - plan ahead .PARAMETER netSecRG network security resource group template .PARAMETER virtNetName Name of virtual network to be access on .PARAMETER vnetRG Name of virtual network gateway resource group .EXAMPLE $result = New-AzureVMcomplete -ResourceGroupName "VPN-GW" -Location eastus -vmname "mynewtest" -VMSize Basic_A0 .Notes Author: Travis Sobeck #> [CmdletBinding()] Param ( [ValidateNotNullOrEmpty()] [string]$resourceGroupName, [ValidateSet("eastus", "eastus2", "westus","centralus")] [string]$Location, [ValidateNotNullOrEmpty()] [string]$vm, [ValidateNotNullOrEmpty()] [string]$localUserName, [ValidateNotNullOrEmpty()] [string]$localPswd, [ValidateNotNullOrEmpty()] [string]$storageAccountName, [ValidateNotNullOrEmpty()] [string]$storageAccountKey, [string]$vmSize, [string]$sku, [string]$netSecGroup, [string]$netSecRG, [string]$virtNetName, [string]$vnetRG ) New-AzureRGTempateComplete -resourceGroupName $resourceGroupName -Location $Location -vm $vm -vmSize $vmSize -storageAccountName $storageAccountName -netSecGroup $netSecGroup -netSecRG $netSecRG -virtNetName $virtNetName -vnetRG $vnetRG -localUserName $localUserName -localPswd $localPswd New-AzureRmResourceGroupDeployment -ResourceGroupName $resourceGroupName -TemplateFile .\$vm.json Remove-Item -Path .\$vm.json -Force } function Remove-AzureVMcomplete { <# .Synopsis Delete VM .DESCRIPTION Delete a VM and its NIC/PublicIP/osDisk .PARAMETER resourceGroupName The name of the resource group the VM belongs to .PARAMETER vm The name of the VM .PARAMETER storageRGname The resource group name of the storage account .EXAMPLE $result = Remove-AzureVMcomplete -ResourceGroupName "VPN-GW" -vm "mynewtest" .Notes Author: Travis Sobeck #> [CmdletBinding()] Param ( [ValidateNotNullOrEmpty()] [string]$ResourceGroupName, [ValidateNotNullOrEmpty()] [string]$vm, [ValidateNotNullOrEmpty()] [string]$storageRGname = 'RG_Template' ) $vmObj = Get-AzureRmVM -ResourceGroupName $ResourceGroupName -Name $vm #### should probably stop vm $null = Stop-AzureRmVM -ResourceGroupName $ResourceGroupName -Name $vm -Force # Status : Succeeded ## get NetworkInterface info $netID = $vmObj.NetworkInterfaceIDs[0] $net = Get-AzureRmResource -ResourceId $netID $netIpConfigID = $net.Properties.ipConfigurations[0].id ## get Public IP info $pubIP = Get-AzureRmPublicIpAddress -ResourceGroupName $ResourceGroupName $pubIpName = ($pubIP | Where-Object {$_.IpConfiguration[0].Id -eq $netIpConfigID}).Name ### Deletion order is very important ## remove vm $null = Remove-AzureRmVM -ResourceGroupName $ResourceGroupName -Name $vm -Force ## Status = Succeeded ## remove network Interface $null = Remove-AzureRmNetworkInterface -ResourceGroupName $resourceGroupName -Name $net.Name -Force ## remove public IP if ($pubIpName -ne $null){$null = Remove-AzureRmPublicIpAddress -ResourceGroupName $resourceGroupName -Name $pubIpName -Force} else{write-host "No Public IP"} ## Delete Disk [array]$diskArray = ($vmObj.StorageProfile.OsDisk.vhd.Uri).Split('/') $container = $diskArray[-2] ## check this equals vhds $diskName = $diskArray[-1] ## check this equals $vm<rand>.vhd $StorageAccountName = ($diskArray[-3]).Split('.')[0] # do a Find-AzureRmResource -ResourceGroupNameContains $resourceGroupName -ResourceType 'Microsoft.Storage/storageAccounts' make sure its in there $StorageAccountKey = (Get-AzureRmStorageAccountKey -ResourceGroupName $storageRGname -Name $StorageAccountName)[0].Value $ctx = New-AzureStorageContext -StorageAccountName $StorageAccountName -StorageAccountKey $StorageAccountKey $null = Remove-AzureStorageBlob -Blob $diskName -Container $container -Context $ctx ## clean out of AD Remove-ADComputer -Identity $vm -Confirm:$false } #endregion #region Azure Log Analytics function Get-AzureLogAnalytics { <# .Synopsis Query Azure Log Analytics .DESCRIPTION Requires having identity set in Azure AD to allow access to Log Analytics API, and an Azure AD Application registered to get an API OAuth token from. .PARAMETER workspaceID The workspaceID reference for this API is the subscription which has the Log Analytics account. .PARAMETER accessToken An OAuth accessToken. See Get-AzureOAuthTokenUser as a possible source. .PARAMETER query A valid Log Analytics query. Example = 'AzureDiagnostics | where ResultType == "Failed" | where RunbookName_s == "Name of runbook" |where TimeGenerated > ago(1h)' .EXAMPLE $result = Get-AzureLogAnalytics -workspaceID <Subscription ID> -accessToken $accessToken -query $query .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string] $workspaceID, [Parameter(Mandatory=$true)] [string] $accessToken, [Parameter(Mandatory=$true)] [string] $query ) Begin { $contentType = 'application/json' $uri = "https://api.loganalytics.io/v1/workspaces/"+$workspaceID+"/query" $header = @{"Authorization"="Bearer $accessToken"} $body = @{"query"=$query} |ConvertTo-Json } Process { $response = Invoke-RestMethod -Method Post -Uri $uri -Body $body -Headers $header -ContentType $contentType } End { return $response } } function Get-AzureLogAnalyticsSignature { <# .Synopsis Create signature for posting to Log Analytics .DESCRIPTION Create signature for posting to Log Analytics .PARAMETER data JSON formatted data to be posted to Log Analytics .PARAMETER primaryKey The Primary Workspace KEY for your workspace. .PARAMETER workspaceID Workspace ID associated to your Log Analytics space. .EXAMPLE $signature = Get-AzureLogAnalyticsSignature -date $json -primaryKey $key -workspaceID $workspaceID .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string] $data, [Parameter(Mandatory=$true)] [string] $primaryKey, [Parameter(Mandatory=$true)] [string] $workspaceID ) Begin { $method = "POST" $contentType = "application/json" $api = "/api/logs" } Process { $xMSDate = "x-ms-date:" + ([DateTime]::UtcNow.ToString("r")) $contentLength = $data.Length $stringToSign = $method + "`n" + $contentLength + "`n" + $contentType + "`n" + $xMSDate + "`n" + $api $stringBytes = [Text.Encoding]::UTF8.GetBytes($stringToSign) $primaryKeyBytes = [Convert]::FromBase64String($primaryKey) $hmac256 = New-Object System.Security.Cryptography.HMACSHA256 $hmac256.Key = $primaryKeyBytes $hash = $hmac256.ComputeHash($stringBytes) $hashBase64 = [Convert]::ToBase64String($hash) $signature = 'SharedKey {0}:{1}' -f $workspaceID,$hashBase64 } End { return $signature } } function New-AzureLogAnalyticsData { <# .Synopsis For posting data to Log Analytics. .DESCRIPTION The post portion of pushing data to Log Analytics. Requires a signed signature. .PARAMETER data JSON Formatted data to be sent to Log Analytics custom log. .PARAMETER logtype The custom log name for indexing. Will have _CL appended to it automatically by Log Analytics (Custom Log) .PARAMETER primaryKey The Primary Workspace KEY for your workspace. .PARAMETER workspaceID Workspace ID associated to your Log Analytics space. .EXAMPLE New-AzureLogAnalyticsData -data $data -logType $logType -primaryKey $primaryKey -workspaceID $workspaceID .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string] $data, [Parameter(Mandatory=$true)] [string] $logType, [Parameter(Mandatory=$true)] [string] $primaryKey, [Parameter(Mandatory=$true)] [string] $workspaceID ) Begin { $method = "POST" $contentType = "application/json" $api = "/api/logs" $uri = "https://" + $workspaceID + ".ods.opinsights.azure.com" + $api + "?api-version=2016-04-01" $date = [DateTime]::UtcNow.ToString("r") $signature = Get-AzureLogAnalyticsSignature -data $data -primaryKey $primaryKey -workspaceID $workspaceID $headers = @{"Authorization" = $signature;"Log-Type" = $logType;"x-ms-date" = $date;"time-generated-field"=$date} } Process { $response = Invoke-WebRequest -Uri $uri -Method $method -ContentType $contentType -Headers $headers -Body $data -UseBasicParsing } End { return $response } } #endregion #region Azure Graph API ## A starter point for the graph API ## Based on https://developer.microsoft.com/en-us/graph/graph-explorer ## oData Filtering/paging is supported. See https://msdn.microsoft.com/en-us/library/azure/ad/graph/howto/azure-ad-graph-api-supported-queries-filters-and-paging-options ## Example: $uri = "https://graph.microsoft.com/v1.0/users?" + '$filter' + "=userPrincipalName eq '$userPrincipalName'" function Get-AzureGraphUsers { <# .Synopsis Query Azure Graph API for basic user details .DESCRIPTION Requires having identity set in Azure AD to allow access to Graph API, and an Azure AD Application registered to get an API OAuth token from. .PARAMETER accessToken An OAuth accessToken. See Get-AzureOAuthTokenUser as a possible source. .PARAMETER userPrincipalNames A valid user userPrincipalName .PARAMETER query Optional to query specified information in relation to the user object. .EXAMPLE $result = Get-AzureGraphUsers -accessToken $accessToken -userPrincipalName 'jemina@somedomain.onmicrosoft.com' -query .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true,ValueFromPipeline=$true)] [array] $userPrincipalNames, [Parameter(Mandatory=$true)] [string] $accessToken, [string]$query ) Begin { $header = @{"Authorization"="Bearer $accessToken"} $response = @{} } Process { Foreach ($PSItem in $userPrincipalNames) { $results = $null $uri = "https://graph.microsoft.com/v1.0/users/$PSItem/$query" $results = Invoke-RestMethod -Method Get -Uri $uri -Headers $header $response.Add($PSItem,$results) } } End { return $response } } Function Get-AzureGraphObject { <# .Synopsis Query Azure Graph API for object details .DESCRIPTION Use the $top oData filter to query objects in bulk using paging. .PARAMETER accessToken An OAuth accessToken. See Get-AzureOAuthTokenUser as a possible source. .PARAMETER apiVersion Some of the API versions in Graph are 'beta' - default to 1.0 .PARAMETER batchSize Used to determine how many records to return per page. Microsoft Graph behaviors are per api... .PARAMETER objectType The object type to query. Paging with the $top filter is supported for all /users, but the $top filter is rejected. .EXAMPLE $results = Get-AzureGraphObject -accessToken $accessToken -objectType '' .EXAMPLE $results = Get-AzureGraphObject -accessToken $accessToken -apiVersion 'Beta' -batchSize 500 -objectType '' .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string] $accessToken, [Parameter(Mandatory=$false)] [string]$apiVersion, [Parameter(Mandatory=$false)] [int]$batchSize = '200', [Parameter(Mandatory=$true)] [string]$objectType ) Begin { if(-not $apiVersion) {$apiVersion='v1.0'} $header = @{"Authorization"="Bearer $accessToken"} $uri = "https://graph.microsoft.com/$apiVersion/$objectType`?top eq $batchSize" If($objectType -eq 'users') { $uri = "https://graph.microsoft.com/$apiVersion/$objectType" } ## Testing $i=0 } Process { $results= @() do { $return = $null $return = Invoke-RestMethod -Method Get -Uri $uri -Headers $header $uri = $return.'@odata.nextlink' $results = $results + $return.value $i++ write-host "Pass number $i" } until ($uri -eq $null) } End { return $results } } function Get-AzureOneDriveID { <# .Synopsis Gets One Drive ID by User .DESCRIPTION Gets One Drive ID by User .PARAMETER accessToken oAuth Access token with API permissions allowed for One Drive on the https://graph.microsoft.com resource. .PARAMETER apiVersion Defaults to 1.0. Can set for beta or other as they allow. .PARAMETER userPrincipalName User Principal Name of the user's one drive. .EXAMPLE Get-AzureOneDriveID -accessToken $accessToken -userPrincipalName 'moon@domain.edu' .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string]$accessToken, [string]$apiVersion = 'v1.0', [Parameter(Mandatory=$true)] [string]$userPrincipalName ) Begin { $header = @{"Authorization"="Bearer $accessToken"} } Process { $uri = "https://graph.microsoft.com/$apiVersion/users/$userPrincipalName/drives" $return = Invoke-RestMethod -Method Get -Uri $uri -Headers $header } End { return $return.value.Id } } function Get-AzureOneDriveFiles { <# .Synopsis Function to query One Drive for files .DESCRIPTION Needed in order to upload large files to One Drive via the Graph API. .PARAMETER accessToken oAuth Access token with API permissions allowed for One Drive on the https://graph.microsoft.com resource. .PARAMETER apiVersion Defaults to 1.0. Can set for beta or other as they allow. .PARAMETER driveID The OneDrive ID of the O365 User. See Get-AzureOneDriveID. .PARAMETER itemIDs An array of file/folder item IDs to be downloaded. See Get-AzureOneDriveRootContent as a starting place. .PARAMETER outPutPath Local path to store the files. .PARAMETER rootCreated A switch for when looping through from the root of a one drive to gather the entire one drive. .PARAMETER userPrincipalName The Azure AD UserPrincipalName of the OneDrive account owner. .EXAMPLE Get-AzureOneDriveFiles -accessToken $accessToken -driveID $driveID -itemIDs $arrayOfItemIds -outPutPath c:\temp -rootCreated $False -userPrincipalName 'moon@domain.edu' .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string]$accessToken, [string]$apiVersion = 'V1.0', [Parameter(Mandatory=$true)] [string]$driveID, [Parameter(Mandatory=$true)] [array]$itemIDs, [Parameter(Mandatory=$true)] [string]$outPutPath, [string]$rootCreated = 'needed', [Parameter(Mandatory=$true)] [string]$userPrincipalName ) Begin { $user = ($userPrincipalName -split ("@"))[0] $header = @{"Authorization"="Bearer $accessToken"} # Check and create output directory If ($outPutPath -notmatch '.+?\\$') {$outPutPath += '\'} Try {Get-ChildItem -path $outputPath\$user -ErrorAction stop} Catch {New-Item -ItemType directory -Path $outPutPath\$user} # Get first folder structure of root:/ and create if needed. If($rootCreated -eq 'needed') { $itemIDs | ForEach-Object { $child = $_ $return = Get-AzureOneDriveItem -accessToken $accessToken -driveID $driveID -itemID $child # Folder / File Loop if ($return.folder){ $parent = $return.parentReference.path -replace ("/drives/$driveID/root:","$outPutPath\$user") $parent = $parent -replace ("/","\") New-Item -ItemType directory -Path ($parent + '\' + $return.name) -Force } if ($return.file){ $fileName = $return.name If ($outPutPath -match '.+?\\$') {$outPutPath = $outPutPath.Substring(0,$outPutPath.Length-1)} $filePath = $return.parentReference.path -replace ("/drives/$driveID/root:","$outPutPath\$user") $filePath = $filePath -replace ("/","\") $outfile = $filePath + '\' + $fileName $download = $return.'@microsoft.graph.downloadUrl' Invoke-WebRequest -Method Get -Uri $download -OutFile $outfile } if ($return.package.type) { $type = $return.package.type $location = $return.parentReference Write-Host "$type found at location $location. Unable to download for user $user" } } } } Process{ Foreach ($PSItem in $itemIDs){ # Get Children of Item $uri = "https://graph.microsoft.com/$apiVersion/drives/$driveID/items/$PSItem"+"?expand=children(select=id,name)" $return = Invoke-RestMethod -Method Get -Uri $uri -Headers $header $children = $return.children # Process each item $children | ForEach-Object{ $child = $_.id $return = Get-AzureOneDriveItem -accessToken $accessToken -driveID $driveID -itemID $child # Folder / File Loop if ($return.folder){ $parent = $return.parentReference.path -replace ("/drives/$driveID/root:","$outPutPath\$user") $parent = $parent -replace ("/","\") New-Item -ItemType Directory -Path ($parent + '\' + $return.name) -Force Try { $newArray = New-Object System.Collections.ArrayList($null) $return | foreach-object {$null = $newArray.Add($_.id)} Start-Sleep -Seconds 1 Get-AzureOneDriveFiles -accessToken $accessToken -driveID $driveID -itemIDs $newArray -user $user -outPutPath $outPutPath -rootCreated 'done' } Catch{} } if ($return.file){ $fileName = $return.name If ($outPutPath -match '.+?\\$') {$outPutPath = $outPutPath.Substring(0,$outPutPath.Length-1)} $filePath = $return.parentReference.path -replace ("/drives/$driveID/root:","$outPutPath\$user") $filePath = $filePath -replace ("/","\") $outfile = $filePath + '\' + $fileName $download = $return.'@microsoft.graph.downloadUrl' Invoke-WebRequest -Method Get -Uri $download -OutFile $outfile } if ($return.package.type) { $type = $return.package.type $location = $return.parentReference Write-Host "$type found at location $location. Unable to download for user $user" } } } } end{} } function Get-AzureOneDriveItem { <# .Synopsis Gets One Drive Item by ID .DESCRIPTION Gets One Drive Item by ID .PARAMETER accessToken oAuth Access token with API permissions allowed for One Drive on the https://graph.microsoft.com resource. .PARAMETER apiVersion Defaults to 1.0. Can set for beta or other as they allow. .PARAMETER driveID The OneDrive ID of the O365 User. See Get-AzureOneDriveID. .PARAMETER itemID The itemID of the folder/file. .EXAMPLE Get-AzureOneDriveItem -accessToken $accessToken -driveID $driveID -itemID $itemID .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string]$accessToken, [string]$apiVersion = 'v1.0', [Parameter(Mandatory=$true)] [string]$driveID, [Parameter(Mandatory=$true)] [string]$itemID ) Begin{} Process { $header = @{"Authorization"="Bearer $accessToken"} $uri = "https://graph.microsoft.com/$apiVersion/drives/$driveID/items/$itemID" $return = Invoke-RestMethod -Method Get -Uri $uri -Headers $header } End{return $return} } function Get-AzureOneDriveRootContent { <# .Synopsis Gets the One Drive Root Content .DESCRIPTION Will get all IDs of folders and files at the root of a one Drive with Child item info. .PARAMETER accessToken oAuth Access token with API permissions allowed for One Drive on the https://graph.microsoft.com resource. .PARAMETER apiVersion Defaults to 1.0. Can set for beta or other as they allow. .PARAMETER driveID The drive ID to be queried. .EXAMPLE Get-AzureOneDriveRootContent -accessToken $accessToken -driveID $driveID .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string]$accessToken, [string]$apiVersion = 'V1.0', [Parameter(Mandatory=$true)] [string]$driveID ) Begin { $header = @{"Authorization"="Bearer $accessToken"} } Process { $uri = "https://graph.microsoft.com/$apiVersion/drives/$driveID/root?expand=children(select=id,name,type,property)" $return = Invoke-RestMethod -Method Get -Uri $uri -Headers $header } End { return $return.children } } function New-OneDriveFolder { <# .Synopsis Creates a new folder .DESCRIPTION Provide a item ID of parent folder or create new folder at root of OneDrive .PARAMETER accessToken oAuth Access token with API permissions allowed for One Drive on the https://graph.microsoft.com resource. .PARAMETER apiVersion Defaults to 1.0. Can set for beta or other as they allow. .PARAMETER folderName Name of the new folder .PARAMETER parentID Item of the parent folder .PARAMETER root Boolean switch. If true - no parent ID is needed, and will create folder in root of One Drive. .PARAMETER userPrincipalName UserPrincipalName of the OneDrive account owner. .EXAMPLE New-OneDriveFolder -accessToken $accessToken -folderName 'New Folder' -root $true -userPrincipalName 'moon@domain.edu' .EXAMPLE New-OneDriveFolder -accessToken $accessToken -folderName 'New Folder' -parentID $parentID -userPrincipalName 'moon@domain.edu' .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string]$accessToken, [string]$apiVersion = 'V1.0', [Parameter(Mandatory=$true)] [string]$folderName, [string]$parentID, [boolean]$root = $false, [Parameter(Mandatory=$true)] [string]$userPrincipalName ) Begin { $body = @{folder=@{"@odata.type"="microsoft.graph.folder"};name="$folderName"} |ConvertTo-Json $header = @{"Authorization"="Bearer $accessToken"} If ($root -eq $false) { $uri = "https://graph.microsoft.com/$apiVersion/users/$userPrincipalName/drive/items/$parentID/children" } else { $uri = "https://graph.microsoft.com/$apiVersion/users/$userPrincipalName/drive/root/children" } } Process { $return = Invoke-RestMethod -Method Post -Uri $uri -Headers $header -Body $body -ContentType 'application/json' } End { return $return } } function New-OneDriveLargeFileUpload { <# .Synopsis Upload large files to OneDrive .DESCRIPTION Will break down a large file into chunks for upload to OneDrive for Business account. Requires prep work for administrative control. .PARAMETER chunkSize The byte chunk size to break the file into. Has to be a multiple of 327680 or OneDrive API will reject. .PARAMETER localFilePath Path to the local file to be uploaded. Include the file name with extension. .PARAMETER uploadURL The upload URL provided from the upload session request. See New-AzureOneDriveLargeFileSession call to retrieve. .EXAMPLE New-OneDriveLargeFileUpload -localFilePath c:\temp\aVeryLargeFile.vhd -uploadURL $uploadURL .Notes Author: Kyle Weeks #> param ( [int]$chunkSize=4915200, [Parameter(Mandatory=$true)] [string]$LocalFilePath, [Parameter(Mandatory=$true)] [string]$uploadURL ) Begin { $reader = [System.IO.File]::OpenRead($LocalFilePath) $fileLength = $reader.Length $buffer = New-Object Byte[] $chunkSize $moreChunks = $true $byteCount = 0 } Process { while($moreChunks) { ## Test for end of file If (($reader.Position + $buffer.Length) -gt $fileLength) { $bits = ($fileLength - $reader.Position) $buffer = New-Object Byte[] $bits $bytesRead = $reader.Read($buffer, 0, $bits) $moreChunks = $false } Else {$bytesRead = $reader.Read($buffer, 0, $buffer.Length)} $output = $buffer $contentLength = $bytesread $uploadRange = ($reader.Position -1) $contentRange = "$bytecount"+"-"+$uploadRange+"/$fileLength" $headerUpload = @{ "Content-Length"=$contentLength; "Content-Range"="bytes $contentRange" } $return = Invoke-RestMethod -Method Put -Uri $uploadURL -Headers $headerUpload -Body $output $byteCount = $byteCount + $chunkSize $return.nextExpectedRanges } } End { $reader.Close() return $return } } function New-AzureOneDriveLargeFileSession { <# .Synopsis Generates a One Drive large file upload session. .DESCRIPTION Needed in order to upload large files to One Drive via the Graph API. .PARAMETER accessToken oAuth Access token with API permissions allowed for One Drive on the https://graph.microsoft.com resource. .PARAMETER apiVersion Defaults to 1.0. Can set for beta or other as they allow. .PARAMETER driveID The OneDrive ID of the O365 User. See Get-AzureOneDriveID. .PARAMETER OneDriveFilePath The One Drive folder path with file name. "New Folder/Microsoft.jpg" .EXAMPLE New-AzureOneDriveLargeFileSession -accessToken $accessToken -driveID $driveID -oneDriveFilePath $oneDriveFilePath .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string]$accessToken, [string]$apiVersion = "v1.0", [Parameter(Mandatory=$true)] [string]$driveID, [Parameter(Mandatory=$true)] [string]$OneDriveFilePath ) Begin { $header = @{"Authorization"="Bearer $accessToken"} $method = 'POST' $uri = "https://graph.microsoft.com/$apiVersion/drives/$driveID/root:/$OneDriveFilePath"+":/createUploadSession" } Process { $response = Invoke-RestMethod -Method $method -Uri $uri -Headers $header $uploadURL = $response.uploadurl } End { return $uploadURL } } #endregion #region Azure Marketplace billing function Get-AzureMarketplaceCharges { <# .Synopsis Get azure marketplace usage .DESCRIPTION For getting marketplace usage data. .PARAMETER key API key gathered from the EA portal for use with billing API. .PARAMETER enrollment Your Enterprise Enrollment number. Available form the EA portal. .PARAMETER billingPeriodDate An optional parameter to specify that you wish to get from the following year and month. Format YYYYMM .PARAMETER startDate Start date time of the query - ####-##-## year, month, day = 2017-01-28 .PARAMETER endDate End date time of the query - ####-##-## year, month, day = 2017-01-28 .EXAMPLE $result = Get-AzureMarketplaceCharges -key 'apiKeyFromEAPortal' -enrollment 'EAEnrollmentNumber' .EXAMPLE $result = Get-AzureMarketplaceCharges -key 'apiKeyFromEAPortal' -enrollment 'EAEnrollmentNumber' -billingPeriodDate '201701' .EXAMPLE $result = Get-AzureMarketplaceCharges -key 'apiKeyFromEAPortal' -enrollment 'EAEnrollmentNumber' -startDate '20170515' -endDate '20170602' .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string] $enrollment, [Parameter(Mandatory=$true)] [string] $key, [string]$billingPeriodDate, [ValidateLength(1,10)] [string]$startDate, [ValidateLength(1,10)] [string]$endDate ) Begin{ $header = @{"authorization"="bearer $key"} if ($billingPeriodID -eq '') {$uri = "https://consumption.azure.com/v3/enrollments/$enrollment/marketplacecharges"} Else {$uri = "https://consumption.azure.com/v3/enrollments/$enrollment/billingPeriods/$billingPeriodDate/marketplacecharges"} if ($startDate -ne '') {if ($endDate -ne ''){$uri = "https://consumption.azure.com/v3/enrollments/$enrollment/marketplacechargesbycustomdate?startTime=$startDate&endTime=$endDate"}} } Process { $response = Invoke-RestMethod $uri -Headers $header } End { return $response } } #endregion #region Azure Reserved Instance billing function Get-AzureReservedInstanceCharges { <# .Synopsis Get azure reserved instance charges .DESCRIPTION For getting reserved instance charges .PARAMETER key API key gathered from the EA portal for use with billing API. .PARAMETER enrollment Your Enterprise Enrollment number. Available form the EA portal. .PARAMETER billingPeriod Used to calculate the first and last day of month. Format yyyy-MM .EXAMPLE $result = Get-Get-AzureReservedInstanceCharges -key 'apiKeyFromEAPortal' -enrollment 'EAEnrollmentNumber' -billingPeriod '2019-01' .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string] $enrollment, [Parameter(Mandatory=$true)] [string] $key, [Parameter(Mandatory=$true)] [ValidateLength(1,7)] [string]$billingPeriod ) Begin{ $header = @{"authorization"="bearer $key"} $date = get-date -date $billingPeriod $year = $date.Year $month = $date.Month $nextMonth = $date.AddMonths(1) $lastday = $nextMonth.AddTicks(-1) $endDay = get-date -date $lastDay -format yyyy-MM-dd $startDay = Get-Date -Year $year -Month $month -Day 1 -Format yyyy-MM-dd $uri = "https://consumption.azure.com/v3/enrollments/$enrollment/reservationcharges?startDate=$startDay&endDate=$endDay" } Process { $response = Invoke-RestMethod -method get $uri -Headers $header } End { return $response } } #endregion #region Azure OAuth authentication function Get-AzureOAuthTokenService{ <# .Synopsis Get Valid OAuth Token. The access token is good for an hour, and there is no refresh token. .DESCRIPTION This OAuth token is intended for use with CLI, automation, and service calls. No user interaction is required. Requires an application to be registered in Azure AD with appropriate API permissions configured. .PARAMETER tenantID Azure AD Directory ID/TenantID .PARAMETER clientid Azure AD Custom Application ID .PARAMETER accessKey Azure AD Custom Application access key .PARAMETER resource Resource to be interacted with. Example = https://api.loganalytics.io. Use the clientID here if authenticating a token to your own custom app. .PARAMATER scope An alternate to url resource to provide security scope to actions of an API such as with OneDrive. .EXAMPLE $tokenInfo = Get-AzureOAuthTokenService -tenantID 'Azure AD Tenant ID' -clientid 'Application ID' -accessKey 'Preset key for app' -resource 'MS API Resource' .Notes Author: Kyle Weeks #> [CmdletBinding()] [OutputType([array])] Param ( [Parameter(Mandatory)] [string]$tenantID, [Parameter(Mandatory)] [string]$clientid, [Parameter(Mandatory)] [string]$accessKey, [string]$resource, [string]$scope = '' ) Begin { $uri = "https://login.microsoftonline.com/$tenantID/oauth2/token" } Process { If ($scope -ne '') {$body = @{grant_type="client_credentials";client_id=$clientid;client_secret=$accessKey;scope=$scope}} else {$body = @{grant_type="client_credentials";client_id=$clientid;client_secret=$accessKey;resource=$resource}} $response = Invoke-RestMethod -Method Post -Uri $uri -ContentType "application/x-www-form-urlencoded" -Body $body $accessToken = $response.access_token } End { return $accessToken } } function Get-AzureOAuthTokenUser{ <# .Synopsis Get Valid OAuth Token. The access token is good for an hour, the refresh token is mostly permanent and can be used to get a new access token without having to re-authenticate .DESCRIPTION This is based on authenticating against a custom Web/API Application registered in Azure AD which has permissions to Azure AD, Azure Management, and other APIs. .PARAMETER tenantID Azure AD Directory ID/TenantID .PARAMETER clientid Azure AD Custom Application ID .PARAMETER accessKey Azure AD Custom Application access key .PARAMETER redirectUri For return stream of claims .PARAMETER resource Resource to be interacted with. Example = https://api.loganalytics.io, or https://graph.microsoft.com .PARAMETER refreshtoken Supply a refresh token to get a new valid token for use after expiring .PARAMETER prompt Define if your app login should prompt the user for consent in the Azure portal on login. none = will never request and rely on SSO (web apps) .EXAMPLE $tokenInfo = Get-AzureOAuthTokenUser -tenantID 'Azure AD Tenant ID' -clientid 'Application ID' -accessKey 'Preset key for app' -redirectUri 'https redirect uri of app' -resource 'MS API Resource' .EXAMPLE $tokenInfo = Get-AzureOAuthTokenUser -tenantID 'Azure AD Tenant ID' -clientid 'Application ID' -accessKey 'Preset key for app' -redirectUri 'https redirect uri of app' -resource 'MS API Resource' -refreshtoken 'your refresh token from a previous call' .Notes Author: Kyle Weeks #> [CmdletBinding()] [OutputType([array])] Param ( [Parameter(Mandatory)] [string]$tenantID, [Parameter(Mandatory)] [string]$clientid, [Parameter(Mandatory)] [string]$accessKey, [Parameter(Mandatory)] [string]$redirectUri, $resource, $scope = '', [ValidateSet('login','none','consent')] [string]$prompt = "consent", [string]$refreshtoken ) Begin { # Build Azure REST Endpoints $baseURI = "https://login.microsoftonline.com/$tenantID" $tokenEndpoint = $baseURI + "/oauth2/token" $authorizeEndpoint = $baseURI + "/oauth2/authorize" } Process { If (!$refreshtoken){ # Get a claim code which is used to get a token $responseType = 'code' $grantType = "authorization_code" # Construct the claim authorization endpoint If ($scope -ne ''){ $uri = $authorizeEndpoint+"?client_id=$clientid&response_type=$responseType&scope=$scope&redirect_uri=$redirectUri&prompt=$prompt" } else { $uri = $authorizeEndpoint+"?client_id=$clientid&response_type=$responseType&resource=$resource&redirect_uri=$redirectUri&prompt=$prompt" } # OAuth is generally used interactive for users... not core friendly. ## Popup a new IE window, log in, authorize app as needed, and collect claim code $ie = New-Object -comObject InternetExplorer.Application $ie.visible = $true $null = $ie.navigate($uri) #Wait for user interaction in IE, manual approval do{Start-Sleep 1}until($ie.LocationURL -match 'code=([^&]*)') $null = $ie.LocationURL -match 'code=([^&]*)' $authorizationCode = $matches[1] $null = $ie.Quit() # exchange the authorization code for tokens $uri = $tokenEndpoint If ($scope -ne ''){ $body = @{client_id=$clientid;grant_type=$grantType;code=$authorizationCode;redirect_uri=$redirectUri;client_secret=$accessKey;resource=$resource} } Else { $body = @{client_id=$clientid;grant_type=$grantType;code=$authorizationCode;redirect_uri=$redirectUri;client_secret=$accessKey;resource=$resource} } $response = Invoke-RestMethod -Method Post -Uri $uri -ContentType "application/x-www-form-urlencoded" -Body $body $properties = @{ accessToken = $response.access_token refreshToken = $response.refresh_token jwt = $response.id_token } } Else { ## Exchange a refresh token for new tokens $grantType = "refresh_token" $uri = $tokenEndpoint $body = @{client_id=$clientid;grant_type=$grantType;client_secret=$accessKey;refresh_token=$refreshtoken} $response = Invoke-RestMethod -Method Post -Uri $uri -ContentType "application/x-www-form-urlencoded" -Body $body $properties = @{ accessToken = $response.access_token refreshToken = $response.refresh_token jwt = $response.id_token } } } End { return $properties } } #endregion #region Azure Price Sheets function Get-AzurePriceSheet { <# .Synopsis Get current price sheet from enterprise portal .DESCRIPTION Use this call to get a price sheet of resources from the EA portal using an API key .PARAMETER key API key gathered from the EA portal for use with billing API. .PARAMETER enrollment Your Enterprise Enrollment number. Available form the EA portal. .PARAMETER billingPeriodID An optional parameter to specify that you wish to get from the following year and month. Format YYYYMM .EXAMPLE $result = Get-AzurePriceSheet -key 'apiKeyFromEAPortal' -enrollment 'EAEnrollmentNumber' .EXAMPLE $result = Get-AzurePriceSheet -key 'apiKeyFromEAPortal' -enrollment 'EAEnrollmentNumber' -billingPeriodID '201701' .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string]$key, [Parameter(Mandatory=$true)] [string]$enrollment, [string]$billingPeriodID ) Begin{ $header = @{"authorization"="bearer $key"} If (-not $billingPeriodID){$uri = "https://consumption.azure.com/v2/enrollments/$enrollment/pricesheet"} Else {$uri = "https://consumption.azure.com/v2/enrollments/$enrollment/billingPeriods/$billingPeriodID/pricesheet"} } Process { $response = Invoke-WebRequest -Uri $uri -Headers $header $return = $response.Content |ConvertFrom-Json } End { return $return } } function Get-AzureBillingPeriods { <# .Synopsis Get current available billing periods, and some metadata around them. .DESCRIPTION A call to get available billing periods from your EA portal. .PARAMETER key API key gathered from the EA portal for use with billing API. .PARAMETER enrollment Your Enterprise Enrollment number. Available form the EA portal. .EXAMPLE $result = Get-AzureBillingPeriods -key 'apiKeyFromEAPortal' -enrollment 'EAEnrollmentNumber' .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string]$key, [Parameter(Mandatory=$true)] [string]$enrollment ) Begin{ $header = @{"authorization"="bearer $key"} $uri = "https://consumption.azure.com/v2/enrollments/$enrollment/billingPeriods" } Process { $response = Invoke-WebRequest -Uri $uri -Headers $header $return = $response.Content |ConvertFrom-Json } End { return $return } } #endregion #region Azure Usage function Get-AzureUsageJSON { <# .Synopsis Get azure usage in a JSON format directly .DESCRIPTION There are other options for retrieving usage information. Directly as a CSV non-polling, polling, or JSON. If no billing period is included. The current month cycle will be retreived. .PARAMETER key API key gathered from the EA portal for use with billing API. .PARAMETER enrollment Your Enterprise Enrollment number. Available form the EA portal. .PARAMETER billingPeriod An optional parameter to specify that you wish to get from the following year and month. Format YYYYMM .PARAMETER startDate Start date time of the query - ####-##-## year, month, day = 2017-01-28 .PARAMETER endDate End date time of the query - ####-##-## year, month, day = 2017-01-28 .EXAMPLE $result = Get-AzureUsageJSON -key 'apiKeyFromEAPortal' -enrollment 'EAEnrollmentNumber' .EXAMPLE $result = Get-AzureUsageJSON -key 'apiKeyFromEAPortal' -enrollment 'EAEnrollmentNumber' -billingPeriod '201701' .EXAMPLE $result = Get-AzureUsageJSON -key 'apiKeyFromEAPortal' -enrollment 'EAEnrollmentNumber' -startDate '20170515' -endDate '20170602' .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string] $enrollment, [Parameter(Mandatory=$true)] [string] $key, [string]$billingPeriod, ## year + month [ValidateLength(1,10)] [string]$startDate, ####-##-## year, month, day = 2017-01-28 [ValidateLength(1,10)] [string]$endDate ####-##-## year, month, day = 2017-01-28 ) Begin{ $header = @{"authorization"="bearer $key"} If ($billingPeriod -eq ''){$uri = "https://consumption.azure.com/v3/enrollments/$enrollment/usagedetails"} Else {$uri = "https://consumption.azure.com/v3/enrollments/$enrollment/billingPeriods/$billingPeriod/usagedetails"} if ($startDate -ne '') {if ($endDate -ne ''){$uri = "https://consumption.azure.com/v3/enrollments/$enrollment/usagedetailsbycustomdate?startTime=$startDate&endTime=$endDate"}} } Process { $usage = @() while ($uri -ne $null) { $response = Invoke-RestMethod $uri -Headers $header $usage += $response.data If($response.nextLink){$uri = $response.nextlink} Else{$uri = $null} } } End { return $usage } } function Get-AzureUsageCSV { <# .Synopsis Get azure usage directly as a CSV (as if downloading from the web UI) .DESCRIPTION There are other options for retrieving usage information. Directly as a CSV non-polling, polling, or JSON. .PARAMETER key API key gathered from the EA portal for use with billing API. .PARAMETER enrollment Your Enterprise Enrollment number. Available form the EA portal. .PARAMETER billingPeriodID An optional parameter to specify that you wish to get from the following year and month. Format YYYYMM .PARAMETER outputDir A directory for outputing a CSV of collected data. .EXAMPLE $result = Get-AzureUsageCSV -key 'apiKeyFromEAPortal' -enrollment 'EAEnrollmentNumber' -billingPeriodID '201701' -outputDir 'c:\' .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string] $enrollment, [Parameter(Mandatory=$true)] [string] $key, [Parameter(Mandatory=$true)] [string]$billingPeriod, ## year+month [Parameter(Mandatory=$true)] [string]$outputDir ) Begin{ $header = @{"authorization"="bearer $key"} $uri = "https://consumption.azure.com/v2/enrollments/$enrollment/usagedetails/download?billingPeriod=$billingPeriod" If ($outputDir -notlike '*\') {$outputDir = $outputDir + '\'} $outfile = $outputDir+"AzureUsage-"+"$billingPeriod"+".csv" } Process { $response = Invoke-WebRequest $uri -Headers $header -OutFile $outfile |Out-Null } End { return $response } } function Get-AzureUsageCSVcustomDate { <# .Synopsis Get azure usage in a CSV format directly - providing a custom date range .DESCRIPTION There are other options for retrieving usage information. Directly as a CSV non-polling, polling, or JSON. This method requests a custom data file be generated (up to 36 months of data). It is saved to a blob storage point. The function will poll that location until it is available, then output the csv. .PARAMETER key API key gathered from the EA portal for use with billing API. .PARAMETER enrollment Your Enterprise Enrollment number. Available form the EA portal. .PARAMETER billingPeriodID An optional parameter to specify that you wish to get from the following year and month. Format YYYYMM .PARAMETER startDate Start date time of the query - ####-##-## year, month, day = 2017-01-28 .PARAMETER endDate End date time of the query - ####-##-## year, month, day = 2017-01-28 .EXAMPLE $result = Get-AzureUsageCSV -key 'apiKeyFromEAPortal' -enrollment 'EAEnrollmentNumber' -startDate '20170515' -endDate '20170602' -outputDir 'c:\' .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string] $enrollment, [Parameter(Mandatory=$true)] [string] $key, [Parameter(Mandatory=$true)] [string]$outputDir, [Parameter(Mandatory=$true)] [ValidateLength(1,10)] [string]$startDate, ####-##-## year, month, day = 2017-01-28 [Parameter(Mandatory=$true)] [ValidateLength(1,10)] [string]$endDate ####-##-## year, month, day = 2017-01-28 ) Begin{ $header = @{"authorization"="bearer $key"} $uri = "https://consumption.azure.com/v2/enrollments/$enrollment/usagedetails/submit?startTime=$startDate&endTime=$endDate" If ($outputDir -notlike '*\') {$outputDir = $outputDir + '\'} $outfile = $outputDir+"AzureUsage-"+"$startDate"+"_"+"$endDate"+".csv" } Process { $results = Invoke-WebRequest -Method Post $uri -Headers $header $temp = $results.Content |ConvertFrom-Json $status = '' while ($status -eq '') { $test = Invoke-WebRequest -Method get -Uri ($temp.reportUrl) -Headers $header $json = $test.Content |Convertfrom-Json $status = $json.status } If ($status -eq '3') { $results = Invoke-WebRequest -Method post -Uri ($json.blobPath) -Headers $header -OutFile $outfile } } End { return $results } } function Get-AzureEnrollmentConsumption { <# .Synopsis Get azure usage in a JSON format .DESCRIPTION This is using the modern Consumption API .PARAMETER accessToken accessToken for access to Consumption API .PARAMETER enrollment Your Enterprise Enrollment number. Available form the EA portal. .PARAMETER billingPeriod An optional parameter to specify that you wish to get from the following year and month. Format YYYYMM .EXAMPLE $result = Get-AzureEnrollmentConsumption -accessToken $token -enrollment 'EAEnrollmentNumber' .EXAMPLE $result = Get-AzureEnrollmentConsumption -accessToken $token -enrollment 'EAEnrollmentNumber' -billingPeriod '201701' .EXAMPLE $result = Get-AzureEnrollmentConsumption -accessToken $token -enrollment 'EAEnrollmentNumber' -startDate '20170515' -endDate '20170602' .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string] $enrollment, [Parameter(Mandatory=$true)] [string] $accessToken, [string]$billingPeriod ## year + month ) Begin{ $header = @{"authorization"="bearer $accessToken"} If ($billingPeriod -eq ''){ $scope = "/providers/Microsoft.Billing/billingAccounts/$enrollment" $uri = "https://management.azure.com/$scope/providers/Microsoft.Consumption/usageDetails?api-version=2019-10-01" } Else { $scope = "/providers/Microsoft.Billing/billingAccounts/$enrollment/providers/Microsoft.Billing/billingPeriods/$billingPeriod" $uri = "https://management.azure.com/$scope/providers/Microsoft.Consumption/usageDetails?api-version=2019-10-01" } } Process { $usage = @() while ($uri) { $response = Invoke-RestMethod $uri -Headers $header -method Get $usage += $response.value.properties If($response.nextLink) { $uri = $response.nextlink Start-Sleep -seconds 5 } Else{$uri = $null} } } End { return $usage } } function Get-AzureMarketplaceConsumption { <# .Synopsis Get azure marketplace consumption in a JSON format .DESCRIPTION Using the modern consumption API .PARAMETER accessToken accessToken for access to Consumption API .PARAMETER enrollment Your Enterprise Enrollment number. Available form the EA portal. .PARAMETER billingPeriod An optional parameter to specify that you wish to get from the following year and month. Format YYYYMM .EXAMPLE $result = Get-AzureEnrollmentConsumption -accessToken $token -enrollment 'EAEnrollmentNumber' .EXAMPLE $result = Get-AzureEnrollmentConsumption -accessToken $token -enrollment 'EAEnrollmentNumber' -billingPeriod '201701' .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string] $enrollment, [Parameter(Mandatory=$true)] [string] $accessToken, [string]$billingPeriod ## year + month ) Begin{ $header = @{"authorization"="bearer $accessToken"} If ($billingPeriod -eq ''){ $scope = "/providers/Microsoft.Billing/billingAccounts/$enrollment" $uri = "https://management.azure.com/$scope/providers/Microsoft.Consumption/marketplaces?api-version=2019-10-01" } Else { $scope = "/providers/Microsoft.Billing/billingAccounts/$enrollment/providers/Microsoft.Billing/billingPeriods/$billingPeriod" $uri = "https://management.azure.com/$scope/providers/Microsoft.Consumption/marketplaces?api-version=2018-06-30" } } Process { $usage = @() while ($uri) { $response = Invoke-RestMethod $uri -Headers $header -method Get $usage += $response.value.properties If($response.nextLink){$uri = $response.nextlink} Else{$uri = $null} } } End { return $usage } } function Get-AzureReservedInstanceConsumption { <# .Synopsis Get azure RI consumption in a JSON format .DESCRIPTION Using the modern Consumption API .PARAMETER accessToken accessToken for access to Consumption API .PARAMETER enrollment Your Enterprise Enrollment number. Available form the EA portal. .PARAMETER billingPeriod An optional parameter to specify that you wish to get from the following year and month. Format YYYYMM .EXAMPLE $result = Get-AzureReservedInstanceConsumption -accessToken $token -enrollment 'EAEnrollmentNumber' .EXAMPLE $result = Get-AzureReservedInstanceConsumption -accessToken $token -enrollment 'EAEnrollmentNumber' -billingPeriod '2017-01' .Notes Author: Kyle Weeks #> param ( [Parameter(Mandatory=$true)] [string] $enrollment, [Parameter(Mandatory=$true)] [string] $accessToken, [string]$billingPeriod ## year + month ) Begin{ $header = @{"authorization"="bearer $accessToken"} $date = get-date -date $billingPeriod $year = $date.Year $month = $date.Month $nextMonth = $date.AddMonths(1) $lastday = $nextMonth.AddTicks(-1) $endDay = get-date -date $lastDay -format yyyy-MM-dd $startDay = Get-Date -Year $year -Month $month -Day 1 -Format yyyy-MM-dd $filter = "properties/eventDate+ge+$startday+AND+properties/eventDate+le+$endDay&api-version=2019-10-01" $uri = "https://management.azure.com/providers/Microsoft.Billing/billingAccounts/$enrollment" + '/providers/Microsoft.Consumption/reservationTransactions?$filter=' + "$filter" } Process { $usage = @() while ($uri) { $response = Invoke-RestMethod $uri -Headers $header -method Get $usage += $response.value.properties If($response.nextLink){$uri = $response.nextlink} Else{$uri = $null} } } End { return $usage } } #endregion # SIG # Begin signature block # MIIlRQYJKoZIhvcNAQcCoIIlNjCCJTICAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB # gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR # AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQU0PAIJr8yZNZrvaaeblYgIJ2E # R/eggh8tMIIFgTCCBGmgAwIBAgIQOXJEOvkit1HX02wQ3TE1lTANBgkqhkiG9w0B # AQwFADB7MQswCQYDVQQGEwJHQjEbMBkGA1UECAwSR3JlYXRlciBNYW5jaGVzdGVy # MRAwDgYDVQQHDAdTYWxmb3JkMRowGAYDVQQKDBFDb21vZG8gQ0EgTGltaXRlZDEh # MB8GA1UEAwwYQUFBIENlcnRpZmljYXRlIFNlcnZpY2VzMB4XDTE5MDMxMjAwMDAw # MFoXDTI4MTIzMTIzNTk1OVowgYgxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpOZXcg # SmVyc2V5MRQwEgYDVQQHEwtKZXJzZXkgQ2l0eTEeMBwGA1UEChMVVGhlIFVTRVJU # UlVTVCBOZXR3b3JrMS4wLAYDVQQDEyVVU0VSVHJ1c3QgUlNBIENlcnRpZmljYXRp # b24gQXV0aG9yaXR5MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAgBJl # FzYOw9sIs9CsVw127c0n00ytUINh4qogTQktZAnczomfzD2p7PbPwdzx07HWezco # EStH2jnGvDoZtF+mvX2do2NCtnbyqTsrkfjib9DsFiCQCT7i6HTJGLSR1GJk23+j # BvGIGGqQIjy8/hPwhxR79uQfjtTkUcYRZ0YIUcuGFFQ/vDP+fmyc/xadGL1RjjWm # p2bIcmfbIWax1Jt4A8BQOujM8Ny8nkz+rwWWNR9XWrf/zvk9tyy29lTdyOcSOk2u # TIq3XJq0tyA9yn8iNK5+O2hmAUTnAU5GU5szYPeUvlM3kHND8zLDU+/bqv50TmnH # a4xgk97Exwzf4TKuzJM7UXiVZ4vuPVb+DNBpDxsP8yUmazNt925H+nND5X4OpWax # KXwyhGNVicQNwZNUMBkTrNN9N6frXTpsNVzbQdcS2qlJC9/YgIoJk2KOtWbPJYjN # hLixP6Q5D9kCnusSTJV882sFqV4Wg8y4Z+LoE53MW4LTTLPtW//e5XOsIzstAL81 # VXQJSdhJWBp/kjbmUZIO8yZ9HE0XvMnsQybQv0FfQKlERPSZ51eHnlAfV1SoPv10 # Yy+xUGUJ5lhCLkMaTLTwJUdZ+gQek9QmRkpQgbLevni3/GcV4clXhB4PY9bpYrrW # X1Uu6lzGKAgEJTm4Diup8kyXHAc/DVL17e8vgg8CAwEAAaOB8jCB7zAfBgNVHSME # GDAWgBSgEQojPpbxB+zirynvgqV/0DCktDAdBgNVHQ4EFgQUU3m/WqorSs9UgOHY # m8Cd8rIDZsswDgYDVR0PAQH/BAQDAgGGMA8GA1UdEwEB/wQFMAMBAf8wEQYDVR0g # BAowCDAGBgRVHSAAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwuY29tb2Rv # Y2EuY29tL0FBQUNlcnRpZmljYXRlU2VydmljZXMuY3JsMDQGCCsGAQUFBwEBBCgw # JjAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuY29tb2RvY2EuY29tMA0GCSqGSIb3 # DQEBDAUAA4IBAQAYh1HcdCE9nIrgJ7cz0C7M7PDmy14R3iJvm3WOnnL+5Nb+qh+c # li3vA0p+rvSNb3I8QzvAP+u431yqqcau8vzY7qN7Q/aGNnwU4M309z/+3ri0ivCR # lv79Q2R+/czSAaF9ffgZGclCKxO/WIu6pKJmBHaIkU4MiRTOok3JMrO66BQavHHx # W/BBC5gACiIDEOUMsfnNkjcZ7Tvx5Dq2+UUTJnWvu6rvP3t3O9LEApE9GQDTF1w5 # 2z97GA1FzZOFli9d31kWTz9RvdVFGD/tSo7oBmF0Ixa1DVBzJ0RHfxBdiSprhTEU # xOipakyAvGp4z7h/jnZymQyd/teRCBaho1+VMIIFujCCBKKgAwIBAgIQRbkDLNyj # y9TlrnXGABPhkzANBgkqhkiG9w0BAQsFADB8MQswCQYDVQQGEwJVUzELMAkGA1UE # CBMCTUkxEjAQBgNVBAcTCUFubiBBcmJvcjESMBAGA1UEChMJSW50ZXJuZXQyMREw # DwYDVQQLEwhJbkNvbW1vbjElMCMGA1UEAxMcSW5Db21tb24gUlNBIENvZGUgU2ln # bmluZyBDQTAeFw0yMDEyMTEwMDAwMDBaFw0yMzEyMTEyMzU5NTlaMIHPMQswCQYD # VQQGEwJVUzEOMAwGA1UEEQwFNTU0NTUxEjAQBgNVBAgMCU1pbm5lc290YTEUMBIG # A1UEBwwLTWlubmVhcG9saXMxHDAaBgNVBAkMEzEwMCBVbmlvbiBTdHJlZXQgU0Ux # IDAeBgNVBAoMF1VuaXZlcnNpdHkgb2YgTWlubmVzb3RhMSQwIgYDVQQLDBtDb21w # dXRlciBhbmQgRGV2aWNlIFN1cHBvcnQxIDAeBgNVBAMMF1VuaXZlcnNpdHkgb2Yg # TWlubmVzb3RhMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA18YBwbvE # uOqjXUWH3KajxBfWsHL1BVnbCnmklAmdP0nVD00oLJJ8mut6yXzkvm+2+ukAp7Ij # kE0b9AAU3oSNVAyzUTu3WoGW1E9wdsSM1E+/+01erEitMRxgJD0CgfH22tEtbI/7 # d+7TcTSlga+vaO3CHNEmuqOotBpbBlQw29hlLUccUJNaE0qg8q4SZAOB45lAKfm+ # s2EaVv0xj+wJB4ETAWbj//9I/3/npuQt4/GDwayJJkTarDZtbZea8xc96VN20uPW # x8s6TgzLUC4kPmCD2nlgHV+4zcOsoVi5P3DTalFVngLCWgtEU7L+YnbwH0fsiWWL # 65aFtjaN0U+seQIDAQABo4IB4jCCAd4wHwYDVR0jBBgwFoAUrjUjF///Bj2cUOCM # JGUzHnAQiKIwHQYDVR0OBBYEFPWfK7krHCJBdQnoQDWt+woKsPdoMA4GA1UdDwEB # /wQEAwIHgDAMBgNVHRMBAf8EAjAAMBMGA1UdJQQMMAoGCCsGAQUFBwMDMBEGCWCG # SAGG+EIBAQQEAwIEEDBwBgNVHSAEaTBnMFsGDCsGAQQBriMBBAMCATBLMEkGCCsG # AQUFBwIBFj1odHRwczovL3d3dy5pbmNvbW1vbi5vcmcvY2VydC9yZXBvc2l0b3J5 # L2Nwc19jb2RlX3NpZ25pbmcucGRmMAgGBmeBDAEEATBJBgNVHR8EQjBAMD6gPKA6 # hjhodHRwOi8vY3JsLmluY29tbW9uLXJzYS5vcmcvSW5Db21tb25SU0FDb2RlU2ln # bmluZ0NBLmNybDB+BggrBgEFBQcBAQRyMHAwRAYIKwYBBQUHMAKGOGh0dHA6Ly9j # cnQuaW5jb21tb24tcnNhLm9yZy9JbkNvbW1vblJTQUNvZGVTaWduaW5nQ0EuY3J0 # MCgGCCsGAQUFBzABhhxodHRwOi8vb2NzcC5pbmNvbW1vbi1yc2Eub3JnMBkGA1Ud # EQQSMBCBDm9pdG1wdEB1bW4uZWR1MA0GCSqGSIb3DQEBCwUAA4IBAQBi877I9cSz # qelcex0hoTmE22pMGSWnhS8+KbkrcHi3pM5I7jfxjhnD1UGZbjfZ+M54srmz2kZ5 # 9+EiB1K2RVAz8owivQn3wCJ7ZSea0AVu+BTsYQ4tMvvilkbtLO2weftoPdhBjrSc # uRYTgwvbgbQCPZtNcKr1Nui1wffMF/VmZfpH2vnuh6bJ9XzdtXiv93JGMsOByC2h # gHHiXUFTJWtyWj3PwbZTQ5LV6Yx+NuZ1jBrODbY17lCSP6+ebam+azC8Uv26VIz1 # bL/2ohImhYiU1966pkJlnBhcHM4b+uvqRtUgi2tCWkgZVsKrAFXcicH0tQi7lPX0 # 4vQvQRAcUmXkMIIF6zCCA9OgAwIBAgIQZeHi49XeUEWF8yYkgAXi1DANBgkqhkiG # 9w0BAQ0FADCBiDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCk5ldyBKZXJzZXkxFDAS # BgNVBAcTC0plcnNleSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNUIE5ldHdv # cmsxLjAsBgNVBAMTJVVTRVJUcnVzdCBSU0EgQ2VydGlmaWNhdGlvbiBBdXRob3Jp # dHkwHhcNMTQwOTE5MDAwMDAwWhcNMjQwOTE4MjM1OTU5WjB8MQswCQYDVQQGEwJV # UzELMAkGA1UECBMCTUkxEjAQBgNVBAcTCUFubiBBcmJvcjESMBAGA1UEChMJSW50 # ZXJuZXQyMREwDwYDVQQLEwhJbkNvbW1vbjElMCMGA1UEAxMcSW5Db21tb24gUlNB # IENvZGUgU2lnbmluZyBDQTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEB # AMCgL4seertqdaz4PtyjujkiyvOjduS/fTAn5rrTmDJWI1wGhpcNgOjtooE16wv2 # Xn6pPmhz/Z3UZ3nOqupotxnbHHY6WYddXpnHobK4qYRzDMyrh0YcasfvOSW+p93a # LDVwNh0iLiA73eMcDj80n+V9/lWAWwZ8gleEVfM4+/IMNqm5XrLFgUcjfRKBoMAB # KD4D+TiXo60C8gJo/dUBq/XVUU1Q0xciRuVzGOA65Dd3UciefVKKT4DcJrnATMr8 # UfoQCRF6VypzxOAhKmzCVL0cPoP4W6ks8frbeM/ZiZpto/8Npz9+TFYj1gm+4aUd # iwfFv+PfWKrvpK+CywX4CgkCAwEAAaOCAVowggFWMB8GA1UdIwQYMBaAFFN5v1qq # K0rPVIDh2JvAnfKyA2bLMB0GA1UdDgQWBBSuNSMX//8GPZxQ4IwkZTMecBCIojAO # BgNVHQ8BAf8EBAMCAYYwEgYDVR0TAQH/BAgwBgEB/wIBADATBgNVHSUEDDAKBggr # BgEFBQcDAzARBgNVHSAECjAIMAYGBFUdIAAwUAYDVR0fBEkwRzBFoEOgQYY/aHR0 # cDovL2NybC51c2VydHJ1c3QuY29tL1VTRVJUcnVzdFJTQUNlcnRpZmljYXRpb25B # dXRob3JpdHkuY3JsMHYGCCsGAQUFBwEBBGowaDA/BggrBgEFBQcwAoYzaHR0cDov # L2NydC51c2VydHJ1c3QuY29tL1VTRVJUcnVzdFJTQUFkZFRydXN0Q0EuY3J0MCUG # CCsGAQUFBzABhhlodHRwOi8vb2NzcC51c2VydHJ1c3QuY29tMA0GCSqGSIb3DQEB # DQUAA4ICAQBGLLZ/ak4lZr2caqaq0J69D65ONfzwOCfBx50EyYI024bhE/fBlo0w # RBPSNe1591dck6YSV22reZfBJmTfyVzLwzaibZMjoduqMAJr6rjAhdaSokFsrgw5 # ZcUfTBAqesReMJx9THLOFnizq0D8vguZFhOYIP+yunPRtVTcC5Jf6aPTkT5Y8Sin # hYT4Pfk4tycxyMVuy3cpY333HForjRUedfwSRwGSKlA8Ny7K3WFs4IOMdOrYDLzh # H9JyE3paRU8albzLSYZzn2W6XV2UOaNU7KcX0xFTkALKdOR1DQl8oc55VS69CWjZ # DO3nYJOfc5nU20hnTKvGbbrulcq4rzpTEj1pmsuTI78E87jaK28Ab9Ay/u3MmQae # zWGaLvg6BndZRWTdI1OSLECoJt/tNKZ5yeu3K3RcH8//G6tzIU4ijlhG9OBU9zmV # afo872goR1i0PIGwjkYApWmatR92qiOyXkZFhBBKek7+FgFbK/4uy6F1O9oDm/Ag # MzxasCOBMXHa8adCODl2xAh5Q6lOLEyJ6sJTMKH5sXjuLveNfeqiKiUJfvEspJdO # lZLajLsfOCMN2UCx9PCfC2iflg1MnHODo2OtSOxRsQg5G0kH956V3kRZtCAZ/Bol # vk0Q5OidlyRS1hLVWZoW6BZQS6FJah1AirtEDoVP/gBDqp2PfI9s0TCCBuwwggTU # oAMCAQICEDAPb6zdZph0fKlGNqd4LbkwDQYJKoZIhvcNAQEMBQAwgYgxCzAJBgNV # BAYTAlVTMRMwEQYDVQQIEwpOZXcgSmVyc2V5MRQwEgYDVQQHEwtKZXJzZXkgQ2l0 # eTEeMBwGA1UEChMVVGhlIFVTRVJUUlVTVCBOZXR3b3JrMS4wLAYDVQQDEyVVU0VS # VHJ1c3QgUlNBIENlcnRpZmljYXRpb24gQXV0aG9yaXR5MB4XDTE5MDUwMjAwMDAw # MFoXDTM4MDExODIzNTk1OVowfTELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0 # ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBxMHU2FsZm9yZDEYMBYGA1UEChMPU2VjdGln # byBMaW1pdGVkMSUwIwYDVQQDExxTZWN0aWdvIFJTQSBUaW1lIFN0YW1waW5nIENB # MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAyBsBr9ksfoiZfQGYPyCQ # vZyAIVSTuc+gPlPvs1rAdtYaBKXOR4O168TMSTTL80VlufmnZBYmCfvVMlJ5Lslj # whObtoY/AQWSZm8hq9VxEHmH9EYqzcRaydvXXUlNclYP3MnjU5g6Kh78zlhJ07/z # Obu5pCNCrNAVw3+eolzXOPEWsnDTo8Tfs8VyrC4Kd/wNlFK3/B+VcyQ9ASi8Dw1P # s5EBjm6dJ3VV0Rc7NCF7lwGUr3+Az9ERCleEyX9W4L1GnIK+lJ2/tCCwYH64TfUN # P9vQ6oWMilZx0S2UTMiMPNMUopy9Jv/TUyDHYGmbWApU9AXn/TGs+ciFF8e4KRmk # KS9G493bkV+fPzY+DjBnK0a3Na+WvtpMYMyou58NFNQYxDCYdIIhz2JWtSFzEh79 # qsoIWId3pBXrGVX/0DlULSbuRRo6b83XhPDX8CjFT2SDAtT74t7xvAIo9G3aJ4oG # 0paH3uhrDvBbfel2aZMgHEqXLHcZK5OVmJyXnuuOwXhWxkQl3wYSmgYtnwNe/YOi # U2fKsfqNoWTJiJJZy6hGwMnypv99V9sSdvqKQSTUG/xypRSi1K1DHKRJi0E5FAMe # KfobpSKupcNNgtCN2mu32/cYQFdz8HGj+0p9RTbB942C+rnJDVOAffq2OVgy728Y # UInXT50zvRq1naHelUF6p4MCAwEAAaOCAVowggFWMB8GA1UdIwQYMBaAFFN5v1qq # K0rPVIDh2JvAnfKyA2bLMB0GA1UdDgQWBBQaofhhGSAPw0F3RSiO0TVfBhIEVTAO # BgNVHQ8BAf8EBAMCAYYwEgYDVR0TAQH/BAgwBgEB/wIBADATBgNVHSUEDDAKBggr # BgEFBQcDCDARBgNVHSAECjAIMAYGBFUdIAAwUAYDVR0fBEkwRzBFoEOgQYY/aHR0 # cDovL2NybC51c2VydHJ1c3QuY29tL1VTRVJUcnVzdFJTQUNlcnRpZmljYXRpb25B # dXRob3JpdHkuY3JsMHYGCCsGAQUFBwEBBGowaDA/BggrBgEFBQcwAoYzaHR0cDov # L2NydC51c2VydHJ1c3QuY29tL1VTRVJUcnVzdFJTQUFkZFRydXN0Q0EuY3J0MCUG # CCsGAQUFBzABhhlodHRwOi8vb2NzcC51c2VydHJ1c3QuY29tMA0GCSqGSIb3DQEB # DAUAA4ICAQBtVIGlM10W4bVTgZF13wN6MgstJYQRsrDbKn0qBfW8Oyf0WqC5SVmQ # KWxhy7VQ2+J9+Z8A70DDrdPi5Fb5WEHP8ULlEH3/sHQfj8ZcCfkzXuqgHCZYXPO0 # EQ/V1cPivNVYeL9IduFEZ22PsEMQD43k+ThivxMBxYWjTMXMslMwlaTW9JZWCLjN # XH8Blr5yUmo7Qjd8Fng5k5OUm7Hcsm1BbWfNyW+QPX9FcsEbI9bCVYRm5LPFZgb2 # 89ZLXq2jK0KKIZL+qG9aJXBigXNjXqC72NzXStM9r4MGOBIdJIct5PwC1j53BLwE # NrXnd8ucLo0jGLmjwkcd8F3WoXNXBWiap8k3ZR2+6rzYQoNDBaWLpgn/0aGUpk6q # PQn1BWy30mRa2Coiwkud8TleTN5IPZs0lpoJX47997FSkc4/ifYcobWpdR9xv1tD # XWU9UIFuq/DQ0/yysx+2mZYm9Dx5i1xkzM3uJ5rloMAMcofBbk1a0x7q8ETmMm8c # 6xdOlMN4ZSA7D0GqH+mhQZ3+sbigZSo04N6o+TzmwTC7wKBjLPxcFgCo0MR/6hGd # HgbGpm0yXbQ4CStJB6r97DDa8acvz7f9+tCjhNknnvsBZne5VhDhIG7GrrH5trrI # NV0zdo7xfCAMKneutaIChrop7rRaALGMq+P5CslUXdS5anSevUiumDCCBwcwggTv # oAMCAQICEQCMd6AAj/TRsMY9nzpIg41rMA0GCSqGSIb3DQEBDAUAMH0xCzAJBgNV # BAYTAkdCMRswGQYDVQQIExJHcmVhdGVyIE1hbmNoZXN0ZXIxEDAOBgNVBAcTB1Nh # bGZvcmQxGDAWBgNVBAoTD1NlY3RpZ28gTGltaXRlZDElMCMGA1UEAxMcU2VjdGln # byBSU0EgVGltZSBTdGFtcGluZyBDQTAeFw0yMDEwMjMwMDAwMDBaFw0zMjAxMjIy # MzU5NTlaMIGEMQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVz # dGVyMRAwDgYDVQQHEwdTYWxmb3JkMRgwFgYDVQQKEw9TZWN0aWdvIExpbWl0ZWQx # LDAqBgNVBAMMI1NlY3RpZ28gUlNBIFRpbWUgU3RhbXBpbmcgU2lnbmVyICMyMIIC # IjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAkYdLLIvB8R6gntMHxgHKUrC+ # eXldCWYGLS81fbvA+yfaQmpZGyVM6u9A1pp+MshqgX20XD5WEIE1OiI2jPv4ICmH # rHTQG2K8P2SHAl/vxYDvBhzcXk6Th7ia3kwHToXMcMUNe+zD2eOX6csZ21ZFbO5L # IGzJPmz98JvxKPiRmar8WsGagiA6t+/n1rglScI5G4eBOcvDtzrNn1AEHxqZpIAC # TR0FqFXTbVKAg+ZuSKVfwYlYYIrv8azNh2MYjnTLhIdBaWOBvPYfqnzXwUHOrat2 # iyCA1C2VB43H9QsXHprl1plpUcdOpp0pb+d5kw0yY1OuzMYpiiDBYMbyAizE+cgi # 3/kngqGDUcK8yYIaIYSyl7zUr0QcloIilSqFVK7x/T5JdHT8jq4/pXL0w1oBqlCl # i3aVG2br79rflC7ZGutMJ31MBff4I13EV8gmBXr8gSNfVAk4KmLVqsrf7c9Tqx/2 # RJzVmVnFVmRb945SD2b8mD9EBhNkbunhFWBQpbHsz7joyQu+xYT33Qqd2rwpbD1W # 7b94Z7ZbyF4UHLmvhC13ovc5lTdvTn8cxjwE1jHFfu896FF+ca0kdBss3Pl8qu/C # dkloYtWL9QPfvn2ODzZ1RluTdsSD7oK+LK43EvG8VsPkrUPDt2aWXpQy+qD2q4lQ # +s6g8wiBGtFEp8z3uDECAwEAAaOCAXgwggF0MB8GA1UdIwQYMBaAFBqh+GEZIA/D # QXdFKI7RNV8GEgRVMB0GA1UdDgQWBBRpdTd7u501Qk6/V9Oa258B0a7e0DAOBgNV # HQ8BAf8EBAMCBsAwDAYDVR0TAQH/BAIwADAWBgNVHSUBAf8EDDAKBggrBgEFBQcD # CDBABgNVHSAEOTA3MDUGDCsGAQQBsjEBAgEDCDAlMCMGCCsGAQUFBwIBFhdodHRw # czovL3NlY3RpZ28uY29tL0NQUzBEBgNVHR8EPTA7MDmgN6A1hjNodHRwOi8vY3Js # LnNlY3RpZ28uY29tL1NlY3RpZ29SU0FUaW1lU3RhbXBpbmdDQS5jcmwwdAYIKwYB # BQUHAQEEaDBmMD8GCCsGAQUFBzAChjNodHRwOi8vY3J0LnNlY3RpZ28uY29tL1Nl # Y3RpZ29SU0FUaW1lU3RhbXBpbmdDQS5jcnQwIwYIKwYBBQUHMAGGF2h0dHA6Ly9v # Y3NwLnNlY3RpZ28uY29tMA0GCSqGSIb3DQEBDAUAA4ICAQBKA3iQQjPsexqDCTYz # mFW7nUAGMGtFavGUDhlQ/1slXjvhOcRbuumVkDc3vd/7ZOzlgreVzFdVcEtO9KiH # 3SKFple7uCEn1KAqMZSKByGeir2nGvUCFctEUJmM7D66A3emggKQwi6Tqb4hNHVj # ueAtD88BN8uNovq4WpquoXqeE5MZVY8JkC7f6ogXFutp1uElvUUIl4DXVCAoT8p7 # s7Ol0gCwYDRlxOPFw6XkuoWqemnbdaQ+eWiaNotDrjbUYXI8DoViDaBecNtkLwHH # waHHJJSjsjxusl6i0Pqo0bglHBbmwNV/aBrEZSk1Ki2IvOqudNaC58CIuOFPePBc # ysBAXMKf1TIcLNo8rDb3BlKao0AwF7ApFpnJqreISffoCyUztT9tr59fClbfErHD # 7s6Rd+ggE+lcJMfqRAtK5hOEHE3rDbW4hqAwp4uhn7QszMAWI8mR5UIDS4DO5E3m # KgE+wF6FoCShF0DV29vnmBCk8eoZG4BU+keJ6JiBqXXADt/QaJR5oaCejra3QmbL # 2dlrL03Y3j4yHiDk7JxNQo2dxzOZgjdE1CYpJkCOeC+57vov8fGP/lC4eN0Ult4c # DnCwKoVqsWxo6SrkECtuIf3TfJ035CoG1sPx12jjTwd5gQgT/rJkXumxPObQeCOy # CSziJmK/O6mXUczHRDKBsq/P3zGCBYIwggV+AgEBMIGQMHwxCzAJBgNVBAYTAlVT # MQswCQYDVQQIEwJNSTESMBAGA1UEBxMJQW5uIEFyYm9yMRIwEAYDVQQKEwlJbnRl # cm5ldDIxETAPBgNVBAsTCEluQ29tbW9uMSUwIwYDVQQDExxJbkNvbW1vbiBSU0Eg # Q29kZSBTaWduaW5nIENBAhBFuQMs3KPL1OWudcYAE+GTMAkGBSsOAwIaBQCgeDAY # BgorBgEEAYI3AgEMMQowCKACgAChAoAAMBkGCSqGSIb3DQEJAzEMBgorBgEEAYI3 # AgEEMBwGCisGAQQBgjcCAQsxDjAMBgorBgEEAYI3AgEVMCMGCSqGSIb3DQEJBDEW # BBSTuim3nXN2xl0Tp8niPY+cut30pTANBgkqhkiG9w0BAQEFAASCAQApQOzhRjk7 # TEAVo4e9IZ7eEvqrnaQpHve828Gqz955SpQfSbPcZ470QMc3MD28t73BaYbgY63d # n8sAe4WIJqCoAkjm00+0QRRGNg310rUKgweii9Zqvh1VaAlinpkWq2a9z2NjfZMo # P0fcULi5bbyGqP9USBKe2xBo1H0kzOlBUHtrJzKkmhaNXFVYFsigQwI4Xs+7HqQs # LfBnPyryVoH8vCuTR1thRKggsyeT0Uu9o6ndOGaZu9Wl5xNnqLU1Fox1miH07/KA # WB1bfFt9IcOjFJQCko1bymAEEISiP7lknpw+taqB/QC8FRcrqB931408sU4B2jTW # eivdVzOL2jkNoYIDTDCCA0gGCSqGSIb3DQEJBjGCAzkwggM1AgEBMIGSMH0xCzAJ # BgNVBAYTAkdCMRswGQYDVQQIExJHcmVhdGVyIE1hbmNoZXN0ZXIxEDAOBgNVBAcT # B1NhbGZvcmQxGDAWBgNVBAoTD1NlY3RpZ28gTGltaXRlZDElMCMGA1UEAxMcU2Vj # dGlnbyBSU0EgVGltZSBTdGFtcGluZyBDQQIRAIx3oACP9NGwxj2fOkiDjWswDQYJ # YIZIAWUDBAICBQCgeTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3 # DQEJBTEPFw0yMTAzMTAyMDAzMTlaMD8GCSqGSIb3DQEJBDEyBDCwfShcl14OTTAY # TKWhmtxUPHyEWUPPcGB7g48TThKooGy7SYPxmG2ZmV2frx28idcwDQYJKoZIhvcN # AQEBBQAEggIABRbPeGX7pySM6kxoIl3DoLVQL6hLy2GWx54NQys+6GsbrUY8FlAR # lgncrEfP++bPDraSaF/44HoacKOSmvJk4IHYeEYuGmXgiSGU55gcVv7kGDc71zBL # bAef+MCv1mC36Ace8ANMImfQXy69RfVbxNXasoV3osRQ6RzXqmCXOJXMN0Xi6HIG # bBS7pOPoZccCRnwP3aEXeY60S5PQrvkYg1ZFRlk+tpijKY4CIT7mcGmOyhK8Yw6r # +pvr3VenZ0/pZRBf6qT/BlNebF+G7YKoNsduJVR6AbUUSUcQngu+Tm5G3qewxL5A # 9PQiO4Pxabz+sxHcfEt0Brl7GhctNHDV1vToupwNMv1SAe1qFC9SEckUcN/fNSMD # h32T83EyDSOunmMx0a80f2D+fVnQW1RSZdK+RiXbSMOIUPh6/YWCV3SfHqZuvn9G # +xhukPekWnAKl6BLcHxU/j7W0DOVcUjO86vAKBNRpHeEhWR68Afre51Ka7L0C9Kx # StOp23KKg++kKkA4vQC74IMe+nJCZyfNIFmiweH4vtaMkKN0FrHA3cVd/CKOp45D # wNOKWHUv4gczAtGPdKayhyydW0mMzzWVt0cW7xq6Ma+PxpqpVJ169zB2POrTWNfA # pfa2i+up8ATINq3PwpbTFFeUlQVMfdS15bzMO4cEz4stsCxxQYE1Ohs= # SIG # End signature block |