Share via


syspolicy_policy_execution_history (Transact-SQL)

Displays the time when policies were executed, the result of each execution, and details about errors if any occurred. The following table describes the columns in the syspolicy_policy_execution_history view.

Column name

Data type

Description

history_id

bigint

Identifier of this record. Each record indicates a policy and one time that it was initiated.

policy_id

int

Identifier of the policy.

start_date

datetime

Date and time this policy tried to run.

end_date

datetime

Time this policy finished running.

result

bit

Success or failure of the policy. 0 = Failure, 1 = Success.

exception_message

nvarchar(max)

Message generated by the exception if one occurred.

exception

nvarchar(max)

Description of the exception if one occurred.

Remarks

The syspolicy_policy_execution_history_details view contains related details about the targets of the policy and the condition expressions tested.

Permissions

Requires membership in the PolicyAdministratorRole role in the msdb database.

See Also

Reference

Policy-Based Management Views (Transact-SQL)

Concepts

Administer Servers by Using Policy-Based Management