Forum Discussion

Dan_Szuberla's avatar
Dan_Szuberla
Level 3
19 years ago
Solved

client backup report

I'm seeking a commandline option for Client Backup Report in the gui.

i need a comma or tab delimited command that will yield the following:

Client name, Kilobytes backed up, backup date, backup time (time started), schedule name, elapsed time, policy

i'd like to run the command per 24 hours from 5pm to 5pm


i've tried
bpimagelist -U -d 11/01/06 17:00:00 -e 11/02/06 17:00:00

bpdbjobs -report -all_columns

but neither of these provide the columns i need.. I'd be happy with an output of all the columns provided in Client Backups Report. as i can just filter the unneeded columns.
7.1.x and Earlier
Backup and Recovery
NetBackup
  • sdo's avatar
    sdo
    19 years ago
    Hi Dan,

    The following has been tested using a Windows 2000 Pro SP4 NBU ES Remote Admin Console v5.1 MP3aS2 querying a Windows 2000 Server Sp4 NBU ES Master Server v5.1 MP3aS2.

    Basically, create a BPDBJOBS_COLDEFS registry multi_sz value to contain the required column definitions, and then just run "bpdbjobs -report".

    In more detail:
    1) Start / Run / regedt32 (do not use regedit, as you can't create reg_multi_sz values with regedit).
    2) Select the HKEY_LOCAL_MACHINE tab.
    3) Expand SOFTWARE
    4) Expand VERITAS
    5) Expand NetBackup
    6) Expand CurrentVersion
    7) Click on Config
    8) On the toolbar, Edit and Add Value
    9) Change data type to REG_MULTI_SZ
    10) Enter value name of BPDBJOBS_COLDEFS
    11) Click OK
    12) In the popup dialog box paste the following:
    CLIENT 20 true
    KILOBYTES 12 true
    STARTED 20 true
    SCHEDULE 20 true
    ELAPSED 20 true
    POLICY 20 true

    Then from a DOS box, run:
    $ bpdbjobs -report -file a.txt
    $ more a.txt

    This web page lists the fields that can be reported:
    http://seer.support.veritas.com/docs/266314.htm

    Hope this helps.

    Regards,
    Dave.

14 Replies

Replies have been turned off for this discussion
  • Dennis_Strom's avatar
    Dennis_Strom
    Level 6
    19 years ago
    Formatting the output from the bpdbjobs command in VERITAS NetBackup (tm) 4.5 and 5.x
    http://support.veritas.com/docs/266314
  • Dan_Szuberla's avatar
    Dan_Szuberla
    Level 3
    19 years ago
    this is great.. however it doesn't appear to work for windows.

    i've created a bp.conf file in the program files/veritas/netbackup dir as well as the admincmd dir and the output remains the same

    also i have version 6.0 of enterprise server.

    not sure if that mattersMessage was edited by:
    Dan Szuberla
  • Dan_Szuberla's avatar
    Dan_Szuberla
    Level 3
    19 years ago
    yes i want to script the command once i have the command tweaked.. right now bpdbjobs yields the defaults as mentioned in the Support Doc

    so the questions is where in the windows 6.0 version can you edit those defaults

    BPDBJOBS_COLDEFS = JobID 5 true
    BPDBJOBS_COLDEFS = Type 4 true
    BPDBJOBS_COLDEFS = State 5 true
    BPDBJOBS_COLDEFS = Status 6 true
    BPDBJOBS_COLDEFS = Policy 6 true
    BPDBJOBS_COLDEFS = Schedule 8 true
    BPDBJOBS_COLDEFS = Client 6 true
    BPDBJOBS_COLDEFS = DstMedia_Server 12 true
    BPDBJOBS_COLDEFS = ActPID 10 true
  • Stumpr2's avatar
    Stumpr2
    Level 6
    19 years ago
    you can't do it in windows.

    But you may try building a linux media server and running bpdbjobs from it with the -M .

    I don't know if the COLDEFS in the bp.conf on the linux box will filter the jobs on the master, but it's worth a try. otherwise you will have to put together a few commands to get what you want.
  • Dan_Szuberla's avatar
    Dan_Szuberla
    Level 3
    19 years ago
    if there are other commands that i can combine to obtain the pieces of data i need that would work too.

    nix media server would of course require a license..
  • Stumpr2's avatar
    Stumpr2
    Level 6
    19 years ago
    you can get the same benefit of commands by simply installing a "Remote Admin Console" and then no license is required.
  • Dan_Szuberla's avatar
    Dan_Szuberla
    Level 3
    19 years ago
    ah yes true.. good call.

    i'll give that a try, install a remote admin console on nix and see if that will allow me to run the commands.

    is there a flavor of nix you recommend? shall i just install the console onto my Mac? will that work..lol

    i can install nix into a vm tho
  • Dennis_Strom's avatar
    Dennis_Strom
    Level 6
    19 years ago
    http://support.veritas.com/docs/278059
    DOCUMENTATION: Examples of using the "vxlogview" command to view VERITAS NetBack
    up (tm) 6.0