Table of Contents

Class SecuritySchema.ServerFileAudit

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.server_file_audits (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains extended information about the file audit type in a SQL Server audit on a server instance. For more information, see SQL Server Audit (Database Engine).


See sys.server_file_audits.

[Table(Schema = "sys", Name = "server_file_audits", IsView = true)]
public class SecuritySchema.ServerFileAudit
Inheritance
SecuritySchema.ServerFileAudit
Extension Methods

Properties

AuditGuid

GUID of the audit.

[Column("audit_guid")]
[Nullable]
public Guid? AuditGuid { get; set; }

Property Value

Guid?

AuditID

ID of the audit.

[Column("audit_id")]
[NotNull]
public int AuditID { get; set; }

Property Value

int

CreateDate

UTC date when the file audit was created.

[Column("create_date")]
[NotNull]
public DateTime CreateDate { get; set; }

Property Value

DateTime

IsStateEnabled

0 = Disabled

1 = Enabled

[Column("is_state_enabled")]
[Nullable]
public byte? IsStateEnabled { get; set; }

Property Value

byte?

LogFileName

Base name for the log file supplied in the CREATE AUDIT DDL. An incremental number is added to the base_log_name file as a suffix to create the log file name.

[Column("log_file_name")]
[Nullable]
public string? LogFileName { get; set; }

Property Value

string

LogFilePath

Path to where audit is located. File path for file audit, application log path for application log audit.

[Column("log_file_path")]
[Nullable]
public string? LogFilePath { get; set; }

Property Value

string

MaxFileSize

Maximum size, in megabytes, of the audit:

0 = Unlimited/Not applicable to the type of audit selected.

[Column("max_file_size")]
[Nullable]
public long? MaxFileSize { get; set; }

Property Value

long?

MaxFiles

Maximum number of files to use without the rollover option.

[Column("max_files")]
[Nullable]
public int? MaxFiles { get; set; }

Property Value

int?

MaxRolloverFiles

Maximum number of files to use with the rollover option.

[Column("max_rollover_files")]
[Nullable]
public int? MaxRolloverFiles { get; set; }

Property Value

int?

ModifyDate

UTC date when the file audit was last modified.

[Column("modify_date")]
[NotNull]
public object ModifyDate { get; set; }

Property Value

object

Name

Name of the audit.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

OnFailure

On Failure condition:

0 = Continue

1 = Shut down server instance

2 = Fail operation

[Column("on_failure")]
[Nullable]
public byte? OnFailure { get; set; }

Property Value

byte?

OnFailureDesc

On Failure to write an action entry:

CONTINUE

SHUTDOWN SERVER INSTANCE

FAIL OPERATION

[Column("on_failure_desc")]
[Nullable]
public string? OnFailureDesc { get; set; }

Property Value

string

Predicate

Predicate expression that is applied to the event.

[Column("predicate")]
[Nullable]
public string? Predicate { get; set; }

Property Value

string

PrincipalID

ID of the owner of the audit as registered on the server.

[Column("principal_id")]
[Nullable]
public int? PrincipalID { get; set; }

Property Value

int?

QueueDelay

Suggested maximum time, in milliseconds, to wait before writing to disk. If 0, the audit will guarantee a write before the event can continue.

[Column("queue_delay")]
[Nullable]
public int? QueueDelay { get; set; }

Property Value

int?

ReservedDiskSpace

Amount of disk space to reserve per file.

[Column("reserved_disk_space")]
[NotNull]
public int ReservedDiskSpace { get; set; }

Property Value

int

TypeColumn

Audit type:

SL = NT Security event log

AL = NT Application event log

FL = File on file system

[Column("type")]
[NotNull]
public string TypeColumn { get; set; }

Property Value

string

TypeDesc

Audit type description.

[Column("type_desc")]
[Nullable]
public string? TypeDesc { get; set; }

Property Value

string