cancel
Showing results for 
Search instead for 
Did you mean: 

bpdbjobs doesn't show the date and time in right format

itchamp111
Level 2

none of the field below shows the date and time in correct format. Could someone please help me understand how to print the report with standard timestamp?

C:\Program Files\Veritas\NetBackup\bin>bpdbjobs -report -most_columns
56,17,3,1,,,,,1563493688,0000000002,1563493690,,1,,,,,100,15628,root,,,,,,mylaptop1,,,,,,0,0,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,
55,0,3,0,serverbackup,Full,mylaptop1,1563493628,0000000058,1563493686,testvol3,1,,187,5,,100,12176,root,0,0,0,0,other,mylaptop1,2,2,0,,,0,0,55,5,,,,,,,,,,,0,,,1,0,0,mylaptop1_1563493628,,,0,0, ,,,,,
54,17,3,0,,,,,1563487842,0000000004,1563487846,,1,,,,,100,9852,root,,,,,,mylaptop1,,,,,,0,0,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,
53,17,3,1,,,,,1563487223,0000000002,1563487225,,1,,,,,100,15792,root,,,,,,mylaptop1,,,,,,0,0,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,
52,0,3,71,myfirstbackup,Differential-Inc,mylaptop2,mylaptop1,1563487202,0000000646,1563487848,testvol3,2,,,,,100,17268,root,1,0,1,0,root,mylaptop1,2,2,0,,,0,0,52,,,,,,,,,,,,0,,,1,0,0,mylaptop2_1563487820,,,0,0, ,,,,,
51,0,3,2074,test1,Full,mylaptop2, ,1563487202,0000000602,1563487804, ,2,,,,,100,,root,1,0,0,0,root,mylaptop1,2,2,0,,,0,0,51,,,,,,,,,,,,,,,1,0,0,,,,0,, ,,,,,
50,0,3,0,serverbackup,Full,mylaptop1,1563455789,0000000061,1563455850,testvol3,1,,187,5,,100,26380,root,0,0,0,0,other,mylaptop1,2,2,0,,,0,0,50,4,,,,,,,,,,,0,,,1,0,0,mylaptop1_1563455789,,,0,0, ,,,,,

2 REPLIES 2

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Hi,

This is the start, duration, and end times in unix time.

1563493688,0000000002,1563493690

Thursday, July 18, 2019 11:48:08 PM, 

Thursday, July 18, 2019 11:48:10 PM

Please note these times would be localized to my timezone.

You can cconvert the unixtime to normal time using NetBackup

C:\Program Files\VERITAS\NetBackup\bin>bpdbm -ctime 1563493688

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@itchamp111 

bpdbjobs is best used in scripting where you extract relevant fields.

If you are looking for a simple, readable backup status report, rather try bperror:
bperror -backstat -U
This will show backup status for last 24 hours. 
You can add more parameters for custom period:
-d start-date -e end-date
or
-hoursago hours