Hello,
This looks like a very useful little script. Could you send it to me as an
attachment (to avoid the line wraps in email)? I will then add it to the
examples directory. I'd recommend you add your name as the author as it is
nice to get credit for what you did, and if you want feedback, you could add
your email address.
On Monday 14 November 2005 10:21, Andrew J. Millar wrote:
> Hi all
>
> I just thought I'd share this with you as you may find it useful. My
> managers wanted to receive a summary email of the previous nights
> backups which contained only basic information of the status of the
> backups, and they wanted this all in one email. As far as I can tell,
> there is no way to get just a summary report from bacula its self
> (forgive me if I am wrong), so I wrote a little script to produce the
> summary.
>
> For this script to work, I have all of the bacula report mails cc'd to a
> local account on the bacula server (strangely enough, the account is
> called 'bacula'). This script then runs at the end of the last backup,
> summarises all of the report mails in to one email, then empties the
> mailbox.
>
> I have only used this script with bacula-1.38.0 - previous versions
> *may* have slightly different report mails on which my script will not
> work, but I'm sure just a little tweaking of my script will fix that.
>
> Here it is:
>
> -------------------------------------
> #!/bin/sh
> # This script is to create a summary of the job notifications from
> bacula
> # and send it to people who care.
> # Tested with bacula-1.38.0
>
> # Use awk to create the report, pass to column to be
> # formatted nicely, then on to mail to be sent to
> # port who care.
> awk -F\:\ 'BEGIN {
> print "Client Status Type StartTime EndTime Files Bytes"
> }
> /Client/ {
> CLIENT=$2; sub(/"/, "", CLIENT) ; sub(/".*$/, "",
> CLIENT)
> }
> /Backup Level/ {
> TYPE=$2 ; sub(/,.*$/, "", TYPE)} /Start time/
> {STARTTIME=$2; sub(/.*-.*-.* /, "", STARTTIME)
> }
> /End time/ {
> ENDTIME=$2; sub(/.*-.*-.* /, "", ENDTIME)
> }
> /SD Files Written/ {
> SDFILES=$2} /SD Bytes Written/ {SDBYTES=$2
> }
> /Termination/ {
> TERMINATION=$2 ;sub(/Backup/, "", TERMINATION) ;
> printf "%s %s %s %s %s %s %s \n",
> CLIENT,TERMINATION,TYPE,STARTTIME,ENDTIME,SDFILES,SDBYTES
> }' /var/spool/mail/bacula | \
> column -t |
> mail -s "Bacula Summary for `date -d yesterday +%a,\ %D`"
> [EMAIL PROTECTED]
> # Empty the mailbox
> cat /dev/null > /var/spool/mail/bacula
> # That's all folks.
> -------------------------------------
>
> The output of the report looks like:
>
> Client Status Type StartTime EndTime Files Bytes
> server1 OK Differential 23:56:02 00:11:02 12,458
> 1,951,197,803
> server2 OK Differential 23:19:46 00:13:20 233
> 28,612,022,635
> server3 OK Differential 00:11:04 00:21:31 5,134
> 732,374,476
> server4 OK Differential 00:21:34 00:21:44 491
> 34,332,329
> server5 OK Differential 00:21:47 00:25:56 75
> 636,753,005
> server6 OK Differential 00:13:22 00:26:10 9,232
> 4,011,694,684
>
> Regards
>
> Andrew
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server.
> Download it for free - -and be entered to win a 42" plasma tv or your very
> own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Best regards,
Kern
(">
/\
V_V
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
