PolicyBasedManagement

Get-DbaPbmCategory

Chrissy LeMaire (@cl), netnerds.net

Get-DbaPbmCategory View Source Chrissy LeMaire (@cl), netnerds.net Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves Policy-Based Management categories from SQL Server instances for governance and compliance management. Description Retrieves all policy categories configured in SQL Server’s Policy-Based Management (PBM) feature. Policy categories help organize and group related policies for easier management and selective enforcement across database environments. This function allows DBAs to inventory existing categories, audit category assignments, and understand which categories mandate database subscriptions for automatic policy evaluation.

Get-DbaPbmCategorySubscription

Chrissy LeMaire (@cl), netnerds.net

Get-DbaPbmCategorySubscription View Source Chrissy LeMaire (@cl), netnerds.net Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves database subscriptions to Policy-Based Management categories that control automatic policy evaluation. Description Retrieves all database subscriptions to policy categories from SQL Server’s Policy-Based Management feature. These subscriptions determine which databases are subject to automatic policy evaluation for specific policy categories. When a database subscribes to a category (either voluntarily or through mandatory subscription), all policies in that category will be automatically evaluated against the database.

Get-DbaPbmCondition

Chrissy LeMaire (@cl), netnerds.net

Get-DbaPbmCondition View Source Chrissy LeMaire (@cl), netnerds.net Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves Policy-Based Management conditions from SQL Server instances for compliance monitoring and policy evaluation. Description Retrieves Policy-Based Management (PBM) conditions from SQL Server instances, which define the rules and criteria used to evaluate database objects for compliance. These conditions form the building blocks of PBM policies and specify what to check (like database settings, table properties, or server configurations) and what values are acceptable.

Get-DbaPbmObjectSet

Chrissy LeMaire (@cl), netnerds.net

Get-DbaPbmObjectSet View Source Chrissy LeMaire (@cl), netnerds.net Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves Policy-Based Management object sets from SQL Server instances Description Retrieves object sets from SQL Server’s Policy-Based Management (PBM) feature, which define collections of SQL Server objects that policies can target for compliance monitoring. Object sets group related database objects like tables, stored procedures, or views based on specific criteria, allowing you to apply policies consistently across similar objects.

Get-DbaPbmPolicy

Stephen Bennett, sqlnotesfromtheunderground.wordpress.com

Get-DbaPbmPolicy View Source Stephen Bennett, sqlnotesfromtheunderground.wordpress.com Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves Policy-Based Management policies from SQL Server instances for compliance auditing and configuration review. Description Retrieves all Policy-Based Management policies configured on SQL Server instances, allowing DBAs to audit compliance configurations and review policy settings across their environment. This function connects to the PBM store and returns policy details including categories, conditions, and evaluation modes.

Get-DbaPbmStore

Chrissy LeMaire (@cl), netnerds.net

Get-DbaPbmStore View Source Chrissy LeMaire (@cl), netnerds.net Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves the Policy-Based Management store object from SQL Server instances. Description Retrieves the Policy-Based Management (PBM) store object, which serves as the foundation for managing SQL Server policies, conditions, and categories. This store object is required for accessing and manipulating Policy-Based Management components programmatically. The function connects to the DMF (Declarative Management Framework) policy store and returns it with additional instance identification properties for easier scripting and automation.