Skip to content

Latest commit

 

History

History
55 lines (37 loc) · 2.5 KB

File metadata and controls

55 lines (37 loc) · 2.5 KB
title Evaluate a Policy-Based Management policy from that policy
description Learn to evaluate a policy using that policy in SQL Server by using SQL Server Management Studio (SSMS).
ms.custom seo-lt-2019
ms.date 03/01/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology security
ms.topic conceptual
helpviewer_keywords
Policy-Based Management, evaluate policy
ms.assetid 0b3214bd-d0ab-45ab-9281-3d95507abe54
author VanMSFT
ms.author vanto

Evaluate a Policy-Based Management Policy from That Policy

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] This topic describes how to evaluate a policy using that policy in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull].

In This Topic

Before You Begin

Security

Permissions

Requires membership in the PolicyAdministratorRole role in the msdb database.

Using SQL Server Management Studio

To evaluate a policy

  1. In Object Explorer, click the plus sign to expand the server that contains the policy that you want to evaluate.

  2. Click the plus sign to expand the Management folder.

  3. Click the plus sign to expand Policy Management.

  4. Click the plus sign to expand the Policies folder.

  5. Right-click the policy that you want to evaluate and select Evaluate.

  6. In the Evaluate Results dialog box, you see the results of the policy evaluation. For targets that do not comply with the policy and have properties that can be reconfigured by Policy-Based Management, you can enforce compliance by clicking Apply. For more information on the available options in the Evaluate Policies dialog box, see Evaluate Policies Dialog Box, Policy Selection Page and Evaluate Policies Dialog Box, Evaluation Results Page.

  7. When finished, click Close.