sql_assessment_options_operations

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

Overview

Name	sql_assessment_options_operations
Type	Resource
Id	azure.migration_assessment.sql_assessment_options_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.
premiumDiskVmFamilies	array	Gets the Premium disk VM Families list.
reservedInstanceSqlTargets	array	Gets or sets the Reserved Instance SQL target types.
reservedInstanceSupportedCurrencies	array	Gets or sets the list of currencies supported for Reserved Instances.
reservedInstanceSupportedLocations	array	Gets or sets the list of Azure locations supporting Reserved Instances.
reservedInstanceSupportedLocationsForIaas	array	Gets or sets the list of Azure locations supporting Reserved Instances for IAAS.
reservedInstanceSupportedOffers	array	Gets or sets the list of offers supported for Reserved Instances.
reservedInstanceVmFamilies	array	Gets the Reserved Instance VM Families list.
savingsPlanSupportedLocations	array	Gets or sets the list of Azure locations supporting Saving Plans for IAAS.
savingsPlanSupportedLocationsForPaas	array	Gets or sets the list of Azure locations supporting Saving Plans for PAAS.
savingsPlanSupportedOffers	array	Gets or sets the list of Azure Offers supporting Saving Plans.
savingsPlanVmFamilies	array	Gets or sets the Premium disk VM Families list.
sqlSkus	array	Gets or sets the list of SQL target SKU properties for dropdowns.
supportedOffers	array	Gets or sets the list of offers supported for SQL assessments.
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".
vmFamilies	array	Gets the list of VM families.

list_by_assessment_project

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.
premiumDiskVmFamilies	array	Gets the Premium disk VM Families list.
reservedInstanceSqlTargets	array	Gets or sets the Reserved Instance SQL target types.
reservedInstanceSupportedCurrencies	array	Gets or sets the list of currencies supported for Reserved Instances.
reservedInstanceSupportedLocations	array	Gets or sets the list of Azure locations supporting Reserved Instances.
reservedInstanceSupportedLocationsForIaas	array	Gets or sets the list of Azure locations supporting Reserved Instances for IAAS.
reservedInstanceSupportedOffers	array	Gets or sets the list of offers supported for Reserved Instances.
reservedInstanceVmFamilies	array	Gets the Reserved Instance VM Families list.
savingsPlanSupportedLocations	array	Gets or sets the list of Azure locations supporting Saving Plans for IAAS.
savingsPlanSupportedLocationsForPaas	array	Gets or sets the list of Azure locations supporting Saving Plans for PAAS.
savingsPlanSupportedOffers	array	Gets or sets the list of Azure Offers supporting Saving Plans.
savingsPlanVmFamilies	array	Gets or sets the Premium disk VM Families list.
sqlSkus	array	Gets or sets the list of SQL target SKU properties for dropdowns.
supportedOffers	array	Gets or sets the list of offers supported for SQL assessments.
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".
vmFamilies	array	Gets the list of VM families.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resource_group_name, project_name, assessment_options_name, subscription_id		Get a SqlAssessmentOptions.
list_by_assessment_project	select	resource_group_name, project_name, subscription_id		List SqlAssessmentOptions resources by AssessmentProject.

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_options_name	string	Sql assessment options ARM name. Accepted values is 'default'. 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

SELECT examples

get

Get a SqlAssessmentOptions.

SELECT
id,
name,
premiumDiskVmFamilies,
reservedInstanceSqlTargets,
reservedInstanceSupportedCurrencies,
reservedInstanceSupportedLocations,
reservedInstanceSupportedLocationsForIaas,
reservedInstanceSupportedOffers,
reservedInstanceVmFamilies,
savingsPlanSupportedLocations,
savingsPlanSupportedLocationsForPaas,
savingsPlanSupportedOffers,
savingsPlanVmFamilies,
sqlSkus,
supportedOffers,
systemData,
type,
vmFamilies
FROM azure.migration_assessment.sql_assessment_options_operations
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND project_name = '{{ project_name }}' -- required
AND assessment_options_name = '{{ assessment_options_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_assessment_project

List SqlAssessmentOptions resources by AssessmentProject.

SELECT
id,
name,
premiumDiskVmFamilies,
reservedInstanceSqlTargets,
reservedInstanceSupportedCurrencies,
reservedInstanceSupportedLocations,
reservedInstanceSupportedLocationsForIaas,
reservedInstanceSupportedOffers,
reservedInstanceVmFamilies,
savingsPlanSupportedLocations,
savingsPlanSupportedLocationsForPaas,
savingsPlanSupportedOffers,
savingsPlanVmFamilies,
sqlSkus,
supportedOffers,
systemData,
type,
vmFamilies
FROM azure.migration_assessment.sql_assessment_options_operations
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND project_name = '{{ project_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;