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.