puppetdb event report shell function

puppetdb_report.sh

# req: brew/yum install jq on MacOS X/Linux (install in .bashrc or global profile.d/)
export PUPPETDB_HOST="my.puppetdb.host.foo"
function puppet_report { curl -sG http://$PUPPETDB_HOST/v3/events --data-urlencode "query=[\"and\", [\"=\", \"latest-report?\", true],[\"~\", \"certname\", \"^$1\"]]" | jq -r '.[] | .certname+","+.["resource-type"]+"["+.["resource-title"]+"]" + "," +.status + "," + .message' | column -t -s,; }
export -f puppet_report

$ puppet_report www01
www01.foo.bar  Exec[foo]                    success  executed successfully
www01.foo.bar  Service[httpd]             success  ensure changed 'stopped' to 'running'