\nThis is the second part in a series about programming policy-based management. The series starts here.\n<\/p>\n
\nTo build our MailOffByDefault policy we need:
\n Condition that specifies properties and settings
\n Policy that uses the condition\n<\/p>\n
\nCondition first. This looks pretty straighforward.\n<\/p>\n
\nCondition con1 = new Condition(ps, "MailOffSMO");
\ncon1.Facet = "ISurfaceAreaFacet";
\ncon1.ExpressionNode = ExpressionNode.Parse(
\n "@DatabaseMailEnabled = 0 and @SqlMailEnabled = 0");
\ncon1.Create();\n<\/p>\n
\nThe Condition class uses PolicyStore instance (ps) and names the condition (MailOffSMO). You initialize a facet with a string. So where did the string come from? It is named in the SMO library but I "found" it by making an equivalent condition with SSMS and inspecting it.\n<\/p>\n
\nforeach (Condition c in ps.Conditions)
\n \/\/ … look at c in the VS visualizer\n<\/p>\n
\nExpressionNode should "define" my condition, and since there is no ExpressionNode constructor, I first tried Parse(). This created the Condition, but it was unusable in SSMS. SSMS wanted "false" not "0". I searched around for how to specify "false" in the parse string for a while, then came upon something better.\n<\/p>\n
\nExpressionNode has six subclasses that can be used in combination to specify any set of expressions that you need. These are
\n ExpressionNodeAttribute
\n ExpressionNodeConstant
\n ExpressionNodeChildren (with subclasses)
\n ExpressionNodeFunction, ExpressionNodeGroup, and ExpressionNodeOperation\n<\/p>\n
\nThat's next.<\/p>\n","protected":false},"excerpt":{"rendered":"
This is the second part in a series about programming policy-based management. The series starts here. To build our MailOffByDefault policy we need: Condition that specifies properties and settings Policy that uses the condition Condition first. This looks pretty straighforward. Condition con1 = new Condition(ps, "MailOffSMO"); con1.Facet = "ISurfaceAreaFacet"; con1.ExpressionNode = ExpressionNode.Parse( […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20,25,29],"tags":[],"class_list":["post-708","post","type-post","status-publish","format-standard","hentry","category-policy-based-management","category-smo","category-sql-server-2008"],"yoast_head":"\n