CODEWITHSUNDEEP
aws-clijson-query
Tiger peng
Tiger peng

Reputation: 747

AWS CLI Query IF condition

Could I get help on getting the values of Alias record in the cli table output?

The test.emea.example.com. is an alias.

BTW, if the DNS record is multi-value, how to flat and concatenate the values

Below is the example:

 $ aws route53 list-resource-record-sets --hosted-zone-id Z34XXXXXXXX4EF --query "ResourceRecordSets[?Type=='A']"
[
    {
        "ResourceRecords": [
            {
                "Value": "10.189.134.12"
            }
        ], 
        "Type": "A", 
        "Name": "dnsforwarder0.emea.example.com.", 
        "TTL": 300
    }, 
    {
        "ResourceRecords": [
            {
                "Value": "10.189.134.47"
            }
        ], 
        "Type": "A", 
        "Name": "dnsforwarder1.emea.example.com.", 
        "TTL": 300
    }, 
    {
        "ResourceRecords": [
            {
                "Value": "10.189.134.78"
            }
        ], 
        "Type": "A", 
        "Name": "dnsforwarder2.emea.example.com.", 
        "TTL": 300
    }, 
    {
        "AliasTarget": {
            "HostedZoneId": "Z32O12XQLNTSW2", 
            "EvaluateTargetHealth": false, 
            "DNSName": "dualstack.kubernetes-elb-k8fca-prod-emea-1745420721.eu-west-1.elb.amazonaws.com."
        }, 
        "Type": "A", 
        "Name": "test.emea.example.com."
    }
]
[Tiger-Pengs-MacBook-Pro:~/aws/aws_fed]
tpeng $ aws route53 list-resource-record-sets --hosted-zone-id Z34XXXXXXXX4EF --query "ResourceRecordSets[?Type=='A'].[Name,Type,ResourceRecords[0].Value]" --output table --color off 
-----------------------------------------------------------
|                 ListResourceRecordSets                  |
+----------------------------------+----+-----------------+
|  dnsforwarder0.emea.example.com. |  A |  10.189.134.12  |
|  dnsforwarder1.emea.example.com. |  A |  10.189.134.47  |
|  dnsforwarder2.emea.example.com. |  A |  10.189.134.78  |
|  test.emea.example.com.          |  A |  None           |
+----------------------------------+----+-----------------+

Upvotes: 1

Views: 3065

Answers (2)

Tiger peng
Tiger peng

Reputation: 747

Based on John and Alex's idea, I use the union, as well as join function, to get what I want. However, it is too verbose.

$ aws route53 list-resource-record-sets --hosted-zone-id Z34XXXXXXXX4EF --query "[ResourceRecordSets[?Type=='A' && contains(keys(@), 'AliasTarget')].[Name,Type,AliasTarget.DNSName],ResourceRecordSets[?Type=='A' && contains(keys(@), 'ResourceRecords')].[Name,Type,join(', ', ResourceRecords[].Value)]]" --output table
-------------------------------------------------------------------------------------------------------------------------
|                                              ListResourceRecordSets                                                   |
+-----------------------------+----+------------------------------------------------------------------------------------+
|  test.example.com.          |  A |  dualstack.kubernetes-elb-k8fca-prod-emea-1745420721.eu-west-1.elb.amazonaws.com.  |
|  dnsforwarder0.example.com. |  A |  10.189.134.12                                                                     |
|  dnsforwarder1.example.com. |  A |  10.189.134.47                                                                     |
|  dnsforwarder2.example.com. |  A |  10.189.134.78                                                                     |
|  privatezone.example.com.   |  A |  10.20.30.40, 10.10.30.40, 10.30.30.40                                             |
+-----------------------------+----+------------------------------------------------------------------------------------+

Upvotes: 2

Alex Harvey
Alex Harvey

Reputation: 15472

You can do this by combining a JMESpath And expression with the keys and contains functions. So this would work:

aws route53 list-resource-record-sets --hosted-zone-id Z34XXXXXXXX4EF \
  --query 'ResourceRecordSets[?Type==`A` && contains(keys(@), `AliasTarget`)].Name'

Upvotes: 0

Related Questions