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 nameData typeDescription
policy_category_subscription_idintIdentifier of this record.
target_typesysnameType of database object that is the target of this subscription.
target_objectsysnameName of the target object.
policy_category_idintID 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.

Administer Servers by Using Policy-Based Management
Policy-Based Management Views (Transact-SQL)

Community Additions