AWS Config Query Editor - Retrieve EC2 Instance Name and Network Interface Id

0

Hi all,

Tricky one here, but seems possible.

I am attempting to create an AWS EC2 inventory csv file across our AWS Organization. Requirements are to include the EC2 Instance Name and the ENI Network Interface Id's. Using the AWS Config Query editor appears to be the fastest method in a multi-account Organization.

Here is my query so far:

SELECT
  resourceId,
  resourceName,
  resourceType,
  accountId,
  configuration.instanceType,
  configuration.state.name,
  tags,
  configuration.networkInterfaces,
  configuration.publicIp,
  configuration.privateIpAddress
WHERE
  resourceType = 'AWS::EC2::Instance'
  AND configuration.state.name = 'running'

Questions:

  1. How can I get the tags.key "Name" property to display in the output?
  2. How can I get the configuration.networkInterfaces "networkInterfaceId" property to display in the output?

Screenshot attached for reference illustrating the problem. Enter image description here

Here is a link for reference. https://www.virtualbonzo.com/2022/08/08/a-quick-and-easy-ec2-inventory-using-aws-config/

質問済み 1年前1383ビュー
2回答
1
承認された回答

Unfortunately both of these properties are nested structures which can't be unpacked by Config queries at this time. That's documented here under the Limitations section.

  • No support for nested structures (such as tags) to be unpacked with SQL queries.
AWS
zsewell
回答済み 1年前
1

Ahh, thank you. It was buried under the documentation. ...And AWS really needs to populate the resourceName field with the hostname value. That is essential info.

回答済み 1年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ