Transparent Data Encryption Activities

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={api-version}
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/transparentDataEncryption/{transparentDataEncryptionName}/operationResults?$expand={$expand}&api-version={api-version}

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
  • string

The name of the transparent data encryption configuration.

$expand
query
  • string
A comma separated list of child objects to expand in the response. Possible properties: serviceTierAdvisors, transparentDataEncryption.
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

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
  • enum:
    • Encrypting
    • Decrypting

The status of the database.

Name Type Description
value

The list of database transparent data encryption activities.