Just Learned - SQL Server-Find all policy details with using DMV syspolicy_policies and syspolicy_conditions.

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

SQL Server-Find all policy details with using DMV syspolicy_policies and syspolicy_conditions.

Sep 17 2011 10:56AM by Fazal Vahora

I just learned one new thing"How to find all policy details like policy name,create date,facets and object with using DMVs(Dynamic Management Views) syspolicypolicies and syspolicyconditions. " all policy based management(PBM) data stored in MSDB Database.check out following two queries.

use msdb
go
Select name,date_created from  syspolicy_policies
go

use msdb
go
Select name,date_created ,facet,obj_name  from syspolicy_conditions
go

Read More.. [0 clicks]

Published under: SQL Server Tips · · · ·

Previous: Difference and Similarity Between NEWSEQUENTIALID() and NEWID()
Next: Workaround for Sql server error-MSDTC on server is unavailable

Fazal Vahora

21 · 9% · 2806

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it


	Submit

Your Comment

Sign Up or Login to post a comment.

"SQL Server-Find all policy details with using DMV syspolicy_policies and syspolicy_conditions." rated 5 out of 5 by 9 readers

SQL Server-Find all policy details with using DMV syspolicy_policies and syspolicy_conditions.

Your Comment