-
-
Save palashkulsh/1814bde610b2455de1ccf4b24af63aee to your computer and use it in GitHub Desktop.
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)"' |
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"
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'"