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/{transparentDataEncryptionName}/operationResults?api-version=2014-04-01

URI Parameters

Name In Required Type Description
subscriptionId
path True
  • string

The subscription ID that identifies an Azure subscription.

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.

databaseName
path True
  • string

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

transparentDataEncryptionName
path True

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

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

TransparentDataEncryptionActivity

Represents a database transparent data encryption Scan.

TransparentDataEncryptionActivityListResult
TransparentDataEncryptionActivityStatus

The status of the database.

TransparentDataEncryptionName

The name of the transparent data encryption configuration.

Represents a database transparent data encryption Scan.

Name Type Description
location
  • string

Resource location.

percentComplete
  • number
    float

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

status

The status of the database.

Name Type Description
value

The list of database transparent data encryption activities.

The status of the database.

Name Description
Decrypting
Encrypting

The name of the transparent data encryption configuration.

Name Description
current