Transparent Data Encryption Activities - List By Configuration

Returns a database's transparent data encryption operation result.

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/transparentDataEncryption/current/operationResults?api-version=2014-04-01

URI Parameters

Name In Required Type Description
databaseName
path True

string

The name of the database for which the transparent data encryption applies.

resourceGroupName
path True

string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

serverName
path True

string

The name of the server.

subscriptionId
path True

string

The subscription ID that identifies an Azure subscription.

transparentDataEncryptionName
path True

TransparentDataEncryptionName

The name of the transparent data encryption configuration.

api-version
query True

string

The API version to use for the request.

Responses

Name Type Description
200 OK

TransparentDataEncryptionActivityListResult

OK

Examples

List a database's transparent data encryption activities

Sample request

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6852/providers/Microsoft.Sql/servers/sqlcrudtest-2080/databases/sqlcrudtest-9187/transparentDataEncryption/current/operationResults?api-version=2014-04-01

Sample response

{
  "value": [
    {
      "properties": {
        "status": "Encrypting",
        "percentComplete": 100
      },
      "name": "current",
      "location": "West US",
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6852/providers/Microsoft.Sql/servers/sqlcrudtest-2080/databases/sqlcrudtest-9187/transparentDataEncryption/current/operationResults/current",
      "type": "Microsoft.Sql/servers/databases/transparentDataEncryption/operationResults"
    }
  ]
}

Definitions

Name Description
TransparentDataEncryptionActivity

Represents a database transparent data encryption Scan.

TransparentDataEncryptionActivityListResult

Represents the response to a list database transparent data encryption activity request.

TransparentDataEncryptionActivityStatus

The status of the database.

TransparentDataEncryptionName

The name of the transparent data encryption configuration.

TransparentDataEncryptionActivity

Represents a database transparent data encryption Scan.

Name Type Description
id

string

Resource ID.

location

string

Resource location.

name

string

Resource name.

properties.percentComplete

number

The percent complete of the transparent data encryption scan for a database.

properties.status

TransparentDataEncryptionActivityStatus

The status of the database.

type

string

Resource type.

TransparentDataEncryptionActivityListResult

Represents the response to a list database transparent data encryption activity request.

Name Type Description
value

TransparentDataEncryptionActivity[]

The list of database transparent data encryption activities.

TransparentDataEncryptionActivityStatus

The status of the database.

Name Type Description
Decrypting

string

Encrypting

string

TransparentDataEncryptionName

The name of the transparent data encryption configuration.

Name Type Description
current

string