Class PolicyBasedManagementSchema.PolicyExecutionHistoryDetail
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
syspolicy_policy_execution_history_details (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Displays the condition expressions that were executed, the targets of the expressions, the result of each execution, and details about errors if any occurred. The following table describes the columns in the syspolicy_execution_history_details view.
[Table(Database = "msdb", Schema = "dbo", Name = "syspolicy_policy_execution_history_details", IsView = true)]
public class PolicyBasedManagementSchema.PolicyExecutionHistoryDetail- Inheritance
-
PolicyBasedManagementSchema.PolicyExecutionHistoryDetail
- Extension Methods
Properties
DetailID
Identifier of this record. Each record represents the attempt to evaluate or enforce one condition expression in a policy. If applied to multiple targets, each condition will have a detail record for each target.
[Column("detail_id")]
[NotNull]
public long DetailID { get; set; }Property Value
Exception
Description of the exception if one occurred.
[Column("exception")]
[NotNull]
public string Exception { get; set; }Property Value
ExceptionMessage
Message generated by the exception if one occurred.
[Column("exception_message")]
[NotNull]
public string ExceptionMessage { get; set; }Property Value
ExecutionDate
Date and time that this detail record was created.
[Column("execution_date")]
[NotNull]
public DateTime ExecutionDate { get; set; }Property Value
HistoryID
Identifier of the history event. Each history event represents one try to execute a policy. Because a condition can have several condition expressions and several targets, a history_id can create several detail records. Use the history_id column to join this view to the syspolicy_policy_execution_history view.
[Column("history_id")]
[NotNull]
public long HistoryID { get; set; }Property Value
Result
Success or failure of this target and condition expression evaluation:
0 (success) or 1 (failure).
[Column("result")]
[NotNull]
public bool Result { get; set; }Property Value
ResultDetail
Result message. Only available if provided by the facet.
[Column("result_detail")]
[NotNull]
public string ResultDetail { get; set; }Property Value
TargetQueryExpression
Target of the policy and syspolicy_policy_execution_history view.
[Column("target_query_expression")]
[NotNull]
public string TargetQueryExpression { get; set; }