Karl,

You might want to take a test drive of APTARE StorageConsole, the Web
Based SRM Management and Reporting Tool with cutting edge historical
reporting, real-time dashboards and future forecasting and analysis.

The feature which immediately came to mind when reading your posting is
the Job Detail Report. This report provides a great deal of information
on any running, queued, successful, or failed job in your environment.

The Job Detail provides all the information you would like to see ("
KB/Sec | PATHNAME_OF_THE_STREAM | ELASPSED_TIME_COMPLETED| KB_BACKEDUP |
STATUS | POLICY | CLIENT") in an extremely readable format. 

Furthermore, the job detail provides: the pathnames of all related
streams for the job if multistreaming was enabled, details of each
attempt, links to policy and schedule data, and much more.

This is just one report selected from a broad array of powerful reports
supported by APTARE StorageConsole which have been developed to relieve
the pain of users of Backup and Restore products such as Veritas
NetBackup.

If you or anyone else would simply like a demo login to our
demonstration portal, just send an email to demo AT aptare DOT com with "demo
account" in the subject heading.

If you're curious to find out more about the tool, take a look at
http://www.aptare.com/software.


Best Regards,

Josh Collins 

-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of
Karl.Rossing AT Federated DOT CA
Sent: Tuesday, April 13, 2004 4:03 PM
To: 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: [Veritas-bu] Uggg... bpdbjobs -all_columns



BPDBJOBS_COLDEFS is great for writting small report on netbackup 5.0 

The one thing it doesn't give me is the pathname of the stream, which
would
be usefully for me to track filesystem growth on a daily basis. 

bpdbjobs -all_columns is usefull since it give me the information i
require.
However it isn't in a very usable format  I'm after feild 33. 

I took a look at the netbackup faq on
http://www.backupcentral.com/cgi-bin/netbackup-fom?_highlightWords=perl&;
file
=194 

if i try 

 bpdbjobs -report -all_columns |awk -F',' '{print $33}' 

awk complains that the file is too long. 

it seems that in order to get the PATHNAME of the STREAM i got lern
perl. 

does anyone have a script that spits out something like this 
KB/Sec | PATHNAME_OF_THE_STREAM | ELASPSED_TIME_COMPLETED| KB_BACKEDUP |
STATUS | POLICY | CLIENT