Post reply

Policy Based management script?

  • November 16, 2012 at 5:43 am

    #270314

    Is there a tsql script that can give me details (name, condition, created by etc) of all the policies created on my sql server?

  • November 16, 2012 at 5:48 am

    #1559754

    You should be able to knock one up quick using msdb.dbo.syspolicy_################ tables

  • November 16, 2012 at 11:37 am

    #1559894

    but the condition is given in code, not the actual condition

    how do i get the actual condition?

  • November 19, 2012 at 2:05 am

    #1560208

    You will need to shred the XML into its parts to rebuild the condition as it look in the GUI.

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

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