Ayuda de vídeo de Screencast

Netbackup Policy Reporter

Created: 01 Sept 2010 • Updated: 04 Nov 2010 | 69 comments
el cuadro de los Satkay Satish
+5 5 Votos
Login to vote

Its quite common for management or other teams asking for Netbackup Policies and A netbackup admin needs to keep these details updated every time there are changes done to the policy.

I found this need to automate this task which made me to write this tool.

Details:   Generates the Backup Policy Report

Input:  Provide the O/P of bppllist -allpolicies -U

Output:   Output the details of Backup policies in excel sheet

Rename the attached file to Policy List Parser.exe and Enjoy cool
Hope you all find it useful.

Thanks!
Satkay Satish

Descargar Filed Under:

Comentarios ComentariosIr al último comentario

el cuadro de los Carlos V

I was reviewing the file Policy List Parser.txt, but is not legible, can u check please.

0
Login to vote
el cuadro de los Satkay Satish

Hi Carlos,

Thanks for your interest. The attached file is a utility coded in VB.

1: Right Click on the download link and select "Save As" to save it to your desktop.

2: You need to rename the downloaded file from "Policy List Parser.txt" to "Policy List Parser.exe" and then run this utility.

3: Once the tool is running a the attached screen comes up.

4: Collect the o/p of bppllist -allpolicies -U from your master server and copy it to your system.

5: Provide the o/p file to the policy list parser utility.

6: Provide a suitable name for the report( Eg. Policy_List_18_Sep.xls). Its generated in the directory where the utility is present

PS: The PC on which this tool runs need to have EXCEL installed.

Thanks!

Satkay Satish

Main Form.jpg
+1
Login to vote
el cuadro de los Carlos V

Hello Satkay,

Could you share a new version of your program?

It was so helpfull for me. Thanks a lot

0
Login to vote
el cuadro de los GiorgioIozzo

I try to execute the vbs but i have this message:

Subscript out of range (Error 9)

U know why?

thanks a lot

Giorgio Iozzo

+1
Login to vote
el cuadro de los Satkay Satish

Hi Giorgio,

The file that you've generated using bppllist -allpolicies -U is incorrect.

Can you please share the output of the above command. It should work fine. Also the above tool is tested with NBU 6.5 & NBU 7. If you need older version for NBU6, I can share it. :)

Thanks!

Satkay

0
Login to vote
el cuadro de los ldyrow

Satkay - can you please share the NBU6 version of your policy reporter?  Thanks!

0
Login to vote
el cuadro de los Satkay Satish

Hi ldyrow, Can you please mail me the output of bppllist -allpolicies -U  satkay@gmail.com

I'm unable to get the output of 6.0 :(

Thanks!

Satkay

0
Login to vote
el cuadro de los @Vimal

Thanks for posting ...this very useful , it reduces lot of times policy report creationsmiley

0
Login to vote
el cuadro de los GiorgioIozzo

hi,

i attach my bppllist -allpolicies -U output....if it's incorrect i don't know where

thanks a lot

Giorgio

Archivo adjuntoTamaño
test2.txt 120.07 el LAN switch
0
Login to vote
el cuadro de los Satkay Satish

Hi Giorgio,

The input file is correct. I've run the same tool on my system and it runs fine without any errors.

It would also won't run if there is no Excel installed on your system.

I've attached the generated output.

Thanks!

Satkay

Archivo adjuntoTamaño
GiorgioIozzo_PolicyList.xls 22.08 el LAN switch
0
Login to vote
el cuadro de los GiorgioIozzo

Could be a language problem of office?I think that the porblem could be the nazionalization.

Can u send me the source?

Tnx

0
Login to vote
el cuadro de los Satkay Satish

Hi Giorgiolozzo,

As i said, I'm open source believer and happy to share. Here's the source code for everybody.

Its VB6 project.

Happy coding and enhancing this tool. smiley

 
Thanks!
Satkay Satish 
Archivo adjuntoTamaño
bppllist parser - 28th Aug.zip 145.78 el LAN switch
0
Login to vote
el cuadro de los GiorgioIozzo

how i suppose the problem was my ITALIAN office.

after i install english office it work. Great!!!!!

Now another question:

Can i script the name of source and the output to schedule it?

Can i use ur great program with command line?

thanks a lot

Giorgio Iozzo

0
Login to vote
el cuadro de los Satkay Satish

Hi Giorgio ,

My apologlies, Couldn't post the source here as recently upgraded my system and don't have VB installed to view the source.frown. Also I'm open source supporter.

Currently I haven't programmed the tool for automated run neither it has CLI, but soon can add that feature too. You can expect to have these by mid Nov as I'm going on vacations

wink

Thanks again for testing out the tool and pleasure it made your task easier.

Will be posting another report writer tool soon.Sample report attached.( Rename it to .html as forum don't support html file)

Thanks!

Satkay Satish

Archivo adjuntoTamaño
report_18-10-10.Doc 36.02 el LAN switch
0
Login to vote
el cuadro de los demo4119

Component 'COMDLG32.ocx' or one of its dependencies not correctly registered.a file is missing or invaild

0
Login to vote
el cuadro de los Satkay Satish

Hi,

Download and copy comdl32.ocx in wowsys64 folder, register the ocx using regsrv32.

This would resolve the issue and tool should work fine.

Thanks!

Satkay Satish

0
Login to vote
el cuadro de los demo4119

thanks it work

0
Login to vote
el cuadro de los Satkay Satish

Great & Thanks for the reply.

0
Login to vote
el cuadro de los abidghori

hi satay,

i have nbu 7 and win 2008 64 , when i run the command bplist -allpolices -U, i am getting the following

unrecognised option allpolices.

can anybody guide me in right direction, i want this policy reporter as it is very useful for me.

regards

abidg

0
Login to vote
el cuadro de los Satkay Satish

Hi,

There is a typo in your command, bppllist is typed as bplist,

also -allpolicies 

bppllist -allpolices -U

Thanks!

Satkay

0
Login to vote
el cuadro de los abidghori

i got the output when i run the command from \veritatas\netbacup\bin\admincmd\bppllist -allpolicy -U and when i got the output i can see only the columns Headers but not the data, what could be the reason.

waiting for reply

0
Login to vote
el cuadro de los Satkay Satish

Hi abidghori ,

For windows 2k8, due to UAC security issues it may not allow to run the command successfully.

try the following.

1 : Right Click "Command Prompt" and select "run as administrator"

2: Navigate to the path of bppllist

3: Run the command bppllist -allpolicies -U

Hope it helps.

Thanks!

Satkay

0
Login to vote
el cuadro de los abidghori

Thanks man, i got in excel sheet but i need to arrange it as the names are big, Anyway Superb.

do you have any other scripts or articles which help me in reporting as well as which helps in using OpsCenter

thanks

AbidG

0
Login to vote
el cuadro de los abidghori

i would like to arrange well in excel so that i can present this a report.

Regards

AbidG

0
Login to vote
el cuadro de los sayedmackin

Hi,

  When ever i am running the parser and having provided the out file of the command bppllist -allpolicies -U and then giving the output file as filename.xls, the excel is opening but i am getting a "Run Time Error 1004" The file could not be accessed. Please help me in getting the excel output.

0
Login to vote
el cuadro de los Satkay Satish

Hi Sayed,

My apologies for late response. Can you please send me across bppllist output.

Thanks!

Satish

0
Login to vote
el cuadro de los demo4119

copy the output policy txt to the same folder as the policy parser.

then run the policy parser and output as below:

input file d:\temp\policy.txt

output file polic.xls

please try it out .

0
Login to vote
el cuadro de los Thanurath

Hi Satkay,

Many thanks for your share tools.

I got error

When I run "Policy List Parser.exe" in Windows 2008 R2  64 bit  with Netbackup 7.

Could U please help.

Thanks!

screenshot.297.jpg
0
Login to vote
el cuadro de los Satkay Satish

Hi Narupon,

 Apologies for late response as these days out of action due to dealing with tech support :)

Yes, I tried running the tool on Win 2K3 x64 and it worked, this is what i did.

Download and copy comdl32.ocx in wowsys64 folder, register the ocx using regsrv32.

Thanks!

Satkay Satish 

0
Login to vote
el cuadro de los V4

Hi Satkay

I've SEP 12 and ur utility was detected as Bloodhound.Sonar.9 ... Can u please verify this is not any malicious one...

0
Login to vote
el cuadro de los Satkay Satish

Hi Vaibhav,

Thanks for highlighting this.  If doubt to be malicious, you can download the source from this post and compile it yourself. You need to have a basic knowledge of VB6 to do so.

Thanks!

Satish

0
Login to vote
el cuadro de los Symctec

Very useful utility!!!!

Thanks,

Rajat

0
Login to vote
el cuadro de los Satkay Satish

Thanks! smiley

0
Login to vote
el cuadro de los _bylethal_

Hi Satkay,
Firstly thank you for Policy Reporter Tool
But I did't work this tool.

I got some errors. (ocx, dll, etc.) figured out some problems.
But now I get the error

1004. (Run-time error '1004 ';The File Could Not Be Accessed. Try One Of The Following:
Make Sure the specified folder exists.
Make Sure the folder contains the file is not read-only ...)

I use Office 2003 on Windows XP.

0
Login to vote
el cuadro de los rac-backup

Hello Satkay, I think your tool does exactly what I'm after Which is taking the output of bppllist and making it human friendly. Unfortunatly I get the following error: Have you seen this one before? Is so how do I resolve the issue.

Many thanks

0
Login to vote
el cuadro de los Amarnath Sathishkumar

How to check The Date on which a Backup Policy is De-Activated.

Amarnath Sathishkumar

If this comment is helpfull, Don't forget to give a "Thumbs Up" or mark as "Solution"

0
Login to vote
el cuadro de los Amarnath Sathishkumar

Hi All,

When i tried to Execute the Policy List Parser.exe application, I got a Error stating as below,

"Missing Comdlg32.ocx Error While Running the Application."

Please follow the below steps to Fix this Error.

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-

1. Download the attached COMDLG32.txt file to your desktop.

2. Rename the file as COMDLG32.OCX

3. Type SYSTEM32 in Run Command. (Ctrl + R / Start - Run)

4. Paste Comdlg32.ocx file in System32 folder and re-run the application.

Enjoy working on the application.

Archivo adjuntoTamaño
COMDLG32.txt 149.27 el LAN switch

Amarnath Sathishkumar

If this comment is helpfull, Don't forget to give a "Thumbs Up" or mark as "Solution"

0
Login to vote
el cuadro de los Amarnath Sathishkumar

Hi Satkay,

How to check The Date on which a Backup Policy is De-Activated.

Can you please assist me in this...

Amarnath Sathishkumar

If this comment is helpfull, Don't forget to give a "Thumbs Up" or mark as "Solution"

0
Login to vote
el cuadro de los Tulika Shrivastava

Hi Satkay,

I tried to run it bot nothing is displayed . (after i run the exe parser)

Just a black scrren for seconds and then goes away.

Please its really urgent for me to fetch the data in excel.

Please find my attached output in notepad.

Please send it on my id.  tulika.backupadm@gmail.com

Archivo adjuntoTamaño
policy_details.txt 3.27 el MB
0
Login to vote
el cuadro de los Satkay Satish

Hi Tulika,

I've generated the output and mailed to your ID.

Thx.

0
Login to vote
el cuadro de los Tulika Shrivastava

Hey Thanks a lot Sathish. It was really kind of you to do that.

 
Now i am getting the below error (Thats also mentioned in your post but could not understand your solution for that)
 
 "Component 'COMDLG32.OCX or one of its dependencies not correctly registered :a file is missing or invalid "
 
 
I also tried steps by AMARNATH "Please follow the below steps to Fix this Error.

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-

1. Download the attached COMDLG32.txt file to your desktop.

2. Rename the file as COMDLG32.OCX

3. Type SYSTEM32 in Run Command. (Ctrl + R / Start - Run)

4. Paste Comdlg32.ocx file in System32 folder and re-run the application. "

 
My OS is 32 bit.
 
I have  comdl32.ocx  in system32 ,but i am unable to find  wowsys64 Folder in system32.
 
Also i have downloaded a new comdl32.ocx and how do i register the ocx using regsrv32??
 
  
0
Login to vote
el cuadro de los Tulika Shrivastava

Guys Its working fine now :)

Thanks all for your tips and specially Satkay ,as i faced all the errors mentioned by every1 in this post.

But filnally it is working:)

0
Login to vote
el cuadro de los jventurelli@itbroker.cl

Hi Satish,

  When  i    generate  report, appears  follow  error,

 Run time  error '9' 

subscript  out  of range

How  i  can  to resolve  this  issue??

Regards,

Jonathan

0
Login to vote
el cuadro de los neptor

Well done. I've been looking for something like this to get the information in a readable format. Thanks!

0
Login to vote
el cuadro de los devnish

Hi sathish,

I have tried to generate report by the below steps

1. open policy list parser
2. i have redirected the bppllist -allpolicies -U output to the text file (policy.txt).
3. I have selected the downloaded file in the input file path c:/policy.txt.
4. And i have given the same path and the file name c:/policy.xls
5. when i click generate (Run Time error '1004';
SaveAs Method of Workbook class failed.

Kindly help me to genarate the report.

Thank you.

0
Login to vote
el cuadro de los Symctec

Hey Devnish,

Had similar issues too, copied the parser tool and the bppllist file to the desktop and ran the tool from there, works ok for me.

NO need to specify any destination path like "c:\...". Just give the filename in the destination field, should be ok.

Thanks.

0
Login to vote
el cuadro de los Lon Mok

I'm getting error below.

Run-time error '429':

ActiveX component can't create object.

0
Login to vote
el cuadro de los Lon Mok

They honestly should put a human readable format into the program. Just doesn't seem to make sense that they can't generate something like this.

Seems it didn't like to run this EXE on my Win8 box, but worked on an older system.

Nice job Satkay!

+1
Login to vote
el cuadro de los Satkay Satish

Thanks Lon Mok, Boost my morale to write more of such codes. 

BTW: going for Linux Development Course very soon, If that happens will port this to Java. wink

0
Login to vote
el cuadro de los jason_qb

share

I hope it to be useful.

Archivo adjuntoTamaño
Policy_Status.xls 205.5 el LAN switch
0
Login to vote
el cuadro de los TequilaYu

Hi Satkay,

I saw your nice presentation report for the application.

I'm using command "bppllist -allpolicies -U" and generated the input file. Source + input files both save as D:\ folder.

Win Office 2002 + WinXP. Executed the "Policy List Parser.exe", click "Generate Reprot" then Excel file opened but appear below error.

"Run-time error '1004';

SaveAs method of Workbook class failed."

Would you kindly help?

0
Login to vote
el cuadro de los Satkay Satish

Hi TequilaYu, 

I suspect permission issue in D:\ , can you try to point it to another folder instead.

Thanks!

Satish

0
Login to vote
el cuadro de los TequilaYu

Hi Satkay,

It is working properly now once created the new folder (d:\policy\) and executed.

Thank you for your reminding.

Tequila

0
Login to vote
el cuadro de los syedzeeshan

Hi Satkay,

hope you are doing well

your tool is really awesome ,i need your assistance as i have exported the txt file

bppllist -allpolicies -U

but once insert in policy eraser it through me error

run time error i am attaching the screen shot

runtime.PNG
0
Login to vote
el cuadro de los Tanmoy

Hi Satish,

I am getting the following error while running this on XP. Please help me to restolve this. Thanks.

error.jpg
0
Login to vote
el cuadro de los Satkay Satish

Hi Tanmoy,

You may try these steps to register COMDLg32

Hi All,

When i tried to Execute the Policy List Parser.exe application, I got a Error stating as below,

"Missing Comdlg32.ocx Error While Running the Application."

Please follow the below steps to Fix this Error.

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-

1. Download the attached COMDLG32.txt file to your desktop.

2. Rename the file as COMDLG32.OCX

3. Type SYSTEM32 in Run Command. (Ctrl + R / Start - Run)

4. Paste Comdlg32.ocx file in System32 folder and re-run the application.

Enjoy working on the application.

0
Login to vote
el cuadro de los syedzeeshan

Dear Satkay,

i really appreciate your help on my query

i cannot run the policy list tool on my bppllist

i am attaching the txt file.please reveiew

Archivo adjuntoTamaño
1bppllist.txt 76.48 el LAN switch
0
Login to vote
el cuadro de los Satkay Satish

Hi Zeeshan,

Apologies, I saw your mail but couldn't respond due to work :(

The parser cannot handle any policy without schedule and hence it error out. 

I've removed such policy and generated the report. Hope it helps.

Thanks!

Satish

Archivo adjuntoTamaño
zeeshan.xlsx 15.54 el LAN switch
0
Login to vote
el cuadro de los syedzeeshan

HI Satkay,

Thank you very much :) 

it looks perfect,btw which policy was without schedule 

thank you 

0
Login to vote
el cuadro de los ArturoCOBA

Dear Satkay,

Men , I love you !!!!!!!!!!!!!! really thanks a lot !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

0
Login to vote
el cuadro de los Raaavan

" 1 no tool banaya dost" ....it's really help full & made my task easy

i wonder if you assist me to generate last backup size for all policy's with respect to there schedule

Again Thanks...!!

0
Login to vote
el cuadro de los ontherocks

Thanks Satkay :)

OTR

0
Login to vote
el cuadro de los sayedmackin

Hi Satkay,

Can u please parse the attached files for me I am getting errors "Run time error 62: Input Past end of file"

Thanks

Archivo adjuntoTamaño
Master1.txt 713.95 el LAN switch
Master2.txt 249.82 el LAN switch
0
Login to vote
el cuadro de los abidghori

Hi Satkay Satish,

Is this tool, still valid for 7.5?. Please let me know  as i am trying since two days but not getting the outpur, Runtime error 1004.

Regards

AbidGhori

0
Login to vote
el cuadro de los buck2825

Has anyone tried this script    http://sourceforge.net/projects/nbu-policy/files/?source=navbar

0
Login to vote
el cuadro de los Satkay Satish

Updated to parser the calendar schedule... [ 2-March-2015]

Rename the file Policy List Parser_2_March_2015.txt to Policy List Parser_2_March_2015.exe

Archivo adjuntoTamaño
Policy List Parser_2_March_2015.txt 228 el LAN switch
0
Login to vote
el cuadro de los Patrick DeCelie

Hello Satkay,

Thank you for the reporting program.  Unfortunately, when I ran it and received a "Runtime error 62: Input past end of file". A check of the input file does not show any obvious issues.  See input file attached. Can you suggest anything?

Thanks,
Pat

Archivo adjuntoTamaño
ck-pols.zip 24.55 el LAN switch
0
Login to vote
el cuadro de los Kelvin1979

Do the tools support NBU 7.6.1 output? suffer Run time error 5 

Invalid procedute call or argument

0
Login to vote
el cuadro de los Raaavan

Can we have "volue pool" for details in this report as it's showing empty 

0
Login to vote