steampipe plugin install oci

Table: oci_application_migration_source - Query OCI Application Migration Sources using SQL

Oracle Cloud Infrastructure's Application Migration service helps you migrate applications from any environment to Oracle Cloud Infrastructure. It simplifies the migration process, reduces downtime, and ensures that your applications are migrated with minimal disruption. This service is beneficial for those who want to take advantage of Oracle Cloud Infrastructure's benefits without the hassle of manually migrating their applications.

Table Usage Guide

The oci_application_migration_source table provides insights into the sources within Oracle Cloud Infrastructure's Application Migration service. As a Cloud engineer, explore source-specific details through this table, including the source type, lifecycle state, and associated metadata. Utilize it to uncover information about sources, such as those in different lifecycle states, the type of sources, and the verification of source details.

Examples

Basic info

Explore the basic information of your migration sources in Oracle Cloud Infrastructure (OCI) to understand their current lifecycle state and source details. This can be useful for tracking the status and origin of your migration sources, aiding in effective resource management and migration planning.

select
id,
display_name,
description,
lifecycle_details,
lifecycle_state as state,
source_details ->> 'computeAccount' as source_account_name,
source_details ->> 'region' as source_account_region,
source_details ->> 'type' as source_account_type
from
oci_application_migration_source;
select
id,
display_name,
description,
lifecycle_details,
lifecycle_state as state,
json_extract(source_details, '$.computeAccount') as source_account_name,
json_extract(source_details, '$.region') as source_account_region,
json_extract(source_details, '$.type') as source_account_type
from
oci_application_migration_source;

List all inactive sources

Discover the segments that are not currently active in your application migration process. This can be useful for identifying potential issues or bottlenecks, allowing you to optimize the migration process.

select
id,
display_name,
description,
lifecycle_details,
lifecycle_state as state,
source_details ->> 'computeAccount' as source_account_name,
source_details ->> 'region' as source_account_region,
source_details ->> 'type' as source_account_type
from
oci_application_migration_source
where
lifecycle_state <> 'ACTIVE';
select
id,
display_name,
description,
lifecycle_details,
lifecycle_state as state,
json_extract(source_details, '$.computeAccount') as source_account_name,
json_extract(source_details, '$.region') as source_account_region,
json_extract(source_details, '$.type') as source_account_type
from
oci_application_migration_source
where
lifecycle_state <> 'ACTIVE';

List all sources created in the last 30 days

Explore which sources have been created in the last 30 days to better manage and understand the status of your application migration. This allows for efficient tracking of newly added sources, essential for maintaining an updated and secure application environment.

select
id,
display_name,
description,
lifecycle_details,
lifecycle_state as state,
source_details ->> 'computeAccount' as source_account_name,
source_details ->> 'region' as source_account_region,
source_details ->> 'type' as source_account_type
from
oci_application_migration_source
where
time_created >= now() - interval '30' day;
select
id,
display_name,
description,
lifecycle_details,
lifecycle_state as state,
json_extract(source_details, '$.computeAccount') as source_account_name,
json_extract(source_details, '$.region') as source_account_region,
json_extract(source_details, '$.type') as source_account_type
from
oci_application_migration_source
where
time_created >= datetime('now', '-30 day');

List all migrations under a particular source

Explore which migrations are associated with a specific source in order to manage and track application migration processes. This is particularly useful for identifying the state and details of migrations, aiding in the organization and monitoring of migration tasks.

select
s.id as source_id,
s.display_name as source_name,
m.id as migration_id,
m.display_name as migration_name,
m.lifecycle_details,
m.lifecycle_state as state
from
oci_application_migration_source as s,
oci_application_migration_migration as m
where
s.id = m.source_id
and s.display_name = 'source-1';
select
s.id as source_id,
s.display_name as source_name,
m.id as migration_id,
m.display_name as migration_name,
m.lifecycle_details,
m.lifecycle_state as state
from
oci_application_migration_source as s,
oci_application_migration_migration as m
where
s.id = m.source_id
and s.display_name = 'source-1';

Schema for oci_application_migration_source

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
compartment_idtext=The OCID of the compartment in Tenant in which the resource is located.
defined_tagsjsonbDefined tags for this resource. Each key is predefined and scoped to a namespace.
descriptiontextDescription of the source. This helps you to identify the appropriate source environment when you have multiple sources defined.
display_nametext=Name of the source. This helps you to identify the appropriate source environment when you have multiple sources defined.
freeform_tagsjsonbFree-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace.
idtext=The OCID (https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the source.
lifecycle_detailstextDetails about the current lifecycle state of the source.
lifecycle_statetext=The current state of the source.
source_detailsjsonbDetails of the source.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tagsjsonbA map of tags for the resource.
tenant_idtext=, !=, ~~, ~~*, !~~, !~~*The OCID of the Tenant in which the resource is located.
time_createdtimestamp with time zoneTime that Source was created.
titletextTitle of the resource.
typejsonbType of the source.

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)" -- oci

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

steampipe_export_oci --config '<your_config>' oci_application_migration_source