azure - Azure 自定义策略为处于冲突状态的 sql db 打开混合许可证

Question

如果未启用，我正在创建一个自定义策略以在 SQL 数据库上启用混合定价。我让它在 AUDIT 模式下工作 - 请参阅下面的政策 - 以下政策正在工作..它发现两个数据库不合规。但是，当我尝试添加附加操作时，我在没有选择混合选项的两个数据库上得到 2 个冲突 - 我期待并希望该策略能够在这两个数据库上启用混合模式。第二个策略的代码也在下面。

` "properties": {
    "displayName": "Audit SQL DB without Hybrid Licensing",
    "policyType": "Custom",
    "mode": "All",
    "description": "Generate audit record if SQL DB is not configured for hybrid license",
    "metadata": {
      "category": "SQL",
      "createdBy": "5a53d124-483a-4726-9b6f-bd9fa5e56cf3",
      "createdOn": "2020-12-11T19:52:20.1852612Z",
      "updatedBy": "5a53d124-483a-4726-9b6f-bd9fa5e56cf3",
      "updatedOn": "2020-12-23T17:36:10.6538643Z"
    },
    "parameters": {},
    "policyRule": {
      "if": {
        "allOf": [
          {
            "field": "type",
            "equals": "Microsoft.SQL/servers/databases"
          },
          {
            "field": "kind",
            "contains": "vcore"
          },
          {
            "field": "Microsoft.Sql/servers/databases/licenseType",
            "notEquals": "BasePrice"
          },
          {
            "field": "Microsoft.Sql/servers/databases/sku.name",
            "notEquals": "ElasticPool"
          }
        ]
      },
      "then": {
        "effect": "audit"
      }
    }
  },
`

第二个政策不起作用，但会产生 2 个冲突

    {
  "mode": "All",
  "policyRule": {
    "if": {
      "allOf": [
        {
          "field": "type",
          "equals": "Microsoft.SQL/servers/databases"
        },
        {
          "field": "kind",
          "contains": "vcore"
        },
        {
          "field": "Microsoft.Sql/servers/databases/licenseType",
          "notEquals": "BasePrice"
        },
        {
          "field": "Microsoft.Sql/servers/databases/sku.name",
          "notEquals": "ElasticPool"
        }
      ]
    },
    "then": {
      "effect": "append",
      "details": [
        {
          "field": "Microsoft.Sql/servers/databases/licenseType",
          "value": "BasePrice"
        }
      ]
    }
  },
  "parameters": {}
}

标签： azure