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.