How to get a list of all public IPs and their instance names on Amazon EC2

Question

Anyone know how to get a list of all public IPs and their instance names on Amazon EC2 using aws CLI?

This got me the list of public IPs, but not their associated instance names. aws ec2 describe-instances --query "Reservations[].Instances[].PublicIpAddress" --output text

Thanks in advance.

aws ec2 describe-instances --query "Reservations[].Instances[].Tags[].[Key,Value]" gives the name of the instance and other tags, but how do I give just the Name tag, and also the public IP? — sho, Sep 16 '14 at 01:04
possible duplicate of [How do I get a simple list of my public IP addresses](http://stackoverflow.com/questions/24938971/how-do-i-get-a-simple-list-of-my-public-ip-addresses) — Bas Peeters, Nov 04 '14 at 10:59

chris · Answer 1 · 2017-01-03T16:55:50.203

9

http://docs.aws.amazon.com/cli/latest/userguide/controlling-output.html

Update: The CLI now supports filters:

aws ec2 describe-instances --query "Reservations[].Instances[].[PublicIpAddress,InstanceId,Tags[?Key=='Name'].Value]"

edited Jan 03 '17 at 16:55

answered Sep 16 '14 at 00:33

chris

36,094
53
157
237

That got me the instance ID and Public IP, but I need the Tag with the Name of the instance. – sho Sep 16 '14 at 00:38

score 5 · Answer 2 · edited Sep 20 '16 at 20:19

5

Got it working using this:

aws ec2 describe-instances --output table   --query 'Reservations[].Instances[].[Tags[?Key==`Name`] | [0].Value, PublicIpAddress]'

edited Sep 20 '16 at 20:19

Piyush Patil

14,512
6
35
54

answered Sep 16 '14 at 01:22

sho

439
2
7
13

score 0 · Answer 3 · edited Dec 04 '18 at 02:00

Adding this for folks that will commonly find this post when searching for how to get your instance info.

In powershell you can use the following:

(Get-EC2Instance -ProfileName Profile).Instances | select InstanceId,PrivateIPAddress,PublicIpAddress @{Name="Servername";
Expression={$_.tags | where key -eq "Name" | select Value -expand Value}} | Format-Table.

With the Python AWS CLI you can use:

aws ec2 describe-instances --region=us-east-1 --query 'Reservations[*].Instances[*].[InstanceId,Tags[?Key==`Name`].Value|[0],PrivateIpAddress,PublicIpAddress]' --output text  --profile ProfileName

How to get a list of all public IPs and their instance names on Amazon EC2

3 Answers3

Linked