Get-AzureRmSqlDatabaseActivity

NAME Get-AzureRmSqlDatabaseActivity



SYNOPSIS

Gets the status of database operations.





SYNTAX

Get-AzureRmSqlDatabaseActivity [-ResourceGroupName] <String> [-ServerName] <String> -DatabaseName <String> [-DefaultProfile

<IAzureContextContainer>] [-ElasticPoolName <String>] [-OperationId <Guid>] [-Confirm] [-WhatIf] [<CommonParameters>]





DESCRIPTION

The Get-AzureRmSqlDatabaseActivity cmdlet gets the status of database operations in Azure SQL Database.





PARAMETERS

-DatabaseName <String>

Specifies the name of the database for which this cmdlet gets status.



Required? true

Position? named

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-DefaultProfile <IAzureContextContainer>

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



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-ElasticPoolName <String>

Specifies the name of the elastic database pool for which this cmdlet gets status.



Required? false

Position? named

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-OperationId <Guid>

Specifies the ID of the operation that this cmdlet gets.



Required? false

Position? named

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ResourceGroupName <String>

Specifies the name of the resource group to which the database is assigned.



Required? true

Position? 0

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ServerName <String>

Specifies the name of the Microsoft SQL Server that hosts the database.



Required? true

Position? 1

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-Confirm [<SwitchParameter>]

Prompts you for confirmation before running the cmdlet.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



-WhatIf [<SwitchParameter>]

Shows what would happen if the cmdlet runs. The cmdlet is not run.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).



INPUTS

None

This cmdlet does not accept any input.





OUTPUTS

Microsoft.Azure.Commands.Sql.Database.Model.AzureSqlDatabaseActivityModel







NOTES









Example 1: Get status for all SQL Database instances



PS C:\\>Get-AzureRmSqlDatabaseActivity -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool01"



This command returns the operation status of all SQL Database instances in an elastic pool named ElasticPool01.





Example 2: Get status for all SQL Database operations



PS C:\\>Get-AzureRmSqlDatabaseActivity -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01"



This command returns the status of all SQL Database operations in a database.







RELATED LINKS

Online Version: https://docs.microsoft.com/en-us/powers ... seactivity