O'Reilly logo

SQL Server 2014 with PowerShell v5 Cookbook by Donabel Santos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Exporting a policy

In this recipe, we will export a policy to an XML file using PowerShell.

Getting ready

In this recipe, we will export a policy called Password Expiry to an XML file. To do this, we must first create this policy. Alternatively, instead of creating this policy, you can substitute this Password Expiry policy with another policy that exists in your system. The steps to create this policy are as follows:

  1. Log in to SQL Server Management Studio and navigate to Management | Policy Management.
  2. Right-click on Conditions and select New Condition.
  3. Create a new condition as follows:
    1. Set Name to Password Expiry Condition.
    2. Select Login Options for Facet.
    3. Use @PasswordExpirationEnabled = True for Expression.
  4. Click on OK when done.
  5. Right-click on Policies ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required