Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
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.