Skip to main content

applications

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

Overview

Nameapplications
TypeResource
Idaws.mgn.applications

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringApplication name. (pattern: <code>[^\s\x00]( [^\s\x00])</code>)
application_aggregated_statusobjectApplication aggregated status.
application_idstringApplication ID. (pattern: <code>app-[0-9a-zA-Z]{17}</code>)
arnstringApplication ARN.
creation_date_timestringApplication creation dateTime. (pattern: <code>[1-9][0-9]*-(0[1-9]|1[0-2])-(0[1-9]|[12][0-9]|3[01])T([0-1][0-9]|2[0-3]):[0-5][0-9]:[0-5][0-9](.[0-9]+)?Z</code>)
descriptionstringApplication description. (pattern: <code>[^\x00]*</code>)
is_archivedbooleanApplication archival status.
last_modified_date_timestringApplication last modified dateTime. (pattern: <code>[1-9][0-9]*-(0[1-9]|1[0-2])-(0[1-9]|[12][0-9]|3[01])T([0-1][0-9]|2[0-3]):[0-5][0-9]:[0-5][0-9](.[0-9]+)?Z</code>)
tagsobjectApplication tags.
wave_idstringApplication wave ID. (pattern: <code>wave-[0-9a-zA-Z]{17}</code>)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_applicationsselectregionRetrieves all applications or multiple applications by ID.
create_applicationinsertregion, nameCreate application.
associate_applicationsupdateregion, waveID, applicationIDsAssociate applications to wave.
update_applicationupdateregion, applicationIDUpdate application.
delete_applicationdeleteregionDelete application.
archive_applicationexecregion, applicationIDArchive application.
disassociate_applicationsexecregion, waveID, applicationIDsDisassociate applications from wave.
unarchive_applicationexecregion, applicationIDUnarchive application.

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
regionstringAWS region (default: us-east-1)

SELECT examples

Retrieves all applications or multiple applications by ID.

SELECT
name,
application_aggregated_status,
application_id,
arn,
creation_date_time,
description,
is_archived,
last_modified_date_time,
tags,
wave_id
FROM aws.mgn.applications
WHERE region = '{{ region }}' -- required
;

INSERT examples

Create application.

INSERT INTO aws.mgn.applications (
name,
description,
tags,
accountID,
region
)
SELECT
'{{ name }}' /* required */,
'{{ description }}',
'{{ tags }}',
'{{ accountID }}',
'{{ region }}'
RETURNING
name,
application_aggregated_status,
application_id,
arn,
creation_date_time,
description,
is_archived,
last_modified_date_time,
tags,
wave_id
;

UPDATE examples

Associate applications to wave.

UPDATE aws.mgn.applications
SET
waveID = '{{ waveID }}',
applicationIDs = '{{ applicationIDs }}',
accountID = '{{ accountID }}'
WHERE
region = '{{ region }}' --required
AND waveID = '{{ waveID }}' --required
AND applicationIDs = '{{ applicationIDs }}' --required;

DELETE examples

Delete application.

DELETE FROM aws.mgn.applications
WHERE region = '{{ region }}' --required
;

Lifecycle Methods

Archive application.

EXEC aws.mgn.applications.archive_application
@region='{{ region }}' --required
@@json=
'{
"applicationID": "{{ applicationID }}",
"accountID": "{{ accountID }}"
}'
;