assessed_sql_recommended_entity_operations

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

Overview

Name	assessed_sql_recommended_entity_operations
Type	Resource
Id	azure.migration_assessment.assessed_sql_recommended_entity_operations

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. # pylint: disable=line-too-long
name	string	The name of the resource.
assessedSqlEntityArmId	string	Gets or sets Arm id of assessed entity.
azureSqlDBSuitabilityDetails	object	SQL instance azure SQL DB suitability details.
azureSqlMISuitabilityDetails	object	SQL instance azure SQL MI suitability details.
azureSqlVMSuitabilityDetails	object	SQL instance azure SQL VM suitability details.
dbCount	integer	Gets or sets assessed database count.
discoveredDBCount	integer	Gets or sets the total discovered database count.
hasScanOccurred	boolean	Gets or sets a value indicating whether instance deep discovery has occurred or not.
instanceName	string	Gets or sets SQL instance name.
isClustered	boolean	Gets or sets a value indicating whether the SQL instance is clustered or not.
isHighAvailabilityEnabled	boolean	Gets or sets a value indicating whether the high availability is enabled or not.
machineName	string	Gets or sets machine name.
productSupportStatus	object	Gets the product support status related details.
recommendedAzureSqlTargetType	string	Gets or sets the recommended azure SQL target type. Known values are: "Unknown", "Recommended", "AzureSqlDatabase", "AzureSqlManagedInstance", "AzureSqlVirtualMachine", and "AzureVirtualMachine".
recommendedSuitability	string	Gets or sets the recommended azure SQL suitability. Known values are: "Unknown", "SuitableForSqlDB", "SuitableForSqlMI", "SuitableForVM", "PotentiallySuitableForVM", "ReadinessUnknown", "NotSuitable", "SuitableForSqlVM", "ConditionallySuitableForSqlDB", "ConditionallySuitableForSqlMI", "ConditionallySuitableForVM", and "ConditionallySuitableForSqlVM".
sizingCriterion	string	Assessment sizing criterion. Known values are: "PerformanceBased" and "AsOnPremises".
sqlEdition	string	Gets the SQL edition from the recommended entity if applicable.
sqlVersion	string	Gets the SQL version from the recommended entity if applicable.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

list_by_sql_assessment_v2

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. # pylint: disable=line-too-long
name	string	The name of the resource.
assessedSqlEntityArmId	string	Gets or sets Arm id of assessed entity.
azureSqlDBSuitabilityDetails	object	SQL instance azure SQL DB suitability details.
azureSqlMISuitabilityDetails	object	SQL instance azure SQL MI suitability details.
azureSqlVMSuitabilityDetails	object	SQL instance azure SQL VM suitability details.
dbCount	integer	Gets or sets assessed database count.
discoveredDBCount	integer	Gets or sets the total discovered database count.
hasScanOccurred	boolean	Gets or sets a value indicating whether instance deep discovery has occurred or not.
instanceName	string	Gets or sets SQL instance name.
isClustered	boolean	Gets or sets a value indicating whether the SQL instance is clustered or not.
isHighAvailabilityEnabled	boolean	Gets or sets a value indicating whether the high availability is enabled or not.
machineName	string	Gets or sets machine name.
productSupportStatus	object	Gets the product support status related details.
recommendedAzureSqlTargetType	string	Gets or sets the recommended azure SQL target type. Known values are: "Unknown", "Recommended", "AzureSqlDatabase", "AzureSqlManagedInstance", "AzureSqlVirtualMachine", and "AzureVirtualMachine".
recommendedSuitability	string	Gets or sets the recommended azure SQL suitability. Known values are: "Unknown", "SuitableForSqlDB", "SuitableForSqlMI", "SuitableForVM", "PotentiallySuitableForVM", "ReadinessUnknown", "NotSuitable", "SuitableForSqlVM", "ConditionallySuitableForSqlDB", "ConditionallySuitableForSqlMI", "ConditionallySuitableForVM", and "ConditionallySuitableForSqlVM".
sizingCriterion	string	Assessment sizing criterion. Known values are: "PerformanceBased" and "AsOnPremises".
sqlEdition	string	Gets the SQL edition from the recommended entity if applicable.
sqlVersion	string	Gets the SQL version from the recommended entity if applicable.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resource_group_name, project_name, group_name, assessment_name, recommended_assessed_entity_name, subscription_id		Get a AssessedSqlRecommendedEntity.
list_by_sql_assessment_v2	select	resource_group_name, project_name, group_name, assessment_name, subscription_id	$filter, pageSize, continuationToken, totalRecordCount	List AssessedSqlRecommendedEntity resources by SqlAssessmentV2.

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
assessment_name	string	SQL Assessment arm name. Required.
group_name	string	Group ARM name. Required.
project_name	string	Assessment Project Name. Required.
recommended_assessed_entity_name	string	Sql assessment Assessed Recommended Entity ARM name. Required.
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
subscription_id	string
$filter	string	Filter query. Default value is None.
continuationToken	string	Optional parameter for continuation token. Default value is None.
pageSize	integer	Optional parameter for page size. Default value is None.
totalRecordCount	integer	Total record count. Default value is None.

SELECT examples

get

Get a AssessedSqlRecommendedEntity.

SELECT
id,
name,
assessedSqlEntityArmId,
azureSqlDBSuitabilityDetails,
azureSqlMISuitabilityDetails,
azureSqlVMSuitabilityDetails,
dbCount,
discoveredDBCount,
hasScanOccurred,
instanceName,
isClustered,
isHighAvailabilityEnabled,
machineName,
productSupportStatus,
recommendedAzureSqlTargetType,
recommendedSuitability,
sizingCriterion,
sqlEdition,
sqlVersion,
systemData,
type
FROM azure.migration_assessment.assessed_sql_recommended_entity_operations
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND project_name = '{{ project_name }}' -- required
AND group_name = '{{ group_name }}' -- required
AND assessment_name = '{{ assessment_name }}' -- required
AND recommended_assessed_entity_name = '{{ recommended_assessed_entity_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_sql_assessment_v2

List AssessedSqlRecommendedEntity resources by SqlAssessmentV2.

SELECT
id,
name,
assessedSqlEntityArmId,
azureSqlDBSuitabilityDetails,
azureSqlMISuitabilityDetails,
azureSqlVMSuitabilityDetails,
dbCount,
discoveredDBCount,
hasScanOccurred,
instanceName,
isClustered,
isHighAvailabilityEnabled,
machineName,
productSupportStatus,
recommendedAzureSqlTargetType,
recommendedSuitability,
sizingCriterion,
sqlEdition,
sqlVersion,
systemData,
type
FROM azure.migration_assessment.assessed_sql_recommended_entity_operations
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND project_name = '{{ project_name }}' -- required
AND group_name = '{{ group_name }}' -- required
AND assessment_name = '{{ assessment_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND $filter = '{{ $filter }}'
AND pageSize = '{{ pageSize }}'
AND continuationToken = '{{ continuationToken }}'
AND totalRecordCount = '{{ totalRecordCount }}'
;