Skip to content

aws.tnb.get_sol_network_operation

Example SQL Queries

SELECT * FROM
aws.tnb.get_sol_network_operation
WHERE
"ns_lcm_op_occ_id" = 'VALUE';

Description

Gets the details of a network operation, including the tasks involved in the network operation and the status of the tasks.

A network operation is any operation that is done to your network, such as network instance instantiation or termination.

Table Definition

Column NameColumn Data Type
ns_lcm_op_occ_id Required Input Column

The identifier of the network operation.

VARCHAR
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
arn

Network operation ARN.

VARCHAR
error

Error related to this specific network operation occurrence.

STRUCT(
"detail" VARCHAR,
"title" VARCHAR
)
Show child fields
error.detail

A human-readable explanation specific to this occurrence of the problem.

error.title

A human-readable title of the problem type.

id

ID of this network operation occurrence.

VARCHAR
lcm_operation_type

Type of the operation represented by this occurrence.

VARCHAR
metadata

Metadata of this network operation occurrence.

STRUCT(
"created_at" TIMESTAMP_S,
"instantiate_metadata" STRUCT(
"additional_params_for_ns" VARCHAR,
"nsd_info_id" VARCHAR
),
"last_modified" TIMESTAMP_S,
"modify_vnf_info_metadata" STRUCT(
"vnf_configurable_properties" VARCHAR,
"vnf_instance_id" VARCHAR
),
"update_ns_metadata" STRUCT(
"additional_params_for_ns" VARCHAR,
"nsd_info_id" VARCHAR
)
)
Show child fields
metadata.created_at

The date that the resource was created.

metadata.instantiate_metadata

Metadata related to the network operation occurrence for network instantiation. This is populated only if the lcmOperationType is INSTANTIATE.

Show child fields
metadata.instantiate_metadata.additional_params_for_ns

The configurable properties used during instantiation.

metadata.instantiate_metadata.nsd_info_id

The network service descriptor used for instantiating the network instance.

metadata.last_modified

The date that the resource was last modified.

metadata.modify_vnf_info_metadata

Metadata related to the network operation occurrence for network function updates in a network instance. This is populated only if the lcmOperationType is UPDATE and the updateType is MODIFY_VNF_INFORMATION.

Show child fields
metadata.modify_vnf_info_metadata.vnf_configurable_properties

The configurable properties used during update of the network function instance.

metadata.modify_vnf_info_metadata.vnf_instance_id

The network function instance that was updated in the network instance.

metadata.update_ns_metadata

Metadata related to the network operation occurrence for network instance updates. This is populated only if the lcmOperationType is UPDATE and the updateType is UPDATE_NS.

Show child fields
metadata.update_ns_metadata.additional_params_for_ns

The configurable properties used during update.

metadata.update_ns_metadata.nsd_info_id

The network service descriptor used for updating the network instance.

ns_instance_id

ID of the network operation instance.

VARCHAR
operation_state

The state of the network operation.

VARCHAR
tags

A tag is a label that you assign to an Amazon Web Services resource. Each tag consists of a key and an optional value. You can use tags to search and filter your resources or track your Amazon Web Services costs.

MAP(VARCHAR, VARCHAR)
tasks

All tasks associated with this operation occurrence.

STRUCT(
"task_context" MAP(VARCHAR, VARCHAR),
"task_end_time" TIMESTAMP_S,
"task_error_details" STRUCT(
"cause" VARCHAR,
"details" VARCHAR
),
"task_name" VARCHAR,
"task_start_time" TIMESTAMP_S,
"task_status" VARCHAR
)[]
Show child fields
tasks[]
Show child fields
tasks[].task_context

Context for the network operation task.

tasks[].task_end_time

Task end time.

tasks[].task_error_details

Task error details.

Show child fields
tasks[].task_error_details.cause

Error cause.

tasks[].task_error_details.details

Error details.

tasks[].task_name

Task name.

tasks[].task_start_time

Task start time.

tasks[].task_status

Task status.

update_type

Type of the update. Only present if the network operation lcmOperationType is UPDATE.

VARCHAR