on 12-10-2010 11:16 AM
Hi NBU Folks,
In this download I'm sharing the VB utility that i coded to generate Netbackup reports.
Features.
Enhancements Pending
How it Works
Installation
The tool should run and you should be able to generate the report manually.
Automated Run ( Scripts shared in download )
========= NBU-Report.bat==============
cd C:\Report Writer
del bpdbjobs.old
ren bpdbjobs.txt bpdbjobs.old
bpdbjobs -all_columns > bpdbjobs.txt
Report_Writer_NTUC.exe -q
Send_Mail.vbs
==================================
Hope it helps our NBU folks. Comments & Enhancement requests are most welcome.
Thanks!
Satkay Satish
Hi,
i think it is a litle bit complicate to configure. How about to use config file for smtp server?
For retension file check command: bpretlevel.exe -l
You can automatic generate report_writer_config.txt
Why don't you include COMDL32.ocx to zip file?
How about failed jobs? Can be add to report as option.
Please check my tool NBU Configuration Reporter
Thank you
My improvments:
========= NBU-Report.bat==============
setlocal
set PATH=%PATH%;C:\Program Files\Veritas\NetBackup\bin\admincmd
pushd C:\Report Writer
del bpdbjobs.old
I am trying to trigger this tool and getting the result of the past week or 2.
I tried report_writer_NTUC.exe -q 72 and the GUI popped up..
Also can I specify where the html will be saved and in a constant name .html too ? (eg. c:\website\report_writer_result.html)
Hi Jacky,
I've coded -q to run only in quite mode. If any other option or no option is specified it would open the GUI which gives option to select start and end dates.
If you need to run report for 72 hours you need to use GUI which cannot be automated
I've attached new verison of this file which generates the report and names it as DD_MM_YY. ( Rename the file from .txt to .exe)
Try this out. It has more fields.
Also i've changed the color and looks. Will mail you by tomorrow that version
Also note, Now you need to run bpdbjobs -most_columns instead of bpdbjobs -all_columns.
bpdbjobs -most_columns > bpdbjobs.txt
this generates the report much quicker.
Thanks!
Satish
Run Time error 53, what am I missing?
Hi Jacky,
Sorry forgot to tell you that you need to create jobid.txt in the same location as the tool and then open this file and key in the job id from where you need to generate the report. this is one time and after every run it would update itself with the last jobid processed.
Like to know if it worked.
Thanks!
Satish
here's the updated code.
Works now, thanks Satish.
Happy coding and Do share with any enhancements for us all to utilize. :)
Hi Satkay,
Could you please help me, I've installed everything as outlined above but when the report is generated and emailed it lists the policies as "Not Found", the format etc of the policies is exactly what is in the "bpdpjobs.txt" but it doesn't convert to the report which is emailed.
Hope you can help.
Cheers
Liam
(Please see the attachments)
Hi LiamJG,
Apologies for late response. Please set the date format in Control Panel --> Regional setting --> Customize
to M/d/yyyy. I faced similar issue and it was fixed as outlined above.
Thanks!
Satkay