Database Table Auditing Policies - Get

Service:

SQL Database

API Version:

2014-04-01

Gets a database's table auditing policy. Table auditing is deprecated, use blob auditing instead.

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

URI Parameters

Name	In	Required	Type	Description
databaseName	path	True	string	The name of the database for which the table audit policy is defined.
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.
tableAuditingPolicyName	path	True	TableAuditingPolicyName	The name of the table auditing policy.
api-version	query	True	string	The API version to use for the request.

Responses

Name	Type	Description
200 OK	DatabaseTableAuditingPolicy	Successfully retrieved the database table auditing policy.

Examples

Get database table auditing policy

Sample request

HTTP

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/blobauditingtest-6852/providers/Microsoft.Sql/servers/blobauditingtest-2080/databases/testdb/auditingPolicies/default?api-version=2014-04-01

Sample response

Status code:

200

{
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/blobauditingtest-6852/providers/Microsoft.Sql/servers/blobauditingtest-2080/databases/testdb/auditingPolicies/Default",
  "name": "Default",
  "type": "Microsoft.Sql/servers/databases/auditingPolicies",
  "location": "West US",
  "kind": null,
  "properties": {
    "auditingState": "New",
    "eventTypesToAudit": "PlainSQL_Success,PlainSQL_Failure,ParameterizedSQL_Success,ParameterizedSQL_Failure,StoredProcedure_Success,StoredProcedure_Failure,Login_Success,Login_Failure,TransactionManagement_Success,TransactionManagement_Failure",
    "storageAccountName": null,
    "storageAccountKey": null,
    "storageAccountSecondaryKey": null,
    "storageTableEndpoint": null,
    "storageAccountResourceGroupName": null,
    "storageAccountSubscriptionId": null,
    "useServerDefault": "Enabled",
    "fullAuditLogsTableName": "SQLDBAuditLogsBlobauditingtest2080Testdb",
    "auditLogsTableName": "Blobauditingtest2080Testdb",
    "retentionDays": "0"
  }
}

Definitions

Name	Description
DatabaseTableAuditingPolicy	A database table auditing policy.
TableAuditingPolicyName	The name of the table auditing policy.

DatabaseTableAuditingPolicy

A database table auditing policy.

Name	Type	Description
id	string	Resource ID.
kind	string	Resource kind.
location	string	Resource location.
name	string	Resource name.
properties.auditLogsTableName	string	The audit logs table name.
properties.auditingState	string	The state of the policy.
properties.eventTypesToAudit	string	Comma-separated list of event types to audit.
properties.fullAuditLogsTableName	string	The full audit logs table name.
properties.retentionDays	string	The number of days to keep in the audit logs.
properties.storageAccountKey	string	The key of the auditing storage account.
properties.storageAccountName	string	The table storage account name
properties.storageAccountResourceGroupName	string	The table storage account resource group name
properties.storageAccountSecondaryKey	string	The secondary key of the auditing storage account.
properties.storageAccountSubscriptionId	string	The table storage subscription Id.
properties.storageTableEndpoint	string	The storage table endpoint.
properties.useServerDefault	string	Whether server default is enabled or disabled.
type	string	Resource type.

TableAuditingPolicyName

The name of the table auditing policy.

Name	Type	Description
default	string