| title | syspolicy_policy_execution_history (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/06/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | system-objects | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | b13c44a7-6d49-4d50-abe1-e657fc52bb05 | ||
| author | VanMSFT | ||
| ms.author | vanto |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
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.
Administer Servers by Using Policy-Based Management
Policy-Based Management Views (Transact-SQL)