How to pull this NBU report together?

[C_J_Hund]

Hi all,

I need to pull a report together that shows the following 4 fields:

Client name
IP Address of client
Date of last backup
Status of last backup

There's probably no way to gather that with one command, is there?  I bet bpdbjobs will give me some of this information.  I'm not sure how to dig out a client's IP address, though.  Any insight is greatly appreciated.

Sincere thanks,
C.J.

[CY]

You might want to try NOM for it  :)

[CY]

As far as IP address, I think you can add this in your shell script:

for Client_name in `cat /tmp/nbu_client_list`
do
         nslookup $Client_name  | grep Address | grep -v DNS_server_address | awk '{print $2}'
done

Hope this helps. :)

[FrSchind]

you can either run a bpdbjobs command and filter for the client, or generate a list with the backup_exit_notify script on your master server. just add something like

echo `date` $5 > /var/tmp/backupstatus/$1

this will give you a file named like the client under /var/tmp/backupstatus/ with the date and status of the backup. Now you can combine the script from CY with a cat on this file and you get the information you requested.

[C_J_Hund]

Very helpful.  Thank you very much!