Skip to main content

managed_server_security_alert_policies_by_instances

Creates, updates, deletes, gets or lists a managed_server_security_alert_policies_by_instances resource.

Overview

Namemanaged_server_security_alert_policies_by_instances
TypeResource
Idazure.sql.managed_server_security_alert_policies_by_instances

Fields

NameDatatypeDescription
propertiesobjectProperties of a security alert policy.
systemDataobjectMetadata pertaining to creation and last modification of the resource.

Methods

NameAccessible byRequired ParamsDescription
listSELECTmanagedInstanceName, resourceGroupName, subscriptionIdGet the managed server's threat detection policies.

SELECT examples

Get the managed server's threat detection policies.

SELECT
properties,
systemData
FROM azure.sql.managed_server_security_alert_policies_by_instances
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';