aws cli iterate through opensearch domains, get info, export to CSV

get-opensearch-info.sh

#!/bin/bash


#export AWS_PAGER="";
# for i in $(aws opensearch list-domain-names |jq -r '.DomainNames[].DomainName')
# do
# aws opensearch describe-domains --domain-name $i --query 'DomainStatusList[*].[EngineVersion,ClusterConfig.InstanceType,ClusterConfig.InstanceCount,EBSOptions.VolumeType,EBSOptions.VolumeSize]'
# done

export AWS_PAGER=""
for i in $(aws opensearch list-domain-names |jq -r '.DomainNames[].DomainName'|tr '\n' ' ')
do
    aws opensearch describe-domains --domain-name $i --query 'DomainStatusList[*].[DomainId,EngineVersion,ClusterConfig.InstanceType,ClusterConfig.InstanceCount,ClusterConfig.DedicatedMasterEnabled,ClusterConfig.DedicatedMasterType,ClusterConfig.DedicatedMasterCount,ClusterConfig.DedicatedMasterCount,EBSOptions.VolumeType,EBSOptions.VolumeSize]' |jq -r '.[] | @csv' >> /tmp/test.csv
done