Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
Reference
Policy-Based Management Views (Transact-SQL)