server_advanced_threat_protection_settings

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

Overview

Name	server_advanced_threat_protection_settings
Type	Resource
Id	azure.sql.server_advanced_threat_protection_settings

Fields

vw_server_advanced_threat_protection_settings

Name	Datatype	Description
advancedThreatProtectionName	text	field from the properties object
creation_time	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	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

server_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, resourceGroupName, serverName, subscriptionId	Get a server's Advanced Threat Protection state.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId	Get a list of the server's Advanced Threat Protection states.
create_or_update	INSERT	advancedThreatProtectionName, resourceGroupName, serverName, subscriptionId	Creates or updates an Advanced Threat Protection state.

SELECT examples

Get a list of the server's Advanced Threat Protection states.

vw_server_advanced_threat_protection_settings

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

server_advanced_threat_protection_settings

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.server_advanced_threat_protection_settings (
advancedThreatProtectionName,
resourceGroupName,
serverName,
subscriptionId,
properties
)
SELECT 
'{{ advancedThreatProtectionName }}',
'{{ resourceGroupName }}',
'{{ serverName }}',
'{{ 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