Skip to main content

assessment_projects_operations

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

Overview

Nameassessment_projects_operations
TypeResource
Idazure.migration_assessment.assessment_projects_operations

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. # pylint: disable=line-too-long
namestringThe name of the resource.
assessmentSolutionIdstringAssessment solution ARM id tracked by Microsoft.Migrate/migrateProjects.
createdTimestampstring (date-time)Time when this project was created. Date-Time represented in ISO-8601 format.
customerStorageAccountArmIdstringThe ARM id of the storage account used for interactions when public access is disabled.
customerWorkspaceIdstringThe ARM id of service map workspace created by customer.
customerWorkspaceLocationstringLocation of service map workspace created by customer.
locationstringThe geo-location where the resource lives. Required.
privateEndpointConnectionsarrayThe list of private endpoint connections to the project.
projectStatusstringAssessment project status. Known values are: "Active" and "Inactive".
provisioningStatestringThe status of the last operation. Known values are: "Succeeded", "Failed", "Canceled", "Provisioning", "Updating", "Deleting", and "Accepted".
publicNetworkAccessstringThis value can be set to 'enabled' to avoid breaking changes on existing customer resources and templates. If set to 'disabled', traffic over public interface is not allowed, and private endpoint connections would be the exclusive access method.
serviceEndpointstringEndpoint at which the collector agent can call agent REST API.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
updatedTimestampstring (date-time)Time when this project was last updated. Date-Time represented in ISO-8601 format.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, project_name, subscription_idGet a AssessmentProject.
list_by_resource_groupselectresource_group_name, subscription_idList AssessmentProject resources by resource group.
list_by_subscriptionselectsubscription_idList AssessmentProject resources by subscription ID.
createinsertresource_group_name, project_name, subscription_id, locationCreate a AssessmentProject.
updateupdateresource_group_name, project_name, subscription_idUpdate a AssessmentProject.
deletedeleteresource_group_name, project_name, subscription_idDelete a 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.

NameDatatypeDescription
project_namestringAssessment Project Name. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Get a AssessmentProject.

SELECT
id,
name,
assessmentSolutionId,
createdTimestamp,
customerStorageAccountArmId,
customerWorkspaceId,
customerWorkspaceLocation,
location,
privateEndpointConnections,
projectStatus,
provisioningState,
publicNetworkAccess,
serviceEndpoint,
systemData,
tags,
type,
updatedTimestamp
FROM azure.migration_assessment.assessment_projects_operations
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND project_name = '{{ project_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a AssessmentProject.

INSERT INTO azure.migration_assessment.assessment_projects_operations (
tags,
location,
properties,
resource_group_name,
project_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ resource_group_name }}',
'{{ project_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;

UPDATE examples

Update a AssessmentProject.

UPDATE azure.migration_assessment.assessment_projects_operations
SET
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND project_name = '{{ project_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

DELETE examples

Delete a AssessmentProject.

DELETE FROM azure.migration_assessment.assessment_projects_operations
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND project_name = '{{ project_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;