aws cli describe instance scripts

describe instaces of a given Service tag

aws ec2 describe-instances --filters "Name=tag:Service,Values=marketplace-esclus" | jq '.Reservations[].Instances[] | "\(.PrivateIpAddress) , \(.EbsOptimized) , \(.SubnetId) , \(.Placement.AvailabilityZone) , \(.Tags[]| select(.Key == "Hostname") | .Value) , \(.InstanceType)"'

echo "10.0.6.194" | xargs -n1 -I {} sh -c "aws ec2 describe-instances --filters \"Name=network-interface.addresses.private-ip-address,Values={}\" | jq '.Reservations[].Instances[] | \"\(.PrivateIpAddress),\(.Tags[] | select(.Key==\"Service\") | .Value), \(.Tags[] | select(.Key==\"Hostname\") | .Value)\"' | sed 's/\"//g'"

find dbs connected to a server

netstat -alnt | awk '{print $5}' | grep "^10.*:3306$" | sed 's/:3306//g' | sort | uniq | xargs -I {} sh -c "aws ec2 describe-instances --filters "Name=network-interface.addresses.private-ip-address,Values={}" | jq '.Reservations[].Instances[] | \"\(.PrivateIpAddress) , \(.EbsOptimized) , \(.SubnetId) , \(.Placement.AvailabilityZone) , \(.Tags[]| select(.Key == \"Hostname\") | .Value) , \(.InstanceType)\"'"

###find instances with given tags

aws ec2 describe-instances --filters "Name=tag:Techteam,Values=mall-cart" "Name=tag:Role,Values=redis" --region ap-south-1 | jq '.Reservations[].Instances[] | "\(.PrivateIpAddress),\(.Tags[]| select(.Key == "Hostname") | .Value) "'

cat ip.txt | sudo xargs -I {} aws ec2 describe-instances --filter Name=private-ip-address,Values={} --region ap-south-1 | jq --arg tag1 "Service" --arg tag2 "Team" '.Reservations[].Instances[] | "\(.PrivateIpAddress) , \(.Tags[]| select(.Key==$tag1) | .Value) "'

aws ec2 describe-instances --filters "Name=tag:Name,Values=xxx" "Name=tag:env,Values=dev"