Policy-based management output

Question

Policy-based management output

GoofyKC

SSCommitted

Points: 1586
More actions
January 22, 2010 at 3:15 pm

#215767

I am trying to get the process of using policy-based management down and I am starting to get a grasp. What I don't understand at all is if I schedule some policies to run in the night, how am I suppose to get results. Is there another portion that has to setup? Is there some way to email the results? Any advice is appreciated.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 1

I would strongly suggest you take a look at the Enterprise Policy Management Framework. It's from a Microsoft developer and it's free. It extends PBM for use with 2000 and 2005, plus, it provides a mechanism for collecting data from the policy checks and storing it in tables for later reporting. If nothing else, take a look at that as a good mechanism for answering your question, even if you don't implment the whole thing.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

GoofyKC SSCommitted Points: 1586 More actions · Answer 2

Thank you very much for the link and pointing me to EPM Framework. I googled it and found a recorded webcast that is very interesting on this subject. http://sqlblog.com/blogs/lara_rubbelke/archive/2009/03/04/enterprise-policy-management-updates-new-whitepaper-and-upcoming-webcast.aspx

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 3

That's good. Buck Woody also did a fantastic presentation about it at the last PASS Summit.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Chuck Hottle SSCarpal Tunnel Points: 4777 More actions · Answer 4

This article shows the message number for various violations. You can then set up an alert of one or more of these message numbers that will send an email to an operator. While testing this out, I also noticed that, the job that is created writes to the Windows Event Log and the Error Log if there is a violation.

http://msdn.microsoft.com/es-es/library/bb510667(SQL.105).aspx