December 9, 2008 at 10:34 am
I'm looking to setup a set of policies on my servers to help prevent issues and also to simplify configuration of the instances.
I'm feeling somewhat lazy, and so don't want to have to manually type each facet into a spreadsheet, and the query below was nice and easy to put together.
select e.event_name, e.target_type, e.target_type_alias, f.name
From msdb.dbo.syspolicy_facet_events e
inner join msdb.dbo.syspolicy_management_facets f
on e.management_facet_id = f.management_facet_id
The problem I have run into is that I would like to build a list of the properties for each facet. MSDN blogs indicate that this was all written in C# (which is why there is not the ability to create new facets).
Anybody know a way that I could pull a list of the property items from each facet? This would allow a colleague and myself to go through the list and look at what facets might apply to what we need without having to perform a click and check.
Thanks
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply