Table of Contents

Class SecuritySchema.ServerAudit

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

sys.server_audits (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains one row for each SQL Server audit in a server instance. For more information, see SQL Server Audit (Database Engine).


See sys.server_audits.

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

Properties

AuditGuid

GUID for the audit that is used to enumerate audits with member Server|Database audit specifications during server start-up and database attach operations.

[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 the 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?

ModifyDate

UTC date the audit was last modified.

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

Property Value

DateTime

Name

Name of the audit.

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

Property Value

string

OnFailure

On Failure to write an action entry:

0 - Continue

1 - Shutdown 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

The 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 to the server.

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

Property Value

int?

QueueDelay

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

[Column("queue_delay")]
[Nullable]
public int? QueueDelay { 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

SECURITY LOG

APPICATION LOG

FILE

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

Property Value

string