Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

Get-AzSqlInstanceActiveDirectoryAdministrator

Module:
Az.Sql Module

Gets information about a Microsoft Entra administrator for SQL Managed Instance.

Syntax

UseResourceGroupAndInstanceNameParameterSet (Default) 

Get-AzSqlInstanceActiveDirectoryAdministrator
 [-ResourceGroupName] <String>
 [-InstanceName] <String>
 [-DefaultProfile <IAzureContextContainer>]
 [<CommonParameters>]

UseInputObjectParameterSet 

Get-AzSqlInstanceActiveDirectoryAdministrator
 -InputObject <AzureSqlManagedInstanceModel>
 [-DefaultProfile <IAzureContextContainer>]
 [<CommonParameters>]

UserResourceIdParameterSet 

Get-AzSqlInstanceActiveDirectoryAdministrator
 [-ResourceId] <String>
 [-DefaultProfile <IAzureContextContainer>]
 [<CommonParameters>]

Description

The Get-AzSqlInstanceActiveDirectoryAdministrator cmdlet gets information about a Microsoft Entra administrator for an AzureSQL Managed Instance in the current subscription.

Examples

Example 1

Get-AzSqlInstanceActiveDirectoryAdministrator -ResourceGroupName "ResourceGroup01" -InstanceName "ManagedInstance01"

ResourceGroupName InstanceName DisplayName ObjectId
----------------- ----------------- ----------- --------
ResourceGroup01 ManagedInstance01 DBAs 40b79501-b343-44ed-9ce7-da4c8cc7353b

This command gets information about a Microsoft Entra administrator for a managed instance named ManagedInstance01 that is associated with a resource group named ResourceGroup01.

Example 2

Get-AzSqlInstance -ResourceGroupName "ResourceGroup01" -Name "ManagedInstance1" | Get-AzSqlInstanceActiveDirectoryAdministrator

ResourceGroupName InstanceName DisplayName ObjectId
----------------- ----------------- ----------- --------
ResourceGroup01 ManagedInstance01 DBAs 40b79501-b343-44ed-9ce7-da4c8cc7353b

This command gets information about a Microsoft Entra administrator from a managed instance object.

Example 3

Get-AzSqlInstance -ResourceId "/subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ResourceGroup01/providers/Microsoft.Sql/managedInstances/ManagedInstance1" | Get-AzSqlInstanceActiveDirectoryAdministrator

ResourceGroupName InstanceName DisplayName ObjectId
----------------- ----------------- ----------- --------
ResourceGroup01 ManagedInstance01 DBAs 40b79501-b343-44ed-9ce7-da4c8cc7353b

This command gets information about a Microsoft Entra administrator using managed instance resource identifier.

Parameters

-DefaultProfile

The credentials, account, tenant, and subscription used for communication with Azure.

Parameter properties

Type:IAzureContextContainer
Default value:None
Supports wildcards:False
DontShow:False
Aliases:AzContext, AzureRmContext, AzureCredential

Parameter sets

-InputObject

The managed instance object to use.

Parameter properties

Type:AzureSqlManagedInstanceModel
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

-InstanceName

SQL Managed Instance name.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

-ResourceGroupName

The name of the resource group.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

-ResourceId

The resource id of instance to use

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

Inputs

String

Outputs

AzureSqlInstanceActiveDirectoryAdministratorModel

Related Links

Feedback

Was this page helpful?