#!/bin/bash

# Generate a JSON encoded list of the OCA account instances in the billingsnapshot table
echo '{"data":['
mysql -NB <<-EOD ocacommon | sed -e '$ s/,$//'
        SELECT DISTINCT CONCAT('  {"{#OCAACCOUNTCODE}":"', AccountCode, '", "{#OCAACCOUNTNAME}":"', TRIM(LEADING 'oca_' FROM AccountCode), '"},') FROM zabbixmetriclog WHERE SnapshotDate >= CURDATE() - INTERVAL 1 DAY
EOD
echo "]}"
