steampipe plugin install aws

Table: aws_mgn_application - Query AWS Migration Service Applications using SQL

The AWS Migration Service (MGN) is designed to minimize downtime during migration. It allows you to quickly lift and shift applications to AWS with minimal changes, enabling rapid migration. The 'application' in AWS MGN represents a group of servers in a single application, which can be migrated together to AWS.

Table Usage Guide

The aws_mgn_application table in Steampipe provides you with information about applications within AWS Migration Service. This table allows you, as a DevOps engineer, to query application-specific details, such as application status, associated servers, and lifecycle details. You can utilize this table to gather insights on applications, such as their current lifecycle state, last updated time, and associated server IDs. The schema outlines the various attributes of the Migration Service application for you, including the application ID, lifecycle, and associated tags.

Examples

Basic Info

Explore the basic information of your AWS Migration (MGN) applications to identify their archival status, creation dates, and associated tags. This can help in assessing the current state of your applications and in planning any requisite migration waves.

select
name,
arn,
application_id,
creation_date_time,
is_archived,
wave_id,
tags
from
aws_mgn_application;
select
name,
arn,
application_id,
creation_date_time,
is_archived,
wave_id,
tags
from
aws_mgn_application;

List archived applications

Identify instances where applications have been archived within the AWS Migration Service. This is useful for maintaining a clean and organized application environment by keeping track of archived applications.

select
name,
arn,
application_id,
creation_date_time,
is_archived
from
aws_mgn_application
where
is_archived;
select
name,
arn,
application_id,
creation_date_time,
is_archived
from
aws_mgn_application
where
is_archived = 1;

Get aggregated status details for an application

Explore the health and progress status of an application along with the total number of source servers. This can be useful in assessing the overall performance and progress of an application, and in identifying potential issues related to server resources.

select
name,
application_id,
application_aggregated_status ->> 'HealthStatus' as health_status,
application_aggregated_status ->> 'ProgressStatus' as progress_status,
application_aggregated_status ->> 'TotalSourceServers' as total_source_servers
from
aws_mgn_application;
select
name,
application_id,
json_extract(application_aggregated_status, '$.HealthStatus') as health_status,
json_extract(application_aggregated_status, '$.ProgressStatus') as progress_status,
json_extract(
application_aggregated_status,
'$.TotalSourceServers'
) as total_source_servers
from
aws_mgn_application;

List applications older than 30 days

Explore which applications have been in existence for more than 30 days. This can be useful in understanding the longevity of applications and their usage patterns over time.

select
name,
application_id,
creation_date_time,
is_archived,
wave_id
from
aws_mgn_application
where
creation_date_time >= now() - interval '30' day;
select
name,
application_id,
creation_date_time,
is_archived,
wave_id
from
aws_mgn_application
where
creation_date_time >= datetime('now', '-30 days');

Schema for aws_mgn_application

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
application_aggregated_statusjsonbApplication aggregated status.
application_idtext=Application ID.
arntextThe Amazon Resource Name (ARN) of the application.
creation_date_timetimestamp with time zoneApplication creation dateTime.
descriptiontextApplication description.
is_archivedboolean=, !=Application archival status.
last_modified_date_timetimestamp with time zoneApplication last modified dateTime.
nametextApplication name.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
tagsjsonbA list of tags attached to the application.
titletextTitle of the resource.
wave_idtext=Application wave ID.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_mgn_application