recommended_actions

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

Overview

Name	recommended_actions
Type	Resource
Id	azure.maria_db.recommended_actions

Fields

vw_recommended_actions

Name	Datatype	Description
action_id	text	field from the properties object
advisorName	text	field from the properties object
advisor_name	text	field from the properties object
created_time	text	field from the properties object
details	text	field from the properties object
expiration_time	text	field from the properties object
reason	text	field from the properties object
recommendation_type	text	field from the properties object
recommendedActionName	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
session_id	text	field from the properties object
subscriptionId	text	field from the properties object

recommended_actions

Name	Datatype	Description
properties	object	The properties of a recommendation action.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	advisorName, recommendedActionName, resourceGroupName, serverName, subscriptionId	Retrieve recommended actions from the advisor.
list_by_server	SELECT	advisorName, resourceGroupName, serverName, subscriptionId	Retrieve recommended actions from the advisor.

SELECT examples

Retrieve recommended actions from the advisor.

vw_recommended_actions

SELECT
action_id,
advisorName,
advisor_name,
created_time,
details,
expiration_time,
reason,
recommendation_type,
recommendedActionName,
resourceGroupName,
serverName,
session_id,
subscriptionId
FROM azure.maria_db.vw_recommended_actions
WHERE advisorName = '{{ advisorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

recommended_actions

SELECT
properties
FROM azure.maria_db.recommended_actions
WHERE advisorName = '{{ advisorName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';