Book Image

SQL Server 2014 with PowerShell v5 Cookbook

By : Donabel Santos
Book Image

SQL Server 2014 with PowerShell v5 Cookbook

By: Donabel Santos

Overview of this book

Table of Contents (21 chapters)
SQL Server 2014 with PowerShell v5 Cookbook
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

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 and select New Policy.

  6. Create a new policy as follows:

    1. Type Password Expiry for the Name property.

    2. Use "Password Expiry Condition" for the Condition.

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

    4. Change Evaluation...