Screencasts - Hilfsvideos

Netbackup Policy Reporter

Created: 01 Sept. 2010 • Aktualisiert: 04 Nov. 2010 | 69 Kommentare
das Bild der Satkay Satishs
+5 5 Stimmen
Bitte loggen Sie sich ein, um abzustimmen

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

Kategorien für Download:

Kommentare KommentareZum neuesten Kommentar

das Bild der Carlos Vs

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

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Carlos Vs

Hello Satkay,

Could you share a new version of your program?

It was so helpfull for me. Thanks a lot

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der GiorgioIozzos

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der ldyrows

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

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der @Vimals

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

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der GiorgioIozzos

hi,

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

thanks a lot

Giorgio

ZubehörGröße
test2.txt 120.07 KB
0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

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

ZubehörGröße
GiorgioIozzo_PolicyList.xls 22.08 KB
0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der GiorgioIozzos

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

Can u send me the source?

Tnx

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

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 
ZubehörGröße
bppllist parser - 28th Aug.zip 145.78 KB
0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der GiorgioIozzos

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

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

ZubehörGröße
report_18-10-10.Doc 36.02 KB
0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der demo4119s

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

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der demo4119s

thanks it work

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

Great & Thanks for the reply.

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der abidghoris

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

Hi,

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

also -allpolicies 

bppllist -allpolices -U

Thanks!

Satkay

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der abidghoris

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der abidghoris

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der abidghoris

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

Regards

AbidG

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der sayedmackins

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

Hi Sayed,

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

Thanks!

Satish

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der demo4119s

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Thanuraths

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der V4s

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Symctecs

Very useful utility!!!!

Thanks,

Rajat

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

Thanks! smiley

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der _bylethal_s

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der rac-backups

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Amarnath Sathishkumars

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Amarnath Sathishkumars

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.

ZubehörGröße
COMDLG32.txt 149.27 KB

Amarnath Sathishkumar

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

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Amarnath Sathishkumars

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Tulika Shrivastavas

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

ZubehörGröße
policy_details.txt 3.27 MB
0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

Hi Tulika,

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

Thx.

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Tulika Shrivastavas

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Tulika Shrivastavas

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der jventurelli@itbroker.cls

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der neptors

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

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der devnishs

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Symctecs

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Lon Moks

I'm getting error below.

Run-time error '429':

ActiveX component can't create object.

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Lon Moks

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der jason_qbs

share

I hope it to be useful.

ZubehörGröße
Policy_Status.xls 205.5 KB
0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der TequilaYus

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

Hi TequilaYu, 

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

Thanks!

Satish

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der TequilaYus

Hi Satkay,

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

Thank you for your reminding.

Tequila

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der syedzeeshans

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Tanmoys

Hi Satish,

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

error.jpg
0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der syedzeeshans

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

ZubehörGröße
1bppllist.txt 76.48 KB
0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

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

ZubehörGröße
zeeshan.xlsx 15.54 KB
0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der syedzeeshans

HI Satkay,

Thank you very much :) 

it looks perfect,btw which policy was without schedule 

thank you 

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der ArturoCOBAs

Dear Satkay,

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

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Raaavans

" 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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der ontherockss

Thanks Satkay :)

OTR

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der sayedmackins

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

ZubehörGröße
Master1.txt 713.95 KB
Master2.txt 249.82 KB
0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der abidghoris

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
Bitte loggen Sie sich ein, um abzustimmen
das Bild der buck2825s

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

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Satkay Satishs

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

ZubehörGröße
Policy List Parser_2_March_2015.txt 228 KB
0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Patrick DeCelies

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

ZubehörGröße
ck-pols.zip 24.55 KB
0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Kelvin1979s

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

Invalid procedute call or argument

0
Bitte loggen Sie sich ein, um abzustimmen
das Bild der Raaavans

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

0
Bitte loggen Sie sich ein, um abzustimmen