recommendations

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

Overview

Name	recommendations
Type	Resource
Id	azure.advisor.recommendations

Fields

vw_recommendations

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	text	The name of the resource
description	text	field from the properties object
actions	text	field from the properties object
category	text	field from the properties object
exposed_metadata_properties	text	field from the properties object
extended_properties	text	field from the properties object
impact	text	field from the properties object
impacted_field	text	field from the properties object
impacted_value	text	field from the properties object
label	text	field from the properties object
last_updated	text	field from the properties object
learn_more_link	text	field from the properties object
metadata	text	field from the properties object
potential_benefits	text	field from the properties object
recommendationId	text	field from the properties object
recommendation_type_id	text	field from the properties object
remediation	text	field from the properties object
resourceUri	text	field from the properties object
resource_metadata	text	field from the properties object
risk	text	field from the properties object
short_description	text	field from the properties object
subscriptionId	text	field from the properties object
suppression_ids	text	field from the properties object
system_data	text	field from the properties object
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

recommendations

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	string	The name of the resource
properties	object	The properties of the recommendation.
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	recommendationId, resourceUri	Obtains details of a cached recommendation.
list	SELECT	subscriptionId	Obtains cached recommendations for a subscription. The recommendations are generated or computed by invoking generateRecommendations.
exec_get_generate_status	EXEC	operationId, subscriptionId	Retrieves the status of the recommendation computation or generation process. Invoke this API after calling the generation recommendation. The URI of this API is returned in the Location field of the response header.
generate	EXEC	subscriptionId	Initiates the recommendation generation or computation process for a subscription. This operation is asynchronous. The generated recommendations are stored in a cache in the Advisor service.
predict	EXEC	subscriptionId

SELECT examples

Obtains cached recommendations for a subscription. The recommendations are generated or computed by invoking generateRecommendations.

vw_recommendations

SELECT
id,
name,
description,
actions,
category,
exposed_metadata_properties,
extended_properties,
impact,
impacted_field,
impacted_value,
label,
last_updated,
learn_more_link,
metadata,
potential_benefits,
recommendationId,
recommendation_type_id,
remediation,
resourceUri,
resource_metadata,
risk,
short_description,
subscriptionId,
suppression_ids,
system_data,
type
FROM azure.advisor.vw_recommendations
WHERE subscriptionId = '{{ subscriptionId }}';

recommendations

SELECT
id,
name,
properties,
systemData,
type
FROM azure.advisor.recommendations
WHERE subscriptionId = '{{ subscriptionId }}';