Skip to content

Latest commit

 

History

History
42 lines (32 loc) · 1.89 KB

policy-based-management-views-transact-sql.md

File metadata and controls

42 lines (32 loc) · 1.89 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords dev_langs
Policy-Based Management Views (Transact-SQL)
Policy-Based Management Views (Transact-SQL)
VanMSFT
vanto
03/06/2017
sql
system-objects
reference
Policy-Based Management, system views
TSQL

Policy-Based Management Views (Transact-SQL)

[!INCLUDE SQL Server]

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.

:::row::: :::column::: syspolicy_conditions

    [syspolicy_policies](../../relational-databases/system-catalog-views/syspolicy-policies-transact-sql.md)

    [syspolicy_policy_execution_history](../../relational-databases/system-catalog-views/syspolicy-policy-execution-history-transact-sql.md)

    [syspolicy_policy_execution_history_details](../../relational-databases/system-catalog-views/syspolicy-policy-execution-history-details-transact-sql.md)
:::column-end:::
:::column:::
    [syspolicy_policy_category_subscriptions](../../relational-databases/system-catalog-views/syspolicy-policy-category-subscriptions-transact-sql.md)

    [syspolicy_policy_categories](../../relational-databases/system-catalog-views/syspolicy-policy-categories-transact-sql.md)

    [syspolicy_system_health_state](../../relational-databases/system-catalog-views/syspolicy-system-health-state-transact-sql.md)
:::column-end:::

:::row-end:::

See Also

Administer Servers by Using Policy-Based Management