assessed_sql_instance_v2_operations

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

Overview

Name	assessed_sql_instance_v2_operations
Type	Resource
Id	azure.migration_assessment.assessed_sql_instance_v2_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.
availabilityReplicaSummary	object	Gets the overview counts of availability replicas in the assessed instance, by commit mode and read type.
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.
confidenceRatingInPercentage	number	Confidence Rating in Percentage.
createdTimestamp	string (date-time)	When was assessed SQL instance first created.
databaseSummary	object	The databases summary.
fciMetadata	object	Gets the FCI metadata if this instance represents an FCI instance.
hasScanOccurred	boolean	Gets or sets a value indicating whether SQL instance has been deep discovered.
instanceName	string	SQL instance name.
isClustered	boolean	Gets a value indicating whether the SQL instance is clustered or not.
isHighAvailabilityEnabled	boolean	Gets a value indicating whether the high availability is enabled or not.
logicalDisks	array	The logical disk details.
machineArmId	string	Machine arm id.
machineName	string	Machine display name.
memoryInUseInMB	number	Gets or sets the memory used by SQL instance in megabytes.
numberOfCoresAllocated	integer	Number of CPU cores assigned to the SQL instance.
percentageCoresUtilization	number	The percentage of the total number of cores being utilized by the SQL instance.
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".
recommendedTargetReasonings	array	Gets the list of recommended target reasoning.
sizingCriterion	string	Assessment sizing criterion. Known values are: "PerformanceBased" and "AsOnPremises".
sqlEdition	string	SQL instance edition.
sqlInstanceSdsArmId	string	SQL instance SDS arm id.
sqlVersion	string	SQL instance version.
storageTypeBasedDetails	array	Gets the storage details.
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".
updatedTimestamp	string (date-time)	When was assessed SQL instance last updated.

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.
availabilityReplicaSummary	object	Gets the overview counts of availability replicas in the assessed instance, by commit mode and read type.
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.
confidenceRatingInPercentage	number	Confidence Rating in Percentage.
createdTimestamp	string (date-time)	When was assessed SQL instance first created.
databaseSummary	object	The databases summary.
fciMetadata	object	Gets the FCI metadata if this instance represents an FCI instance.
hasScanOccurred	boolean	Gets or sets a value indicating whether SQL instance has been deep discovered.
instanceName	string	SQL instance name.
isClustered	boolean	Gets a value indicating whether the SQL instance is clustered or not.
isHighAvailabilityEnabled	boolean	Gets a value indicating whether the high availability is enabled or not.
logicalDisks	array	The logical disk details.
machineArmId	string	Machine arm id.
machineName	string	Machine display name.
memoryInUseInMB	number	Gets or sets the memory used by SQL instance in megabytes.
numberOfCoresAllocated	integer	Number of CPU cores assigned to the SQL instance.
percentageCoresUtilization	number	The percentage of the total number of cores being utilized by the SQL instance.
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".
recommendedTargetReasonings	array	Gets the list of recommended target reasoning.
sizingCriterion	string	Assessment sizing criterion. Known values are: "PerformanceBased" and "AsOnPremises".
sqlEdition	string	SQL instance edition.
sqlInstanceSdsArmId	string	SQL instance SDS arm id.
sqlVersion	string	SQL instance version.
storageTypeBasedDetails	array	Gets the storage details.
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".
updatedTimestamp	string (date-time)	When was assessed SQL instance last updated.

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, assessed_sql_instance_name, subscription_id		Get a AssessedSqlInstanceV2.
list_by_sql_assessment_v2	select	resource_group_name, project_name, group_name, assessment_name, subscription_id	$filter, pageSize, continuationToken, totalRecordCount	List AssessedSqlInstanceV2 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
assessed_sql_instance_name	string	Sql assessment Assessed Instance ARM name. Required.
assessment_name	string	SQL Assessment arm name. Required.
group_name	string	Group ARM name. Required.
project_name	string	Assessment Project 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 AssessedSqlInstanceV2.

SELECT
id,
name,
availabilityReplicaSummary,
azureSqlDBSuitabilityDetails,
azureSqlMISuitabilityDetails,
azureSqlVMSuitabilityDetails,
confidenceRatingInPercentage,
createdTimestamp,
databaseSummary,
fciMetadata,
hasScanOccurred,
instanceName,
isClustered,
isHighAvailabilityEnabled,
logicalDisks,
machineArmId,
machineName,
memoryInUseInMB,
numberOfCoresAllocated,
percentageCoresUtilization,
productSupportStatus,
recommendedAzureSqlTargetType,
recommendedSuitability,
recommendedTargetReasonings,
sizingCriterion,
sqlEdition,
sqlInstanceSdsArmId,
sqlVersion,
storageTypeBasedDetails,
systemData,
type,
updatedTimestamp
FROM azure.migration_assessment.assessed_sql_instance_v2_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 assessed_sql_instance_name = '{{ assessed_sql_instance_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_sql_assessment_v2

List AssessedSqlInstanceV2 resources by SqlAssessmentV2.

SELECT
id,
name,
availabilityReplicaSummary,
azureSqlDBSuitabilityDetails,
azureSqlMISuitabilityDetails,
azureSqlVMSuitabilityDetails,
confidenceRatingInPercentage,
createdTimestamp,
databaseSummary,
fciMetadata,
hasScanOccurred,
instanceName,
isClustered,
isHighAvailabilityEnabled,
logicalDisks,
machineArmId,
machineName,
memoryInUseInMB,
numberOfCoresAllocated,
percentageCoresUtilization,
productSupportStatus,
recommendedAzureSqlTargetType,
recommendedSuitability,
recommendedTargetReasonings,
sizingCriterion,
sqlEdition,
sqlInstanceSdsArmId,
sqlVersion,
storageTypeBasedDetails,
systemData,
type,
updatedTimestamp
FROM azure.migration_assessment.assessed_sql_instance_v2_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 }}'
;