Class PolicyBasedManagementSchema.SystemHealthState

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

syspolicy_system_health_state (Transact-SQL)

Applies to: √ SQL Server

Displays one row for each Policy-Based Management policy and target query expression combination. Use the syspolicy_system_health_state view to programmatically check the policy health of the server. The following table describes the columns in the syspolicy_system_health_state view.

See dbo.syspolicy_system_health_state.

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

Inheritance

object

PolicyBasedManagementSchema.SystemHealthState

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Extension Methods

Map.DeepCopy<T>(T)

Properties

HealthStateID

health_state_id NOT NULL bigint

Identifier of the policy health state record.

[Column("health_state_id")]
[NotNull]
public long HealthStateID { get; set; }

Property Value

long

LastRunDate

last_run_date NOT NULL datetime

Date and time the policy was last run.

[Column("last_run_date")]
[NotNull]
public DateTime LastRunDate { get; set; }

Property Value

DateTime

PolicyID

policy_id NOT NULL int

Identifier of the policy.

[Column("policy_id")]
[NotNull]
public int PolicyID { get; set; }

Property Value

int

Result

result NOT NULL bit

Health state of this target with regard to the policy:

0 = Failure

1 = Success

[Column("result")]
[NotNull]
public bool Result { get; set; }

Property Value

bool

TargetQueryExpression

target_query_expression NOT NULL nvarchar(max)

The expression that defines the target against which the policy is evaluated.

[Column("target_query_expression")]
[NotNull]
public string TargetQueryExpression { get; set; }

Property Value

string

TargetQueryExpressionWithID

target_query_expression_with_id NOT NULL nvarchar(400)

The target expression, with values assigned to identity variables, that defines the target against which the policy is evaluated.

[Column("target_query_expression_with_id")]
[NotNull]
public string TargetQueryExpressionWithID { get; set; }

Property Value

string