cancel
Showing results for 
Search instead for 
Did you mean: 

Export csv data by schedule

itea
Level 3

Hello!

Can I to export some reports from Symantec NetBackup 8 Administration Console to a CSV format by schedule?

I need a "Client Backups" report every day for store some data from it but I don't know how to export a data automatically.

Please, share a commanline sequence for execute of a command for export.

6 REPLIES 6

sdo
Moderator
Moderator
Partner    VIP    Certified

Cannot be automated from a NetBackup v8 Admin Console.

On a master server... use scheduled task on Windows, or cron on Unix/Linux, or an enterprise scheduling product, or tie a pre (bpstart_notify) or post (bpend_notify) script to a backup job on your master server.

The command you want is:  bpdbjobs

Check the manual for usage, here:

https://www.veritas.com/support/en_US/article.000116393

Serarch Vox for examples, here's one:

https://vox.veritas.com/t5/NetBackup/bpdbjobs-all-columns/m-p/825425/highlight/true#M224049

Hi, sdo!

Thank you for the comprehensive answer!

Cat Surprised

quebek
Moderator
Moderator
   VIP    Certified

Hello

Please look at the OpsCenter - this tool is having such report you are willing to make manually...

sdo
Moderator
Moderator
Partner    VIP    Certified

Quite right @quebek - good call, there a lots of pretty good generic reports to choose from in OpsCenter, most of which should be able to email you a CSV file, on a repeating schedule...

...and if you reach the point where you need to do something custom and more site specific in OpsCenter, then this super post from @VoropaevPavel may help you too:

https://vox.veritas.com/t5/Downloads/OpsCenter-common-custom-reports/ta-p/809039

Thank you!

I tried a bpdbjobs and found it very useful :)

But I need a help again.... I found a limitation of printing output of bpdbjobs command. I can to fetch the history only in just 4 days. And no more. Maybe it's a limitation by OS or by design of the application? I need 'magick switches' (commandline), please. The implementation of my system is therefore currently at risk :(

 

Marianne
Level 6
Partner    VIP    Accredited Certified

Activity Monitor and bpdbjobs output comes from Jobs Database. 
The default for this db is 3 days. It can be extended, but will slow down your Activity Monitor.

Your opening post says you need "need a "Client Backups" report every day", meaning that runningbpdbjobs every day will be good, right?

If you need the equivalent of Client Backups report, you can run :
bpimagelist -U [-A|-client name] [-d <start_date> <start_time> -e <end_date> <end_time>]

See : https://www.veritas.com/support/en_US/article.TECH20462

I agree with @quebek - OpsCenter is best to automate reports and email the output.