Export (0) Print
Expand All

syspolicy_policy_category_subscriptions (Transact-SQL)

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft