Skip to content

Instantly share code, notes, and snippets.

@FlorianHeigl
Created April 23, 2019 01:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save FlorianHeigl/0b41941b60fccd16045418355ec95a76 to your computer and use it in GitHub Desktop.
Save FlorianHeigl/0b41941b60fccd16045418355ec95a76 to your computer and use it in GitHub Desktop.
update fuer bastis plugin
#!/bin/sh
echo "<<<bacula_jobs:sep(9)>>>"
echo "Select JobId, Name, JobStatus, EndTime FROM Job WHERE EndTime BETWEEN NOW() - interval '30 days' AND NOW();" | sudo -u postgres psql --tuples-only bacula bacula
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment