SQL Server 2014 with PowerShell v5 Cookbook

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 ...