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.|
The syspolicy_policy_execution_history_details view contains related details about the targets of the policy and the condition expressions tested.
Requires membership in the PolicyAdministratorRole role in the msdb database.