advisors

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

Overview

Name	advisors
Type	Resource
Id	azure.maria_db.advisors

Fields

vw_advisors

Name	Datatype	Description
advisorName	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
subscriptionId	text	field from the properties object

advisors

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	advisorName, resourceGroupName, serverName, subscriptionId	Get a recommendation action advisor.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId	List recommendation action advisors.

SELECT examples

List recommendation action advisors.

vw_advisors

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

advisors

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