advanced_threat_protection_settings

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

Overview

Name	advanced_threat_protection_settings
Type	Resource
Id	azure.mysql.advanced_threat_protection_settings

Fields

vw_advanced_threat_protection_settings

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

advanced_threat_protection_settings

Name	Datatype	Description
properties	object	Properties of an Advanced Threat Protection setting.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	advancedThreatProtectionName, resourceGroupName, serverName, subscriptionId	Get a server's Advanced Threat Protection state
list	SELECT	resourceGroupName, serverName, subscriptionId	Gets a list of server's Advanced Threat Protection states.
update	UPDATE	advancedThreatProtectionName, resourceGroupName, serverName, subscriptionId	Updates a server's Advanced Threat Protection state.
update_put	EXEC	advancedThreatProtectionName, resourceGroupName, serverName, subscriptionId	Updates a server's Advanced Threat Protection state.

SELECT examples

Gets a list of server's Advanced Threat Protection states.

vw_advanced_threat_protection_settings

SELECT
advancedThreatProtectionName,
creation_time,
provisioning_state,
resourceGroupName,
serverName,
state,
subscriptionId
FROM azure.mysql.vw_advanced_threat_protection_settings
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

advanced_threat_protection_settings

SELECT
properties
FROM azure.mysql.advanced_threat_protection_settings
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

UPDATE example

Updates a advanced_threat_protection_settings resource.

/*+ update */
UPDATE azure.mysql.advanced_threat_protection_settings
SET 
properties = '{{ properties }}'
WHERE 
advancedThreatProtectionName = '{{ advancedThreatProtectionName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';