syspolicy_policy_execution_history (Transact-SQL)
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.
See Also
Administer Servers by Using Policy-Based Management
Policy-Based Management Views (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om