07-18-2019 05:00 PM
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, ,,,,,
07-18-2019 10:11 PM
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
07-19-2019 12:49 AM - edited 07-19-2019 06:41 AM
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