Understand ADS Database in Athena

To explore agent discovered data directly in Athena

1. In the Migration Hub navigation pane, choose Servers.

2. Click on the Explore data in Amazon Athena link.

Explore Athena

3. You will be taken to the Amazon Athena console where you will see:

  • The Query Editor window
  • In the navigation pane:
    • Database listbox which will have the default database pre-listed as application_discovery_service_database
    • Tables list consisting of seven tables representing the data sets grouped by the agents:
      • os_info_agent
      • network_interface_agent
      • sys_performance_agent
      • processes_agent
      • inbound_connection_agent
      • outbound_connection_agent
      • id_mapping_agent

Athena DB

4. You are now ready to query the data in the Amazon Athena console by writing and running your own SQL queries in the Athena Query Editor to analyze details about your on-premises servers.

In the next section you will find a set of predefined queries of typical use cases, such as TCO analysis and network visualization. You can use these queries as-is or modify them to suit your needs.

Simply expand the query you want to use and follow these instructions:

To use a predefined query

1. In the Migration Hub navigation pane, choose Servers.

2. Choose the Explore data in Amazon Athena link to be taken to your data in the Athena console.

3. Athena will request you to setup a result location in Amazon S3 before running the first query. Open S3 console. There will be one existing bucket with name starting with aws-application-discovery-service-*. Click on “set up a query result location in Amazon S3”. Use the existing bucket as the Athena bucket.

The bucket name needs to be on the following format: s3://<bucket_name>/. This is just an example and can not be used on your environment: s3://aws-application-discovery-service-abcdefghij123/

OBS: Please remember to add a slash symbol “/“ after the bucket name.

4. Expand one of the predefined queries listed below and copy it.

5. Place your cursor in Athena’s Query Editor window and paste the query.

6. Choose Run Query.

Run Query