Netbackup output using bperror

[demo4119]

Im trying to configure a script to mail out the mentioned report daily on a solaris master server .

can i use bperror command to do the below mentioned layout ?

CLIENT NAME                 START_TIME                  END_TIME                       KILOBYTES                       SUCCESSFUL RATE

------------------     ------------------     ------------------     --------------------     ------------------

[RiaanBadenhorst]

Hi,

You can use bpdbjobs to extract the information you require. This command actually prints an output of what is shown the GUI (activity monitor). Check the note and pull out the fields that you require.

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

[demo4119]

thanks will try it  

[RiaanBadenhorst]

any luck?

[demo4119]

Thanks we have some luck and manage to get the expected layout .

but still have some issues as below.

But there is 2 things to be fix by further customization :

1. The start time and end time output is not human readable format(eg: 1311146159), we need to convert it to human readable format.

2. Output alignment might be running out.

[Andy_Welburn]

1. Use bpdbm -ctime

# bpdbm -ctime 1311146159
1311146159 = Wed Jul 20 08:15:59 2011

2. "Output alignment might be running out" - can you clarify?

[demo4119]

Example when the client name character is long that the default  , it will not display in the output.

[Andy_Welburn]

Thought it 'expanded' to suit the size of the client name - there were issues in older versions that resulted in job-ids etc being truncated, but....

I presume you're not manipulating the output of bpdbjobs & it's that manipulation that's truncating the client name?

It is possible to use BPDBJOBS_COLDEFS entries in bp.conf to format the output of bpdbjobs, maybe worth playing with them?

BPDBJOBS_COLDEFS bp.conf entries for UNIX servers
http://www.symantec.com/business/support/index?page=content&id=HOWTO33188

[demo4119]

thanks will try with it.

[Andy_Welburn]

you say it "won't display at all"?

Is it actually the parent of a multi-streamed job? There is an additional option to bpdbjobs "-ignore_parent_jobs"   ...   just a thought.

[demo4119]

it display only partially if the length of the characher is longer than the default .