managed_instance_advanced_threat_protection_settings

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

Overview

Name	managed_instance_advanced_threat_protection_settings
Type	Resource
Id	azure.sql.managed_instance_advanced_threat_protection_settings

Fields

vw_managed_instance_advanced_threat_protection_settings

Name	Datatype	Description
advancedThreatProtectionName	text	field from the properties object
creation_time	text	field from the properties object
managedInstanceName	text	field from the properties object
resourceGroupName	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object

managed_instance_advanced_threat_protection_settings

Name	Datatype	Description
properties	object	Properties of an Advanced Threat Protection state.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	advancedThreatProtectionName, managedInstanceName, resourceGroupName, subscriptionId	Get a managed instance's Advanced Threat Protection state.
create_or_update	INSERT	advancedThreatProtectionName, managedInstanceName, resourceGroupName, subscriptionId	Creates or updates Advanced Threat Protection settings.

SELECT examples

Get a managed instance's Advanced Threat Protection state.

vw_managed_instance_advanced_threat_protection_settings

SELECT
advancedThreatProtectionName,
creation_time,
managedInstanceName,
resourceGroupName,
state,
subscriptionId,
system_data
FROM azure.sql.vw_managed_instance_advanced_threat_protection_settings
WHERE advancedThreatProtectionName = '{{ advancedThreatProtectionName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

managed_instance_advanced_threat_protection_settings

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

INSERT example

Use the following StackQL query and manifest file to create a new managed_instance_advanced_threat_protection_settings resource.

All Properties

/*+ create */
INSERT INTO azure.sql.managed_instance_advanced_threat_protection_settings (
advancedThreatProtectionName,
managedInstanceName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ advancedThreatProtectionName }}',
'{{ managedInstanceName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: properties
      value:
        - name: state
          value: string
        - name: creationTime
          value: string