首页 > 解决方案 > AWS CLI 查询 IF 条件

问题描述

我可以获得有关在 cli 表输出中获取别名记录的值的帮助吗?

test.emea.example.com。是别名。

顺便说一句,如果 DNS 记录是多值的,如何扁平化和连接值

下面是示例:

 $ 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           |
+----------------------------------+----+-----------------+

标签: aws-clijson-query

解决方案


基于 John 和 Alex 的想法,我使用 union 以及 join 函数来获得我想要的东西。但是,它太冗长了。

$ 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                                             |
+-----------------------------+----+------------------------------------------------------------------------------------+

推荐阅读