Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Get-AzSqlInstanceOperation
- Module:
- Az.Sql Module
Gets a SQL managed instance's operations.
Syntax
DefaultParameterSet (Default)
Get-AzSqlInstanceOperation
-ManagedInstanceName <String>
-ResourceGroupName <String>
[-Name <String>]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
GetByManagedInstanceOperationResourceIdentifierParameterSet
Get-AzSqlInstanceOperation
[-ResourceId] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
ListByManagedInstanceParameterSet
Get-AzSqlInstanceOperation
-ManagedInstanceName <String>
-ResourceGroupName <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Description
The Get-AzSqlInstanceOperation cmdlet gets information about the operations on a SQL managed instance. You can view all operations on a managed instance or view a specific operation by providing the operation name.
Examples
Example 1: Get all instance's operations
Get-AzSqlInstanceOperation -ResourceGroupName ps3753 -ManagedInstanceName ps3698
Id : /subscriptions/a8c9a924-06c0-4bde-9788-e7b1370969e1/resourceGroups/ps3753/providers/Microsoft.Sql/managedInstances/ps3698/operations/5870c6d8-6703-4b27-8ae4-687b4ca7caea
ResourceGroupName : ps3753
ManagedInstanceName : ps3698
Name : 5870c6d8-6703-4b27-8ae4-687b4ca7caea
Operation : UpsertManagedServer
OperationFriendlyName : UPDATE MANAGED SERVER
PercentComplete : 100
StartTime : 3/16/2020 8:11:13 AM
State : Succeeded
ErrorCode :
ErrorDescription :
ErrorSeverity :
IsUserError :
EstimatedCompletionTime :
Description :
IsCancellable : False
OperationParameters : Microsoft.Azure.Management.Sql.Models.ManagedInstanceOperationParametersPair
OperationSteps : Microsoft.Azure.Management.Sql.Models.ManagedInstanceOperationSteps
Id : /subscriptions/a8c9a924-06c0-4bde-9788-e7b1370969e1/resourceGroups/ps3753/providers/Microsoft.Sql/managedInstances/ps3698/operations/79f2c91b-0080-4c14-b9b4-d9991c6e82dd
ResourceGroupName : ps3753
ManagedInstanceName : ps3698
Name : 79f2c91b-0080-4c14-b9b4-d9991c6e82dd
Operation : UpsertManagedServer
OperationFriendlyName : UPDATE MANAGED SERVER
PercentComplete : 100
StartTime : 3/16/2020 8:19:53 AM
State : Cancelled
ErrorCode :
ErrorDescription :
ErrorSeverity :
IsUserError :
EstimatedCompletionTime :
Description :
IsCancellable : False
OperationParameters : Microsoft.Azure.Management.Sql.Models.ManagedInstanceOperationParametersPair
OperationSteps : Microsoft.Azure.Management.Sql.Models.ManagedInstanceOperationSteps
This command gets all operations a SQL managed instance.
Example 2: Get a specific operation
Get-AzSqlInstanceOperation -ResourceGroupName ps3753 -ManagedInstanceName ps3698 -Name 5870c6d8-6703-4b27-8ae4-687b4ca7caea
Id : /subscriptions/a8c9a924-06c0-4bde-9788-e7b1370969e1/resourceGroups/ps3753/providers/Microsoft.Sql/managedInstances/ps3698/operations/5870c6d8-6703-4b27-8ae4-687b4ca7caea
ResourceGroupName : ps3753
ManagedInstanceName : ps3698
Name : 5870c6d8-6703-4b27-8ae4-687b4ca7caea
Operation : UpsertManagedServer
OperationFriendlyName : UPDATE MANAGED SERVER
PercentComplete : 100
StartTime : 3/16/2020 8:11:13 AM
State : Succeeded
ErrorCode :
ErrorDescription :
ErrorSeverity :
IsUserError :
EstimatedCompletionTime :
Description :
IsCancellable : False
OperationParameters : Microsoft.Azure.Management.Sql.Models.ManagedInstanceOperationParametersPair
OperationSteps : Microsoft.Azure.Management.Sql.Models.ManagedInstanceOperationSteps
This command gets operation with name '5870c6d8-6703-4b27-8ae4-687b4ca7caea' on a SQL managed instance.
Example 3: Using operation resource id
$managedInstanceOperation = Get-AzSqlInstanceOperation -ResourceGroupName ps3753 -ManagedInstanceName ps3698 -Name 5870c6d8-6703-4b27-8ae4-687b4ca7caea
Get-AzSqlInstanceOperation -ResourceId $managedInstanceOperation.Id
Id : /subscriptions/a8c9a924-06c0-4bde-9788-e7b1370969e1/resourceGroups/ps3753/providers/Microsoft.Sql/managedInstances/ps3698/operations/5870c6d8-6703-4b27-8ae4-687b4ca7caea
ResourceGroupName : ps3753
ManagedInstanceName : ps3698
Name : 5870c6d8-6703-4b27-8ae4-687b4ca7caea
Operation : UpsertManagedServer
OperationFriendlyName : UPDATE MANAGED SERVER
PercentComplete : 100
StartTime : 3/16/2020 8:11:13 AM
State : Succeeded
ErrorCode :
ErrorDescription :
ErrorSeverity :
IsUserError :
EstimatedCompletionTime :
Description :
IsCancellable : False
OperationParameters : Microsoft.Azure.Management.Sql.Models.ManagedInstanceOperationParametersPair
OperationSteps : Microsoft.Azure.Management.Sql.Models.ManagedInstanceOperationSteps
This command gets operation with id '/subscriptions/a8c9a924-06c0-4bde-9788-e7b1370969e1/resourceGroups/ps3753/providers/Microsoft.Sql/managedInstances/ps3698/operations/5870c6d8-6703-4b27-8ae4-687b4ca7caea'.
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
-ManagedInstanceName
The name of the instance.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | True |
| DontShow: | False |
| Aliases: | InstanceName |
Parameter sets
-Name
The name of the operation.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | True |
| DontShow: | False |
| Aliases: | OperationName |
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 managed instance operation resource identifier.
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
AzureSqlManagedInstanceOperationModel
Azure PowerShell
Feedback
Was this page helpful?