Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

syspolicy_policy_categories (Transact-SQL)

Displays one row for each Policy-Based Management policy category in the instance of SQL Server. Policy categories help you organize policies when you have many policies. The following table describes the columns in the syspolicy_policy_groups view.

Column name

Data type

Description

policy_category_id

int

Identifier of the policy category.

name

sysname

Name of the policy category.

mandate_database_subscriptions

bit

Indicates whether the policy category applies to all databases in an instance without an explicit subscription (1) or the policy category must be applied to a database by using an explicit subscription (0).

Displays a list of Policy-Based Management policy groups.

Requires membership in the PolicyAdministratorRole role in the msdb database.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.