Export (0) Print
Expand All

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft