Skip to content

Latest commit

 

History

History
38 lines (33 loc) · 2.03 KB

File metadata and controls

38 lines (33 loc) · 2.03 KB
title Policy-Based Management Views (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql
ms.prod_service database-engine
ms.component system-catalog-views
ms.reviewer
ms.suite sql
ms.technology system-objects
ms.tgt_pltfrm
ms.topic language-reference
dev_langs
TSQL
helpviewer_keywords
Policy-Based Management, system views
ms.assetid e1f6123c-669e-469b-ac9a-a464d78ad60c
caps.latest.revision 15
author stevestein
ms.author sstein
manager craigg

Policy-Based Management Views (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]

Policy-Based Management has the following views for displaying information about Policy-Based Management policies, conditions, expressions, groups, and filters. These views are in the msdb database and are owned by the dbo schema.

syspolicy_conditions syspolicy_policy_group_subscriptions
syspolicy_policies syspolicy_policy_groups
syspolicy_policy_execution_history syspolicy_system_health_state
syspolicy_policy_execution_history_details

See Also

Administer Servers by Using Policy-Based Management