Class PolicyBasedManagementSchema.Condition

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

syspolicy_conditions (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Displays one row for each Policy-Based Management condition in the instance of SQL Server. syspolicy_conditions belongs to the dbo schema in the msdb database. The following table describes the columns in the syspolicy_conditions view.

See dbo.syspolicy_conditions.

[Table(Database = "msdb", Schema = "dbo", Name = "syspolicy_conditions", IsView = true)]
public class PolicyBasedManagementSchema.Condition

Inheritance

object

PolicyBasedManagementSchema.Condition

Extension Methods

Map.DeepCopy<T>(T)

Properties

ConditionID

Identifier of this condition. Each condition represents a collection of one or more condition expressions.

[Column("condition_id")]
[NotNull]
public int ConditionID { get; set; }

Property Value

int

CreatedBy

Login that created the condition.

[Column("created_by")]
[NotNull]
public string CreatedBy { get; set; }

Property Value

string

DateCreated

Date and time the condition was created.

[Column("date_created")]
[NotNull]
public DateTime DateCreated { get; set; }

Property Value

DateTime

DateModified

Date and time the condition was created. Is NULL if never modified.

[Column("date_modified")]
[NotNull]
public DateTime DateModified { get; set; }

Property Value

DateTime

Description

Description of the condition. The description column is optional and can be NULL.

[Column("description")]
[NotNull]
public string Description { get; set; }

Property Value

string

Expression

Expression of the facet states.

[Column]
[NotNull]
public string Expression { get; set; }

Property Value

string

Facet

Name of the facet that the condition is based on.

[Column("facet")]
[NotNull]
public string Facet { get; set; }

Property Value

string

IsNameCondition

Specifies whether the condition is a naming condition.

0 = The condition expression does not contain the @Name variable.

1 = The condition expression contains the @Name variable.

[Column("is_name_condition")]
[NotNull]
public short IsNameCondition { get; set; }

Property Value

short

ModifiedBy

Login that most recently modified the condition. Is NULL if never modified.

[Column("modified_by")]
[NotNull]
public string ModifiedBy { get; set; }

Property Value

string

Name

Name of the condition.

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

Property Value

string

ObjName

The object name assigned to @Name if the condition expression contains this variable.

[Column("obj_name")]
[NotNull]
public string ObjName { get; set; }

Property Value

string