Skip to content

aws.discovery.list_server_neighbors

Example SQL Queries

SELECT * FROM
aws.discovery.list_server_neighbors
WHERE
"configuration_id" = 'VALUE';

Description

Retrieves a list of servers that are one network hop away from a specified server.

Table Definition

Column NameColumn Data Type
configuration_id Required Input Column

Configuration ID of the server for which neighbors are being listed.

VARCHAR
max_results Input Column

Maximum number of results to return in a single page of output.

BIGINT
neighbor_configuration_ids Input Column

List of configuration IDs to test for one-hop-away.

VARCHAR[]
Show child fields
neighbor_configuration_ids[]
next_token Input Column

Token to retrieve the next set of results. For example, if you specified 100 IDs for ListServerNeighborsRequest$neighborConfigurationIds but set ListServerNeighborsRequest$maxResults to 10, you received a set of 10 results along with this token. Use this token in the next query to retrieve the next set of 10.

VARCHAR
port_information_needed Input Column

Flag to indicate if port and protocol information is needed as part of the response.

BOOLEAN
_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
known_dependency_count

Count of distinct servers that are one hop away from the given server.

BIGINT
neighbors

List of distinct servers that are one hop away from the given server.

STRUCT(
"source_server_id" VARCHAR,
"destination_server_id" VARCHAR,
"destination_port" BIGINT,
"transport_protocol" VARCHAR,
"connections_count" BIGINT
)[]
Show child fields
neighbors[]
Show child fields
neighbors[].connections_count

The number of open network connections with the neighboring server.

neighbors[].destination_port

The destination network port for the connection.

neighbors[].destination_server_id

The ID of the server that accepted the network connection.

neighbors[].source_server_id

The ID of the server that opened the network connection.

neighbors[].transport_protocol

The network protocol used for the connection.