bpimagelist / bperror output

[unknown123]

Hi

I need to get information about backups on the following items:
Client
policy
start time
elapsed time
finish time
kbytes
files
schedule
retention
Media Server

All of these can be obtained with the bpimagelist command except for Media Server. However this can be found using bperror. The problem that I'm having is that there isn't a good way of matching information between the two of them. The primary identifier for bpimagelist is backupid. The primary identifier for bperror is job id. I tried to use the start time but it is very often different between the two commands.

If any one knows a way that I can find all of these items or has any insight at all I would appreciate the help.

 

[Stumpr]

have you tried bpdbjobs?

Bob Stump
VERITAS - "Ain't it the truth?"

 

[unknown123]

Looks like bpdbjobs will help greatly if I could get a job_id from bpimagelist or a backupid from bpdbjobs then my problem would be solved. Is this possible?

 

[Stumpr]

DESCRIPTION
bpdbjobs interacts with the jobs database and is useful in
scripts or as a command line administration tool. Use
bpdbjobs to print the entire jobs database, print a summary,
delete done jobs, cancel uncompleted jobs, and clean old
jobs.

It is possible to customize the output of bpdbjobs by adding
column definition entries (BPDBJOBS_COLDEFS) in the bp.conf
file. For more information about the bp.conf file and a com-
plete list of the definitions and the BPDBJOBS_COLDEFS
entries, refer to the NetBackup System Administrator's
Guide, Volume II.

This command can be executed by authorized users. For more
information about NetBackup authorization, refer to
"Enhanced Authorization and Authentication" in the NetBackup
System Administrator's Guide.

OPTIONS
-all_columns
Summary displays all columns. Some of the more

SunOS 5.9 Last change: 05 Jul 2003 1

Maintenance Commands bpdbjobs(1M)

useful fields of this command are:

field2 = jobtype (0=backup, 1=archive, 2=restore,
3=verify, 4=duplication, 5=import, 6=dbbackup,
7=vault)

field3 = state (0=queued, 1=active, 2=requeued,
3=done)

field5 = policy (The policy that this job is
associated with.)

field6 = schedule (The schedule that this job is
associated with.)

field21 = subtype (0=immediate, 1=scheduled,
2=user-initiated)

field24 = priority (The priority assigned to this
job, as configured in the policy attributes.)

The output of this command consists of a single
line, per backup job. Each line of the output is
a comma-delimited list in the following format:

jobid,jobtype,state,status,class,schedule,client,server,started,elapsed,ended,stunit,try
on,kbytes,files,pathlastwritten,percent,jobpid,owner,subtype,classtype,schedule_type,priority
asterserver,retentionunits,retentionperiod,compression,kbyteslastwritten,fileslastwritten,fil
nt,[files]...,trycount,[trypid,trystunit,tryserver,trystarted,tryelapsed,tryended,trystatus,t
description,trystatuscount,[trystatuslines]...,trybyteswritten,tryfileswritten]...



Bob Stump
VERITAS - "Ain't it the truth?"

 

[unknown123]

That solved it for me. Thanks for your help Bob!