syspolicy_policy_category_subscriptions (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Displays one row for each Policy-Based Management subscription in the instance of SQL Server. Each row describes a target and policy category pair. The following table describes the columns in the syspolicy_policy_group_subscriptions view.

Column name Data type Description
policy_category_subscription_id int Identifier of this record.
target_type sysname Type of database object that is the target of this subscription.
target_object sysname Name of the target object.
policy_category_id int ID of the policy category that is applied to the target.


This view shows the targets that are subscribed to policy categories.


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)