StorageFileLogs

File Logs:

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

StorageFileLogs (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 requester.

RequesterUserName

string

The user name of requester for SMB.

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.

SmbCommandDetail

string

More information about this specific request rather than the general type of request.

SmbCommandMajor

int

Value in SMB2_HEADER.Command, and is currently a number between 0 and 18 inclusive.

SmbCommandMinor

string

The subclass of SmbCommandMajor, where appropriate.

SmbCreditsConsumed

int

The ingress or egress consumed by the request, in units of 64k.

SmbFileId

string

The FileId associated with file or directory. Roughly analogous to an NTFS FileId.

SmbMessageID

string

The connection relative MessageId.

SmbPersistentHandleID

string

Persistent HandleID from an SMB2 Create request that survives network reconnects. Referenced in [MS-SMB2] 2.2.14.1 as SMB2_FILEID.Persistent.

SmbPrimarySID

string

Security Identifier of Kerberos Authenticated request

SmbSessionID

string

The SMB2 SessionId established at SessionSetup time.

SmbStatusCode

string

Status code for SMB in a hex format.

SmbTreeConnectID

string

The SMB TreeConnectID established at TreeConnect time.

SmbVolatileHandleID

string

Volatile HandleID from an SMB2 Create request that is recycled on network reconnects. Referenced in [MS-SMB2] 2.2.14.1 as SMB2_FILEID.Volatile.

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.

File Storage Logs (Control Plane)

The links provided below provide reference to the different types of control plane REST API calls that would be observed within the Azure Activity Log.

Control Plane API: Storage Account

Control Plane API: File Service

Control Plane: Azure File Operations:

Control Plane API: File Shares

Control Plane API: Directories

Control Plane API: Files

Github References

These references provide documentation on file monitoring best practices.

Storage File Monitoring Reference:

Storage File Monitoring Reference:

Additional References:

The following references below reference the documentation for Azure Files, the table schema referenced above as well as the error and status message logging for storage analytics.

Monitoring Azure Files

StorageFileLogs Table

Logged Operations That Include Status Messages

Last updated 9 months ago