pms_get_devicelist

#!/bin/sh

SCRIPT_DIR=`dirname $0`
if [ -f "${SCRIPT_DIR}/pms_tool.conf" ]; then
    . "${SCRIPT_DIR}/pms_tool.conf"
else
    echo "no pms_tool.conf."
    exit 1
fi

sudo "$PSQL" -U $DBUSER -h "$DBHOST" $DBNAME \
 -c "select id,\"DeviceName\",\"SerialNumber\" from devices order by id;"