I am looking to tidy up a response from aws ec2 cli. Basically want to get a list of ec2 instances terminated because of lack of spot capacity.
aws ec2 describe-instances
--filters Name=instance-lifecycle,Values=spot Name=instance-state-name,Values=terminated Name=state-reason-code,Values=Server.SpotInstanceTermination
--query 'Reservations[].Instances[].[StateTransitionReason, Tags[?Key==`Name`].Value[]]']
This results in:
[
[
"i-XXXXXXXX",
"Service initiated (2024-07-08 10:55:08 GMT)",
[
"ec2-main"
]
]
]
Ideally I’d like it to appear
i-XXXXXXXX, Service initiated (2024-07-08 10:55:08 GMT), ec2-main
Is this possible?