3 new terms are associated with Policy Management.
- Policy - A group of conditions to be checked/enforced
- Conditions - State of Facets (true/false).
- Facet - Manageable properties of SQL object.
Policy Based Mamagement (PBM) is found under 'Management on a SQL 2008 instance >
There are currently 84 'Facets' you can define policies for -
It's easy to list them via TSQL -
use msdb select name from dbo.syspolicy_management_facets go
or you can list all the facets and the target types and they can be applied to >
use msdb select f.name as facet_name ,fe.event_name ,fe.target_type ,fe.target_type_alias from dbo.syspolicy_management_facets f inner join dbo.syspolicy_facet_events fe on f.management_facet_id = fe.management_facet_id go
Useful PBM Links:
Getting a list of all Facets and their properties