Starttime , ENDtime entries - BPDBJOBS_COLDEFS

[Raju_la]

Hello,

  we are in process of creating script for client active backup sessions which are running long time so basically i am looking for starttime column defication entries in bp.conf ( like below ) that way i get those details from bpdbjobs command.

BPDBJOBS_COLDEFS = JOBID 7 true
BPDBJOBS_COLDEFS = BACKUPTYPE 8 true
BPDBJOBS_COLDEFS = CLIENT 8 true
BPDBJOBS_COLDEFS = SCHEDULE 8 true
BPDBJOBS_COLDEFS = STATE 8 true
BPDBJOBS_COLDEFS = DSTMEDIA_SERVER 8 true
BPDBJOBS_COLDEFS = DSTSTORAGE_UNIT 8 true
BPDBJOBS_COLDEFS = POLICY 9 true
 

thank you in advance.

[Raju_la]

here i attach the Interface image

[watsons]

Not really sure what you're trying to achieve, but below is the list of available BPDBJOBS_COLDEFS you can use in bp.conf:

http://www.symantec.com/docs/HOWTO33188

If you're after the (long) duration, look for ELAPSED & ACTIVEELAPSED

[Raju_la]

i am just looking to get the start time feild which u can see my screenshot attachment  through my bpdbjobs  CLI commnad.  So my question is what is the

BPDBJOBS_COLDEFS   entry in bp.conf

[watsons]

BPDBJOBS_COLDEFS is for you to customize on your bpdbjobs output, such as which column comes first in the listing and the column width, it's more about formatting.

If you just want to get start_time, time_elapsed, and end_date, you can refer to:

http://www.symantec.com/docs/HOWTO72644

So basically from a bpdbjobs command output each entry (job) you look at field #9, #10 & #11.

See my example:

5956,20,3,0,policy1,Open,,client1,1381762955,0000000422,1381763377,.....

1381762955 is the start timestamp, you can make it readable by doing "bpdbm -ctime 1381762955".

Note that field #11 (end time) = #9 (start time) + #10 (time_elapsed).

Hope it helps.