Applies To: SQL Server 2014, SQL Server 2016 Preview
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.
Applies to: SQL Server (SQL Server 2008 through current version).
Identifier of this record. Each record indicates a policy and one time that it was initiated.
Identifier of the policy.
Date and time this policy tried to run.
Time this policy finished running.
Success or failure of the policy. 0 = Failure, 1 = Success.
Message generated by the exception if one occurred.
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.