AWS - Discover Down VPN Connections

gistfile1.txt

# List all of the VPN connections on an account where both tunnels are in a DOWN state.

# CSV format
aws ec2 describe-vpn-connections | jq -r '.VpnConnections[] | select ((.VgwTelemetry[0].Status == "DOWN") and (.VgwTelemetry[1].Status == "DOWN")) | [(.Tags[] | select(.Key == "Name") | .Value), .VpnConnectionId, .CustomerGatewayId, .VgwTelemetry[].LastStatusChange] | @csv'

# JSON format for additional processing
aws ec2 describe-vpn-connections | jq -r '.VpnConnections[] | select ((.VgwTelemetry[0].Status == "DOWN") and (.VgwTelemetry[1].Status == "DOWN")) | { Name: (.Tags[] | select(.Key == "Name") | .Value), VpnConnectionId: .VpnConnectionId, CustomerGatewayId: .CustomerGatewayId, LastStatusChange0: .VgwTelemetry[0].LastStatusChange, LastStatusChange1: .VgwTelemetry[1].LastStatusChange}'