Skip to main content

vw_database_recommended_actions

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

Overview​

Namevw_database_recommended_actions
TypeView
Idazure.sql.vw_database_recommended_actions

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
location as location,
kind as kind,
JSON_EXTRACT(properties, '$.recommendationReason') as "recommendation_reason",
JSON_EXTRACT(properties, '$.validSince') as "valid_since",
JSON_EXTRACT(properties, '$.lastRefresh') as "last_refresh",
JSON_EXTRACT(properties, '$.state') as "state",
JSON_EXTRACT(properties, '$.isExecutableAction') as "is_executable_action",
JSON_EXTRACT(properties, '$.isRevertableAction') as "is_revertable_action",
JSON_EXTRACT(properties, '$.isArchivedAction') as "is_archived_action",
JSON_EXTRACT(properties, '$.executeActionStartTime') as "execute_action_start_time",
JSON_EXTRACT(properties, '$.executeActionDuration') as "execute_action_duration",
JSON_EXTRACT(properties, '$.revertActionStartTime') as "revert_action_start_time",
JSON_EXTRACT(properties, '$.revertActionDuration') as "revert_action_duration",
JSON_EXTRACT(properties, '$.executeActionInitiatedBy') as "execute_action_initiated_by",
JSON_EXTRACT(properties, '$.executeActionInitiatedTime') as "execute_action_initiated_time",
JSON_EXTRACT(properties, '$.revertActionInitiatedBy') as "revert_action_initiated_by",
JSON_EXTRACT(properties, '$.revertActionInitiatedTime') as "revert_action_initiated_time",
JSON_EXTRACT(properties, '$.score') as "score",
JSON_EXTRACT(properties, '$.implementationDetails') as "implementation_details",
JSON_EXTRACT(properties, '$.errorDetails') as "error_details",
JSON_EXTRACT(properties, '$.estimatedImpact') as "estimated_impact",
JSON_EXTRACT(properties, '$.observedImpact') as "observed_impact",
JSON_EXTRACT(properties, '$.timeSeries') as "time_series",
JSON_EXTRACT(properties, '$.linkedObjects') as "linked_objects",
JSON_EXTRACT(properties, '$.details') as "details",
subscriptionId,
resourceGroupName,
serverName,
databaseName,
advisorName,
recommendedActionName
FROM azure.sql.database_recommended_actions
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serverName = 'replace-me' AND databaseName = 'replace-me' AND advisorName = 'replace-me' AND recommendedActionName = 'replace-me';