Chapter 8. Reporting

In Chapter 6, we explored some of the internal structures of Policy-Based Management, and you even learned how to query those pieces to extract useful information about policies and their executions. While this chapter focuses on the Enterprise Policy Management (EPM) Framework, having the knowledge of those internal structures allows you to create your own custom reports to meet your needs.

The EPM Framework is a free reporting solution developed by Lara Rubbelke, Dmitri Tchikatilov, and Tom Davidson. The EPM Framework helps extend Policy-Based Management to all versions of SQL Server in an enterprise (SQL Server 2000 and higher). The EPM Framework accomplishes this by utilizing PowerShell to evaluate your policies against ...

Get Pro SQL Server 2008 Policy-Based Management now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.