syspolicy_policy_category_subscriptions (Transact-SQL)
Applies to: 
SQL Server
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. |
Remarks
This view shows the targets that are subscribed to policy categories.
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)