Azure PowerShell – List Data Center Locations

Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came up this week when I was preparing to do training with a customer. Part of that meant creating 6 data science VMs. So we updated the software on a VM and went to clone it, ran into some issues and then decided to break out the PowerShell to fix the issue.
For those who use PowerShell to do anything in Azure you will know that you will often need to supply the location parameter. In the portal that’s not a problem, you just select from the drop down menu. However, in PowerShell you have to know exactly what the name of the data center is and how it is formatted. Is it East US 2, EastUS2, East US2, or something else. And then you have to remember that for all the data centers. And there are a bunch of them; we have 50 regions and counting. Thankfully there is a PowerShell cmdlet that will assist with this!
Let’s fire up Azure PowerShell and take a look.
Of course we will want to login with Connect-AzureRmAccount to get started. Then it is a simple cmdlet with no parameters necessary: Get-AzureRmLocation. You can cleanup the output by adding Format-Table.

Get-AzureRmLocation |Format-Table


Take a look at the Providers property in the output.This lists the resources available in the region. This is useful for finding regions that support Azure SQL, for instance.

Get-AzureRmLocation | Where-Object Providers -like "*sql*" | Format-Table


Should you decide that you just want to view all the services in a particular region, it’s not too much extra work.

$providers = Get-AzureRmLocation | Where-Object {$_.Location -eq "eastus2"} | select Providers
$providers.Providers


There you have it. A handy little PowerShell cmdlet that will help you figure out what to put in the location parameter for other cmdlets like creating a Virtual Machine or creating a new Azure SQL Database.
Next week we’ll take a look at finding the virtual machine sizes that are available in each data center and the associated parameter values.

**Update** The next blog has been released: Azure PowerShell – List Virtual Machine Sizes

About the author

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

3 comments

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

Follow Me