SQL Server 2014 with PowerShell v5 Cookbook

Listing facets and their properties

In this recipe, we will list all available facets and their properties.

How to do it...

Let's take a look at the steps for listing facets and their properties:

1. Open PowerShell ISE as an administrator. Import the SQLPS module as follows:

   #import SQL Server module
   Import-Module SQLPS -DisableNameChecking

2. Add the following script and run it:

   $result = @()
   
   [Microsoft.SqlServer.Management.Dmf.PolicyStore]::Facets |
   ForEach-Object {
      $facet = $_
      $facet.FacetProperties |
      ForEach-Object {
          $property = $_
          $item = [PSCustomObject] @{
             Name = $facet.Name
             PropertyName = $property.Name
             PropertyType = $property.PropertyType
          }
          $result += $item
      }
   }
   
   $result |
   Format-Table

3. When the script successfully finishes executing, the resulting ...