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/

feita há um ano1382 visualizações
2 Respostas
1
Resposta aceita

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
respondido há um ano
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.

respondido há um ano

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas