#bash - February 2020

@Hemanth has joined the channel

set the channel description: A channel for bash scripting

@Adam Crews has joined the channel

@Erik Osterman (Cloud Posse) has joined the channel

@Tyrone Meijn has joined the channel

@Hemanth any burning bash questions?

@Jeremy G has joined the channel

@Andriy Knysh (Cloud Posse) has joined the channel

@Ievgenii Shepeliuk has joined the channel

@Erik Osterman (Cloud Posse) haha yes 😄

I am trying to do some sorting stuff, my output is like (those are aws instance IDs)

Instance-BCD222
19.5140495 
12.7219977 
13.3188209
Instance-OIUQWE
Instance-QOWIEU
Instance-QOWIEU
Instance-BCD123
19.5140495 
12.7219977 
13.3188209
Instance-QOWIEU
Instance-QWOEIU
Instance-ASLDKJ
Instance-BCD231
19.5140495 
12.7219977 
13.3188209

I want to remove those instances Id's in that list that doesn't have numbers under them

Oh, I think this is stemming from an earlier question that involved jq?

yes

Since jq is so powerful, better to share that part again.

trying to work my way through

sure

It may be easier to get the query right rather than offload it to bash.

yes i am amazed at jq

Yea, it's awesome

@bradym has joined the channel

@Kendall Link has joined the channel

@Chris Fowles has joined the channel

@erik-stephens has joined the channel

@Tertius Stander has joined the channel

@MorganGeek has joined the channel

@Hemanth try this:

for i in $(aws ec2 describe-instances  | jq -r '.["Reservations"]|.[]|.Instances|.[]| .InstanceId' | sort -n); do echo "$i,$(aws cloudwatch get-metric-statistics --metric-name CPUUtilization --start-time 2020-02-20T12:00:00 --end-time 2020-02-20T13:00:00 --period 60 --namespace AWS/EC2  --extended-statistics p80 --dimensions Name=InstanceId,Value=$i | jq -r '[.Datapoints[]|select(.ExtendedStatistics.p80 >=0).ExtendedStatistics.p80] | @csv')" | grep -v ',$'; done