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/

gefragt vor einem Jahr1382 Aufrufe
2 Antworten
1
Akzeptierte Antwort

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
beantwortet vor einem Jahr
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.

beantwortet vor einem Jahr

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen