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/

demandé il y a un an1382 vues
2 réponses
1
Réponse acceptée

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
répondu il y a un an
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.

répondu il y a un an

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions