Enable logging by category group for SQL managed instances (microsoft.sql/managedinstances) to Log Analytics

Azure BuiltIn Policy definition

Alias

Namespace

ResourceType

Path

PathIsDefault

DefaultPath

Modifiable

Microsoft.Insights/diagnosticSettings/logs[*]

microsoft.insights

diagnosticSettings

properties.logs[*]

True

False

microsoft.insights/diagnosticSettings/logs[*].categoryGroup

microsoft.insights

diagnosticSettings

properties.logs[*].categoryGroup

True

False

Microsoft.Insights/diagnosticSettings/logs[*].enabled

microsoft.insights

diagnosticSettings

properties.logs[*].enabled

True

False

Microsoft.Insights/diagnosticSettings/workspaceId

microsoft.insights

diagnosticSettings

properties.workspaceId

True

False

Rows: 1-3 / 3

Records:

Use the filters above each column to filter and limit table data. Advanced searches can be performed by using the following operators:
<, <=, >, >=, =, *, !, {, }, ||,&&, [empty], [nonempty], rgx:
Learn more

TableFilter v0.7.3

https://www.tablefilter.com/
©2015-2025 Max Guglielmi

Page of 1

Initiative DisplayName

Initiative Id

Initiative Category

State

Type

polSet in AzUSGov

[Preview]: Control the use of diagnostic settings for specific resources in a Virtual Enclave

0a9ea1cb-7925-47fc-b0fe-8bb0a8190423

VirtualEnclaves

Preview

BuiltIn

true

Enable allLogs category group resource logging for supported resources to Log Analytics

0884adba-2312-4468-abeb-5422caed1038

Monitoring

BuiltIn

unknown

Enable audit category group resource logging for supported resources to Log Analytics

f5b29bc4-feca-4cc6-a58a-772dd5e290a5

Monitoring

BuiltIn

unknown

Date/Time (UTC ymd) (i)

Change type

Change detail

2024-04-29 17:47:10

change

Minor (1.0.0 > 1.1.0)

2023-02-10 18:41:56

add

8fc4ca5f-6abc-4b30-9565-0bd91ac49420

{

displayName: "Enable logging by category group for SQL managed instances (microsoft.sql/managedinstances) to Log Analytics",
policyType: "BuiltIn",
mode: "Indexed",
description: "Resource logs should be enabled to track activities and events that take place on your resources and give you visibility and insights into any changes that occur. This policy deploys a diagnostic setting using a category group to route logs to a Log Analytics workspace for SQL managed instances (microsoft.sql/managedinstances).",
metadata: {2 items
- category: "Monitoring",
- version: "1.1.0"
},
parameters: {5 items
- effect: {4 items
  - type: "String",
  - metadata: {2 items
    - displayName: "Effect",
    - description: "Enable or disable the execution of the policy"
    },
  - allowedValues: [3 items
    - "DeployIfNotExists",
    - "AuditIfNotExists",
    - "Disabled"
    ],
  - defaultValue: "DeployIfNotExists"
  },
- diagnosticSettingName: {3 items
  - type: "String",
  - metadata: {2 items
    - displayName: "Diagnostic Setting Name",
    - description: "Diagnostic Setting Name"
    },
  - defaultValue: "setByPolicy-LogAnalytics"
  },
- categoryGroup: {4 items
  - type: "String",
  - metadata: {2 items
    - displayName: "Category Group",
    - description: "Diagnostic category group - none, audit, or allLogs."
    },
  - allowedValues: [2 items
    - "audit",
    - "allLogs"
    ],
  - defaultValue: "audit"
  },
- resourceLocationList: {3 items
  - type: "Array",
  - metadata: {2 items
    - displayName: "Resource Location List",
    - description: "Resource Location List to send logs to nearby Log Analytics. A single entry "*" selects all locations (default)."
    },
  - defaultValue: [1 item
    - "*"
    ]
  },
- logAnalytics: {2 items
  - type: "String",
  - metadata: {4 items
    - displayName: "Log Analytics Workspace",
    - description: "Log Analytics Workspace",
    - strongType: "omsWorkspace",
    - assignPermissions: true
    }
  }
},
policyRule: {2 items
- if: {1 item
  - allOf: [2 items
    - {2 items
      - field: "type",
      - equals: "microsoft.sql/managedinstances"
      },
    - {1 item
      - anyOf: [2 items
        {2 items
        value: 🔍"[ first( parameters('resourceLocationList') ) ]",
        equals: "*"
        },
        {2 items
        field: "location",
        in: "[parameters('resourceLocationList')]"
        }
        ]
      }
    ]
  },
- then: {2 items
  - effect: "[parameters('effect')]",
  - details: {5 items
    - type: "Microsoft.Insights/diagnosticSettings",
    - evaluationDelay: "AfterProvisioning",
    - existenceCondition: {1 item
      - allOf: [3 items
        {2 items
        count: {2 items
        field: "Microsoft.Insights/diagnosticSettings/logs[*]",
        where: {1 item
        allOf: [2 items
        {2 items
        field: "Microsoft.Insights/diagnosticSettings/logs[*].enabled",
        equals: 🔍"[ equals( parameters('categoryGroup'), 'audit' ) ]"
        },
        {2 items
        field: "microsoft.insights/diagnosticSettings/logs[*].categoryGroup",
        equals: "audit"
        }
        ]
        }
        },
        equals: 1
        },
        {2 items
        count: {2 items
        field: "Microsoft.Insights/diagnosticSettings/logs[*]",
        where: {1 item
        allOf: [2 items
        {2 items
        field: "Microsoft.Insights/diagnosticSettings/logs[*].enabled",
        equals: 🔍"[ equals( parameters('categoryGroup'), 'allLogs' ) ]"
        },
        {2 items
        field: "microsoft.insights/diagnosticSettings/logs[*].categoryGroup",
        equals: "allLogs"
        }
        ]
        }
        },
        equals: 1
        },
        {2 items
        field: "Microsoft.Insights/diagnosticSettings/workspaceId",
        equals: "[parameters('logAnalytics')]"
        }
        ]
      },
    - roleDefinitionIds: [1 item
      - "/providers/Microsoft.Authorization/roleDefinitions/92aaf0da-9dab-42b6-94a3-d43ce8d16293" Log Analytics Contributor
      ],
    - deployment: {1 item
      - properties: {3 items
        mode: "incremental",
        template: {6 items
        $schema: "http://schema.management.azure.com/schemas/2019-08-01/deploymentTemplate.json#",
        contentVersion: "1.0.0.0",
        parameters: {4 items
        diagnosticSettingName: {1 item
        type: "string"
        },
        logAnalytics: {1 item
        type: "string"
        },
        categoryGroup: {1 item
        type: "String"
        },
        resourceName: {1 item
        type: "string"
        }
        },
        variables: {},
        resources: [1 item
        {4 items
        type: "microsoft.sql/managedinstances/providers/diagnosticSettings",
        apiVersion: "2021-05-01-preview",
        name: 🔍"[ concat( parameters('resourceName'), '/', 'Microsoft.Insights/', parameters('diagnosticSettingName') ) ]",
        properties: {3 items
        workspaceId: "[parameters('logAnalytics')]",
        logs: [2 items
        {2 items
        categoryGroup: "audit",
        enabled: 🔍"[ equals( parameters('categoryGroup'), 'audit' ) ]"
        },
        {2 items
        categoryGroup: "allLogs",
        enabled: 🔍"[ equals( parameters('categoryGroup'), 'allLogs' ) ]"
        }
        ],
        metrics: []
        }
        }
        ],
        outputs: {1 item
        policy: {2 items
        type: "string",
        value: 🔍"[ concat( 'Diagnostic setting', parameters('diagnosticSettingName'), 'for type SQL managed instances ( microsoft.sql/managedinstances ), resourceName', parameters('resourceName'), 'to Log Analytics', parameters('logAnalytics'), 'configured' ) ]"
        }
        }
        },
        parameters: {4 items
        diagnosticSettingName: {1 item
        value: "[parameters('diagnosticSettingName')]"
        },
        logAnalytics: {1 item
        value: "[parameters('logAnalytics')]"
        },
        categoryGroup: {1 item
        value: "[parameters('categoryGroup')]"
        },
        resourceName: {1 item
        value: "[field('name')]"
        }
        }
        }
      }
    }
  }
}

}