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

Question

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](/media/postImages/original/IMfFCV_WIvSfeQmAhLxXxrfw)

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

Accepted Answer

Unfortunately both of these properties are nested structures which can't be unpacked by Config queries at this time. That's [documented here](https://docs.aws.amazon.com/config/latest/developerguide/querying-AWS-resources.html) under the **Limitations** section.
> * No support for nested structures (such as tags) to be unpacked with SQL queries.

Answer

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.

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

Relevant content