# StorageTableLogs Table

## Storage Table Logs Overview:

Logs come within two categories. These include data plane logs and control plane logs. The data plane logs are stored within a table called "StorageTableLogs" and the control plane logs are storage in the AzureActivity logs.&#x20;



### StorageTableLogs (Data Plane)

| Column               | Type     | Description                                                                                                                                                                                                                           |
| -------------------- | -------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| AccountName          | string   | The name of the storage account.                                                                                                                                                                                                      |
| AuthenticationHash   | string   | The hash of authentication token.                                                                                                                                                                                                     |
| AuthenticationType   | string   | The type of authentication that was used to make the request.                                                                                                                                                                         |
| AuthorizationDetails | dynamic  | Detailed policy information used to authorize the request.                                                                                                                                                                            |
| \_BilledSize         | real     | The record size in bytes                                                                                                                                                                                                              |
| CallerIpAddress      | string   | The IP address of the requester, including the port number.                                                                                                                                                                           |
| Category             | string   | The category of requested operation.                                                                                                                                                                                                  |
| ClientRequestId      | string   | The x-ms-client-request-id header value of the request.                                                                                                                                                                               |
| ConditionsUsed       | string   | A semicolon-separated list of key-value pairs that represent a condition.                                                                                                                                                             |
| ContentLengthHeader  | long     | The value of the Content-Length header for the request sent to the storage service.                                                                                                                                                   |
| CorrelationId        | string   | The ID that is used to correlate logs across resources.                                                                                                                                                                               |
| DurationMs           | real     | The total time, expressed in milliseconds, to perform the requested operation. This includes the time to read the incoming request, and to send the response to the requester.                                                        |
| Etag                 | string   | The ETag identifier for the returned object, in quotes.                                                                                                                                                                               |
| \_IsBillable         | string   | Specifies whether ingesting the data is billable. When \_IsBillable is `false` ingestion isn't billed to your Azure account                                                                                                           |
| LastModifiedTime     | datetime | The Last Modified Time (LMT) for the returned object. This field is empty for operations that can return multiple objects.                                                                                                            |
| Location             | string   | The location of storage account.                                                                                                                                                                                                      |
| MetricResponseType   | string   | Records the metric response for correlation between metrics and logs.                                                                                                                                                                 |
| ObjectKey            | string   | The key of the requested object, in quotes.                                                                                                                                                                                           |
| OperationCount       | int      | The number of each logged operation that is involved in the request. This count starts with an index of 0. Some requests require more than one operation, such as a request to copy a blob. Most requests perform only one operation. |
| OperationName        | string   | The type of REST operation that was performed.                                                                                                                                                                                        |
| OperationVersion     | string   | The storage service version that was specified when the request was made. This is equivalent to the value of the x-ms-version header.                                                                                                 |
| Protocol             | string   | The protocol that is used in the operation.                                                                                                                                                                                           |
| ReferrerHeader       | string   | The Referer header value.                                                                                                                                                                                                             |
| RequestBodySize      | long     | The size of the request packets, expressed in bytes, that are read by the storage service. If a request is unsuccessful, this value might be empty.                                                                                   |
| RequesterAppId       | string   | The Open Authorization (OAuth) application ID that is used as the requester.                                                                                                                                                          |
| RequesterAudience    | string   | The OAuth audience of the request.                                                                                                                                                                                                    |
| RequesterObjectId    | string   | The OAuth object ID of the requester.                                                                                                                                                                                                 |
| RequesterTenantId    | string   | The OAuth tenant ID of identity.                                                                                                                                                                                                      |
| RequesterTokenIssuer | string   | The OAuth token issuer.                                                                                                                                                                                                               |
| RequesterUpn         | string   | The User Principal Names of requestor.                                                                                                                                                                                                |
| RequestHeaderSize    | long     | The size of the request header expressed in bytes. If a request is unsuccessful, this value might be empty.                                                                                                                           |
| RequestMd5           | string   | The value of either the Content-MD5 header or the x-ms-content-md5 header in the request. The MD5 hash value specified in this field represents the content in the request.                                                           |
| \_ResourceId         | string   | A unique identifier for the resource that the record is associated with                                                                                                                                                               |
| ResponseBodySize     | long     | The size of the response packets written by the storage service, in bytes. If a request is unsuccessful, this value may be empty.                                                                                                     |
| ResponseHeaderSize   | long     | The size of the response header expressed in bytes. If a request is unsuccessful, this value might be empty.                                                                                                                          |
| ResponseMd5          | string   | The value of the MD5 hash calculated by the storage service.                                                                                                                                                                          |
| SasExpiryStatus      | string   | Records any violations in the request SAS token as per the SAS policy set in the storage account. Ex: longer SAS token duration specified than allowed per SAS policy                                                                 |
| SchemaVersion        | string   | The schema version of the log.                                                                                                                                                                                                        |
| ServerLatencyMs      | real     | The total time expressed in milliseconds to perform the requested operation. This value doesn't include network latency (the time to read the incoming request and send the response to the requester).                               |
| ServiceType          | string   | The service associated with this request.                                                                                                                                                                                             |
| SourceSystem         | string   | The type of agent the event was collected by. For example, `OpsManager` for Windows agent, either direct connect or Operations Manager, `Linux` for all Linux agents, or `Azure` for Azure Diagnostics                                |
| StatusCode           | string   | The HTTP status code for the request. If the request is interrupted, this value might be set to Unknown.                                                                                                                              |
| StatusText           | string   | The status of the requested operation.                                                                                                                                                                                                |
| \_SubscriptionId     | string   | A unique identifier for the subscription that the record is associated with                                                                                                                                                           |
| TenantId             | string   | The Log Analytics workspace ID                                                                                                                                                                                                        |
| TimeGenerated        | datetime | The Universal Time Coordinated (UTC) time when the request was received by storage.                                                                                                                                                   |
| TlsVersion           | string   | The TLS version used in the connection of request.                                                                                                                                                                                    |
| Type                 | string   | The name of the table                                                                                                                                                                                                                 |
| Uri                  | string   | Uniform resource identifier that is requested.                                                                                                                                                                                        |
| UserAgentHeader      | string   | The User-Agent header value, in quotes.                                                                                                                                                                                               |

### Storage Table Logs (Control Plane)&#x20;

The following section provides documentation references for the APIs, error codes, and status messages that are utilized within the control plane API.&#x20;



#### Table Storage REST API

{% embed url="https://learn.microsoft.com/en-us/rest/api/storageservices/table-service-rest-api" %}

#### Table Storage Status Codes and Error Messages

{% embed url="https://learn.microsoft.com/en-us/rest/api/storageservices/table-service-error-codes" %}

### Github References:

The section includes references to Azure Documentation on Github for monitoring best practices:



{% embed url="https://github.com/MicrosoftDocs/azure-docs/blob/main/articles/storage/tables/monitor-table-storage-reference.md" %}

{% embed url="https://github.com/MicrosoftDocs/azure-docs/blob/main/articles/storage/tables/monitor-table-storage.md" %}
