What is the one command that can give me ALL of the information about a backup job?

This Wiki is brought to you by Backup Central, where you can find the Mr. Backup Blog, Forums, and a mailing list for each forum!
Backup FAQs	Service Providers	Backup Software	Backup Hardware	Backup Book Wiki	Free Stuff	Miscellaneous

netbackup/bin/admincmd/bpdbjobs -report -all_columns

The output is a nasty list of comma separated values that contain EVERYTHING about each job in the jobs database. Here's the list of parameters you get:

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

This is run from a master server or media server.

(or in a pinch from a client that happens to be defined as a SERVER in the master's bp.conf) In order to run it from a client, you need to: 1. Copy bpdbjobs and xbpmon.cat to the client

  (It needs to be copied from a server of the same platform, or "borrowed"
   from the CD for that platform.)

2. List the client as a server in the server's bp.conf file. 3. Remember that this is neither documented nor supported, AND

  it is certainly a questionable licensing practice, and may not work
  once they fully turn on the license manager.  (It works for 3.4.)
  Right now, the license manager doesn't count the number of servers you have.

I personally wish that Veritas would allow this command to be run from the client. It is a very useful command. Caveat - beware of commas in filenames.

Jeff Boleman