Private/Get-EnvironmentDefaultsFromStorage.ps1
# Will be called in VM function Global:Get-EnvironmentDefaultsFromStorage { [CmdletBinding()] <# .SYNOPSIS ... .DESCRIPTION ... #> param( [Parameter(Mandatory = $true)] $StorageAccountContext, [Parameter(Mandatory = $false)] [string] $TableName = 'Environments' ) process { $environments = @() $storageAccountTable = Get-AzStorageTable -Name $TableName -Context $StorageAccountContext $cloudTable = $storageAccountTable.CloudTable $rows = Get-AzTableRow -Table $cloudTable foreach ($row in $rows) { $instance = [pscustomobject]@{ ServerInstance = $row.ServiceName; DatabaseServer = $row.DatabaseServer; DatabaseInstance = $row.DatabaseInstance; Databasename = $row.DatabaseName; ClientServicesPort = $row.ClientServicePort ; ManagementServicesPort = $row.ManagementServicePort SoapServicesPort = $row.SoapServicePort; OdataServicesPort = $row.ODataServicePort; DeveloperServicesPort = $row.DeveloperServicePort; Authentication = $row.AuthType Settings = @{ } } $environments += $instance } $environments } } |