Exporting a policy

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

Getting ready

We will export a policy called PW Expiry to an XML file. To do this we must first create this policy by performing the following steps:

1. Log in to SQL Server Management Studio, and expand Management | Policy Management.

2. Right-click on Conditions and select New Condition.

3. Create a new condition:

   1. Set Name to PW Expiry Condition.

   2. Select Login Options for Facet.

   3. Use @PasswordExpirationEnabled = True for Expression.

   4. Click on OK when done.

      

4. Right-click on Policies and select New Policy.

5. Create a new policy:

   1. Type PW Expiry for Name.

   2. Use PW Expiry Condition for Check condition.

   3. Leave the checkbox for Against targets checked, since we want to target every login.

   4. Leave Evaluation Mode to On demand.

   5. Leave Server restriction to None.

   6. Click on OK when done.

      

   Alternatively, you can substitute this with another policy that exists in your system.

How to do it...

To export a policy to an XML file, perform the following...