bpdbjobs -all_columns to obtain Actual Start Time

[MaineDCAdmin]

I need to exxtract the scheduled and actual start time, KBs, KB/Sec, Active Elapsed, Scheduled Elapsed for jobs listed in the bpdbjobs -all_columns. I have looked through the NetBackup documentation and understand the layout of the columns, but my programming skills are severely lacking. Ideally I'd like to get a CSV file with all the information from the first 32 columns plus the Actual start time. Writing a program to pull the Actual Start Time is holding me back at this point, the other information is easily extracted. I need to run this program on a UNIX platform first, but later on a Windows platform. Looking through the group I haven't found a PERL or other script which will obtain the Actual Start time. It's fine if the Actual Start time is reported in epoch, as it is easily converted in MS Access or MS Excel. I have used nbardbex (from NBAR) but it only reports the Scheduled start time. I am using NetBackup Enterprise 5.1 MP3a. If soemone hasa such a script which can be scheduled in cron it would be greatly appreciated. Thank you, in advance.

 

[Stumpr]

take a look at this and you may get some ideas.

http://www.backupcentral.com/foms/netbackup-serve/cache/194.html

Bob Stump
Just because the VERITAS documentation states a certain thing does not make it a fact and that is truth.

 

[MaineDCAdmin]

Thank you for the pointer Bob. I'm going to take a look at the code and see if there is a way to dump the output to a new CSV file rather the the formatted output. Perhpas I can also figure out how to take the formatted data and import it via SQL statements into a MySQL or other DB. Guess it is time to wipe the dust off the PERL books.

 

[MaineDCAdmin]

I'm going to keep looking. I've been trying to figure out dumper,and getting the formatted output to populate a MySQL database with no luck. I've googled and googled looking for a module to read dumper output into MySQL. Clearly this is going to take more time than I thought.