Is there a way to retrieve compute model of Azure SQL database in powershell script

Question

I'm trying to get a list of all "Provisioned" (not "Serverless") Azure databases from particular subscription using Powershell. I'm fairly new to ps, so probably I don't see something very obvious. In Set-AzSQLDatabase method there is a parameter -ComputeModel, however, I can not find corresponding parameter or property to filter on for use in Get-AzSQLDatabase. Can it be done in powershell script? Would really appreciate any pointers in the right direction.

Joy Wang · Accepted Answer · 2020-09-10 02:35:27Z

1

There is no ComputeModel property in the result of Get-AzSQLDatabase, the option is to use Get-AzResource.

There is a Kind property in the result of the command, for Provisioned database, it is v12.0,user,vcore, for Serverless database, it is v12.0,user,vcore,serverless, so we can use it to filter the databases in your subscription.

Sample:

Get-AzResource -ResourceType Microsoft.Sql/servers/databases | Where-Object {$_.Kind -eq 'v12.0,user,vcore'} | ft

If you want to get details about the databases, you could use ConvertTo-Json.

Get-AzResource -ResourceType Microsoft.Sql/servers/databases | Where-Object {$_.Kind -eq 'v12.0,user,vcore'} | ConvertTo-Json

answered Sep 10, 2020 at 2:35

Joy Wang

42.4k3 gold badges38 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Boris Pitel Over a year ago

Thank you Joy Wang, this is very helpful, I'll definitely try that.

Collectives™ on Stack Overflow

Is there a way to retrieve compute model of Azure SQL database in powershell script

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related