finding route53 records with names that match 'pdu' and formatting them into prometheus file sd json format.

README

aws route53 list-resource-record-sets --hosted-zone-id ZPIEHXTK3ZPMR | jq '.ResourceRecordSets' > ls.lsst.org.json
aws route53 list-resource-record-sets --hosted-zone-id Z2CCXZLXGUUYM5 | jq '.ResourceRecordSets' > cp.lsst.org.json
./r53_to_file_sd.rb ls.lsst.org.json cp.lsst.org.json > /home/jhoblitt/github/k8s-cookbook/fleet/lib/snmp-exporter-pre/files/sd/dev/snmp-raritan-pdu.json

r53_to_file_sd.rb

#!/bin/env ruby

require 'json'

files = ARGV

file_sd_config = []

files.each do |file|
  dns = JSON.parse(File.read(file))

  dns.each do |record|
    name = record['Name']
    next unless name =~ /pdu/

    # trim tailing dot from record name
    name = name.gsub!(/\.$/, '')

    file_sd_config << {
      'labels' => {
        '__meta_hostname' => name,
      },
      'targets' => [record['ResourceRecords'].first['Value']],
    }
  end
end

puts JSON.pretty_generate(file_sd_config.sort_by { |h| h['labels']['__meta_hostname'] })