Skip to content

aws.discovery.get_discovery_summary

Example SQL Queries

SELECT * FROM
aws.discovery.get_discovery_summary;

Description

Retrieves a short summary of discovered assets.

This API operation takes no request parameters and is called as is at the command prompt as shown in the example.

Table Definition

Column NameColumn Data Type
_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
agent_summary

Details about discovered agents, including agent status and health.

STRUCT(
"active_agents" BIGINT,
"healthy_agents" BIGINT,
"black_listed_agents" BIGINT,
"shutdown_agents" BIGINT,
"unhealthy_agents" BIGINT,
"total_agents" BIGINT,
"unknown_agents" BIGINT
)
Show child fields
agent_summary.active_agents

Number of active discovery agents.

agent_summary.black_listed_agents

Number of blacklisted discovery agents.

agent_summary.healthy_agents

Number of healthy discovery agents

agent_summary.shutdown_agents

Number of discovery agents with status SHUTDOWN.

agent_summary.total_agents

Total number of discovery agents.

agent_summary.unhealthy_agents

Number of unhealthy discovery agents.

agent_summary.unknown_agents

Number of unknown discovery agents.

agentless_collector_summary

Details about Agentless Collector collectors, including status.

STRUCT(
"active_agentless_collectors" BIGINT,
"healthy_agentless_collectors" BIGINT,
"deny_listed_agentless_collectors" BIGINT,
"shutdown_agentless_collectors" BIGINT,
"unhealthy_agentless_collectors" BIGINT,
"total_agentless_collectors" BIGINT,
"unknown_agentless_collectors" BIGINT
)
Show child fields
agentless_collector_summary.active_agentless_collectors

The number of active Agentless Collector collectors.

agentless_collector_summary.deny_listed_agentless_collectors

The number of deny-listed Agentless Collector collectors.

agentless_collector_summary.healthy_agentless_collectors

The number of healthy Agentless Collector collectors.

agentless_collector_summary.shutdown_agentless_collectors

The number of Agentless Collector collectors with SHUTDOWN status.

agentless_collector_summary.total_agentless_collectors

The total number of Agentless Collector collectors.

agentless_collector_summary.unhealthy_agentless_collectors

The number of unhealthy Agentless Collector collectors.

agentless_collector_summary.unknown_agentless_collectors

The number of unknown Agentless Collector collectors.

applications

The number of applications discovered.

BIGINT
connector_summary

Details about discovered connectors, including connector status and health.

STRUCT(
"active_connectors" BIGINT,
"healthy_connectors" BIGINT,
"black_listed_connectors" BIGINT,
"shutdown_connectors" BIGINT,
"unhealthy_connectors" BIGINT,
"total_connectors" BIGINT,
"unknown_connectors" BIGINT
)
Show child fields
connector_summary.active_connectors

Number of active discovery connectors.

connector_summary.black_listed_connectors

Number of blacklisted discovery connectors.

connector_summary.healthy_connectors

Number of healthy discovery connectors.

connector_summary.shutdown_connectors

Number of discovery connectors with status SHUTDOWN,

connector_summary.total_connectors

Total number of discovery connectors.

connector_summary.unhealthy_connectors

Number of unhealthy discovery connectors.

connector_summary.unknown_connectors

Number of unknown discovery connectors.

me_collector_summary

Details about Migration Evaluator collectors, including collector status and health.

STRUCT(
"active_me_collectors" BIGINT,
"healthy_me_collectors" BIGINT,
"deny_listed_me_collectors" BIGINT,
"shutdown_me_collectors" BIGINT,
"unhealthy_me_collectors" BIGINT,
"total_me_collectors" BIGINT,
"unknown_me_collectors" BIGINT
)
Show child fields
me_collector_summary.active_me_collectors

The number of active Migration Evaluator collectors.

me_collector_summary.deny_listed_me_collectors

The number of deny-listed Migration Evaluator collectors.

me_collector_summary.healthy_me_collectors

The number of healthy Migration Evaluator collectors.

me_collector_summary.shutdown_me_collectors

The number of Migration Evaluator collectors with SHUTDOWN status.

me_collector_summary.total_me_collectors

The total number of Migration Evaluator collectors.

me_collector_summary.unhealthy_me_collectors

The number of unhealthy Migration Evaluator collectors.

me_collector_summary.unknown_me_collectors

The number of unknown Migration Evaluator collectors.

servers

The number of servers discovered.

BIGINT
servers_mapped_to_applications

The number of servers mapped to applications.

BIGINT
servers_mappedto_tags

The number of servers mapped to tags.

BIGINT