managed_instances_by_instance_pools

Creates, updates, deletes, gets or lists a managed_instances_by_instance_pools resource.

Overview

Name	managed_instances_by_instance_pools
Type	Resource
Id	azure.sql.managed_instances_by_instance_pools

Fields

Name	Datatype	Description
identity	object	Azure Active Directory identity configuration for a resource.
location	string	Resource location.
properties	object	The properties of a managed instance.
sku	object	An ARM Resource SKU.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
list	SELECT	instancePoolName, resourceGroupName, subscriptionId	Gets a list of all managed instances in an instance pool.

SELECT examples

Gets a list of all managed instances in an instance pool.

SELECT
identity,
location,
properties,
sku,
tags
FROM azure.sql.managed_instances_by_instance_pools
WHERE instancePoolName = '{{ instancePoolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';