How I can modify output of "bpdbjobs" on NBU 4.5(on version 3.4 can use "bpdjobs -report -format file nameoffile.txt")

This Wiki is brought to you by Backup Central, where you can find the Mr. Backup Blog, Forums, and a mailing list for each forum!
Backup FAQs	Service Providers	Backup Software	Backup Hardware	Backup Book Wiki	Free Stuff	Miscellaneous

If you're running 4.5 you can control the columns in bpdbjobs (not -all_columns) by using BPDBJOBS_COLDEFS entries in bp.conf. Format:

 BPDBJOBS_COLDEFS = <thing> <width> <autosize>

where width is width of field if autosize is 'false'.

These are the defaults:

 BPDBJOBS_COLDEFS = JOBID 5 true
 BPDBJOBS_COLDEFS = TYPE 4 true
 BPDBJOBS_COLDEFS = STATE 5 true
 BPDBJOBS_COLDEFS = STATUS 6 true
 BPDBJOBS_COLDEFS = POLICY 6 true
 BPDBJOBS_COLDEFS = SCHEDULE 8 true
 BPDBJOBS_COLDEFS = CLIENT 6 true
 BPDBJOBS_COLDEFS = DSTMEDIA_SERVER 12 true
 BPDBJOBS_COLDEFS = ACTPID 10 true

And these are the possible values for 'thing'. I don't know what they all are. Maybe this will provide a better tool than trying to parse -all_columns manually.

 ACTIVEELAPSED
 ACTPID
 CLIENT
 COMPLETION
 COMPRESSION
 DSTMEDIAID
 DSTMEDIA_SERVER
 DSTSTORAGE_UNIT
 ELAPSED
 ENDED
 ESTFILE
 ESTKB
 FILES
 GROUP
 JOBID
 JOBSTVERSION
 KBPERSEC
 KILOBYTES
 LASTBACKUP
 MAINPID
 NUMTAPESEJECT
 OPERATION
 OWNER
 PARENTJOBID
 PATHNAME
 POLICY
 POLICYTYPE
 PRIORITY
 PRODUCT
 PROFILE
 RETENTION
 ROBOT
 RQSTPID
 SCHEDULE
 SCHEDULETYPE
 SESSIONID
 SRCMEDIAID
 SRCMEDIA_SERVER
 SRCSTORAGE_UNIT
 STARTED
 STATE
 STATUS
 STREAMNUMBER
 TRY
 TYPECKUPTYPE
 VAULT
 VERSION