Veritas support reps usually won't support you on this, but I have been 
able to get this
much out of them ;-)

jobid,jobtype,state,status,class,schedule, client, server, started, elapsed,
ended, stunit, try, operation, kbytes, files, pathlastwritten, percent,
jobpid, owner, subtype, classtype, schedule_type, priority, group,
masterserver, retentionunits, retentionperiod, compression,
kbyteslastwritten, fileslastwritten, filelistcount, [files]..., trycount,
[trypid, trystunit, tryserver, trystarted, tryelapsed, tryended, trystatus,
trystatusdescription, trystatuscount, [trystatuslines]..., trybyteswritten,
tryfileswritten]

Unfortunately, a lot of the information is given in numeric codes (jobtype 
is one example) that
is translated into english by the jobmonitor and the normal bpdbjobs 
-report format.  The bitch
is having to translate those codes yourself to make sense of what you have.

The following perl fragment shows how to perform a basic parsing using the 
above order:

   open(BPDBJOBS,"bpdbjobs -report -all_columns|");
   while(<BPDBJOBS>) {
     my($jobid,$jobtype,$state,$status,$class,$schedule,$client,$server,
        $started,$elapsed,$ended,$stunit,$try,$operation,$kilobytes,$files,
        $path,$percent,$jobpid,$owner)
     = split(/,/);
     my($record) = {
       "jobid" => "$jobid",
       "jobtype" => "$jobtype",
       "state" => "$state",
       "status" => "$status",
       "class" => "$class",
       "schedule" => "$schedule",
       "client" => "$client",
       "server" => "$server",
       "started" => "$started",
       "elapsed" => "$elapsed",
       "ended" => "$ended",
       "stunit" => "$stunit",
       "try" => "$try",
       "operation" => "$operation",
       "kilobytes" => "$kilobytes",
       "files" => "$files",
       "path" => "$path",
       "percent" => "$percent",
       "jobpid" => "$jobpid",
       "owner" => "$owner",
     };

What I wouldn't give to see the Veritas source code....

--PLB

At 08:36 AM 03/07/2001 -0800, David A. Chapa wrote:
>Ah yes, but then we get into the meaning of the
>columns...I used to have this, but unfortunately lost
>this info somehow (it must be on a backup somewhere).
>
>Quoting "Peter L. Buschman" <plb AT iotk DOT com>:
>
> >
> > Or my personal favorite:
> >
> > bpdbjobs -report -all_columns
> >
> > This has the advantage of giving you the information
>in comma delimited
> > format which is better for
> > script parsing.  The normal whitespace separators are
>impossible to parse
> > since NetBackup leaves
> > many fields blank if the information isn't
>available.  At least with
> > comma-delimited form, you can parse
> > a null field.
> >
> > --PLB
> >
> > At 08:23 AM 03/07/2001 -0800, David A. Chapa wrote:
> > >/usr/openv/netbackup/bin/admincmd/bpdbjobs -report
> > >
> > >should give you the results you are looking for.
> > >
> > >david
> > >
> > >Quoting olaf_behnke AT de.schindler DOT com:
> > >
> > > >
> > > > Hi all,
> > > > xbpmon has the option "View-Print List" to create
>an
> > >ascii file containing
> > > > all jobs xbpmon is showing.
> > > > Is there an command-line program, which can
>create a
> > >similiar file? I want
> > > > to create a joblist-file within an script.
> > > > Thanks in advance.
> > > > Regards
> > > > Olaf
> > > >
> > > > Olaf Behnke
> > > > Schindler Deutschland Holding GmbH
> > > >
> > > > _______________________________________________
> > > > Veritas-bu maillist  -  Veritas-
> > >bu AT mailman.eng.auburn DOT edu
> > > >
> >
> >http://mailman.eng.auburn.edu/mailman/listinfo/veritas-
> > >bu
> > > >
> > >
> > >
> > >
> > ><><><><><><><><><><><><><><><><><><><><>
> > >David A. Chapa
> > >Consulting Manager
> > >DataStaff, Inc.
> > >847 413 1144
> > >http://www.consulting.datastaff.com
> > >---------------------------------------
> > >NBU-LSERV AT datastaff DOT com - Adv. Scripting
> > >_______________________________________________
> > >Veritas-bu maillist  -  Veritas-
>bu AT mailman.eng.auburn DOT edu
> >
> >http://mailman.eng.auburn.edu/mailman/listinfo/veritas-
>bu
> >
> >
>
>
>
><><><><><><><><><><><><><><><><><><><><>
>David A. Chapa
>Consulting Manager
>DataStaff, Inc.
>847 413 1144
>http://www.consulting.datastaff.com
>---------------------------------------
>NBU-LSERV AT datastaff DOT com - Adv. Scripting
>_______________________________________________
>Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
>http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu