New field on report or in SQL?

Apr 1, 2015 at 2:22 PM
Is there any chance we could have a comment/note field on the report or in SQL?

For example we have the policy check for data and log files existing on the same logical disk and in some cases due to server hardware the mdf and ldf reside on D:\ so in that case I would like to add a note to the report to explain this so it's not of any concern.

Thanks
Matt
Coordinator
Apr 1, 2015 at 2:29 PM
It's a framework so you can modify the reports however you see fit. You could possibly do something using database extended properties and modify your conditions to ignore databases with a specific property set. Here's a post I did using this technique that could modify and apply to your workflow.

http://www.sqlchicken.com/2011/10/expiring-databases-and-policy-based-management/

Sent from my Windows Phone