Determining what storage unit a class is being backed up to

[johngiggs]

I created a script using /usr/openv/netbackup/bin/admincmd/bpdbjobs -report and awk to filter the report to fit my needs, however not all classes will show up on the report as they have not all been run recently. Is there a command or a way I can extract this information from Veritas? The format I am looking to create is shown below. The formatting is not a problem, it's just that I don't know what command to use to get the data I'm looking for.

Client Backup Name Backup Server
=========================================================
ServerA servera_backup Backup_Server_1
ServerB serverb_backup Backup_Server_2
ServerC serverc_backup Backup_Server_1
ServerD serverd_backup Backup_Server_1
ServerE servere_backup Backup_Server_2

Any help would be greatly appreciated.

Thanks,

John

 

[bswip]

I have a script that you can use called ebs_report. You can find this on my web site

http://www.gurski.com/Netbackup

in the Unix area. The report it produces is something like this

Completed Backups since 12/21/2003 starting at 19:00

Client Type Status MediaSvr Start_Time End_Time Elapsed Kilobytes Files

aceaix1s Diff 0 ebsmaster 12/22/2003 00:11:57 12/22/2003 00:31:43 00:19:46 953607 681
aceaix2s Diff 0 ebsmaster 12/22/2003 00:11:57 12/22/2003 00:17:34 00:05:37 95867 73
amsaix1d Diff 0 ebsmaster 12/22/2003 00:12:00 12/22/2003 00:28:26 00:16:26 545994 116
amsaix1s Diff 0 ebsmaster 12/22/2003 00:12:03 12/22/2003 01:11:01 00:58:58 2132645 474
amsaix2s Diff 0 ebsmaster 12/22/2003 00:12:03 12/22/2003 01:02:06 00:50:03 3017894 374
amsnt2s Diff 1 ebsmedia2 12/22/2003 01:01:33 12/22/2003 01:50:18 00:48:45 5887043 2341
amsswn01p Diff 0 ebsmedia2 12/22/2003 01:01:33 12/22/2003 01:10:17 00:08:44 675489 2597
backdraft1 Diff 0 ebsmaster 12/22/2003 02:11:30 12/22/2003 02:16:57 00:05:27 1206677 54
backdraft2 Diff 0 ebsmaster 12/22/2003 02:11:30 12/22/2003 02:16:37 00:05:07 1211903 63


The only variable you need to supply is the number of hours from the current time that you want the report. I run this as a cron so I can safely put in a variable like 18 to specify 18 hours ago.

If you have any questions, just let me know.....

 

[ksetia]

Hi bswip,

This is what we got when running the script:

Completed Backups since 02/11/2004 starting at 1:00

Client Type Status MediaSvr Start_Time End_Time Elapsed Kilobytes Files

brooklyn UNKN 196 1077296436 01/01/1970 12:29:51 // 299254:00:27
solano80 UNKN 150 1077307865 01/01/1970 14:21:28 // 299259:02:33

 

[bswip]

What version of Netbackup are you using? This script is being run on a Solaris server and NB 4.5 FP5