advanced_threat_protection_settings

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

Overview

Name	advanced_threat_protection_settings
Type	Resource
Id	azure.mysql.advanced_threat_protection_settings

Fields

The following fields are returned by SELECT queries:

get

Successfully retrieved the server's Advanced Threat Protection state.

Name	Datatype	Description
properties	object	Resource properties.

list

Successfully retrieved the server's Advanced Threat Protection states.

Name	Datatype	Description
properties	object	Resource properties.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resourceGroupName, serverName, advancedThreatProtectionName, 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	resourceGroupName, serverName, advancedThreatProtectionName, subscriptionId		Updates a server's Advanced Threat Protection state.
update_put	exec	resourceGroupName, serverName, advancedThreatProtectionName, subscriptionId		Updates a server's Advanced Threat Protection state.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
advancedThreatProtectionName	string	The name of the Advanced Threat Protection state.
resourceGroupName	string	The name of the resource group. The name is case insensitive.
serverName	string	The name of the server.
subscriptionId	string (uuid)	The ID of the target subscription. The value must be an UUID.

SELECT examples

get

Get a server's Advanced Threat Protection state

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

list

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

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

UPDATE examples

update

Updates a server's Advanced Threat Protection state.

UPDATE azure.mysql.advanced_threat_protection_settings
SET 
data__properties = '{{ properties }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}' --required
AND serverName = '{{ serverName }}' --required
AND advancedThreatProtectionName = '{{ advancedThreatProtectionName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
RETURNING
properties;

Lifecycle Methods

update_put

Updates a server's Advanced Threat Protection state.

EXEC azure.mysql.advanced_threat_protection_settings.update_put 
@resourceGroupName='{{ resourceGroupName }}' --required, 
@serverName='{{ serverName }}' --required, 
@advancedThreatProtectionName='{{ advancedThreatProtectionName }}' --required, 
@subscriptionId='{{ subscriptionId }}' --required 
@@json=
'{
"properties": "{{ properties }}"
}'
;