Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Netbackup Policy Reporter

Created: 31 Aug 2010 • Updated: 04 Nov 2010 | 63 comments
Satkay Satish's picture
+4 4 Votes
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

Download Filed Under:

Comments 63 CommentsJump to latest comment

Carlos V's picture

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

0
Login to vote
Satkay Satish's picture

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
0
Login to vote
GiorgioIozzo's picture

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
Satkay Satish's picture

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
ldyrow's picture

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

0
Login to vote
Satkay Satish's picture

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
@Vimal's picture

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

0
Login to vote
GiorgioIozzo's picture

hi,

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

thanks a lot

Giorgio

AttachmentSize
test2.txt 120.07 KB
0
Login to vote
Satkay Satish's picture

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

AttachmentSize
GiorgioIozzo_PolicyList.xls 22.08 KB
0
Login to vote
GiorgioIozzo's picture

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
Satkay Satish's picture

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 
AttachmentSize
bppllist parser - 28th Aug.zip 145.78 KB
0
Login to vote
GiorgioIozzo's picture

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
Satkay Satish's picture

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

AttachmentSize
report_18-10-10.Doc 36.02 KB
0
Login to vote
demo4119's picture

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

0
Login to vote
Satkay Satish's picture

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
demo4119's picture

thanks it work

0
Login to vote
Satkay Satish's picture

Great & Thanks for the reply.

0
Login to vote
abidghori's picture

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
Satkay Satish's picture

Hi,

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

also -allpolicies 

bppllist -allpolices -U

Thanks!

Satkay

0
Login to vote
abidghori's picture

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
Satkay Satish's picture

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
abidghori's picture

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
abidghori's picture

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

Regards

AbidG

0
Login to vote
sayedmackin's picture

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
Satkay Satish's picture

Hi Sayed,

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

Thanks!

Satish

0
Login to vote
demo4119's picture

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
Thanurath's picture

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
Satkay Satish's picture

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
captain jack sparrow's picture

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...

 Cheers !!!

CJS

0
Login to vote
Satkay Satish's picture

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
Symctec's picture

Very useful utility!!!!

Thanks,

Rajat

0
Login to vote
Satkay Satish's picture

Thanks! smiley

0
Login to vote
_bylethal_'s picture

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
rac-backup's picture

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
Amarnath Sathishkumar's picture

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
Amarnath Sathishkumar's picture

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.

AttachmentSize
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
Login to vote
Amarnath Sathishkumar's picture

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
Tulika Shrivastava's picture

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

AttachmentSize
policy_details.txt 3.27 MB
0
Login to vote
Satkay Satish's picture

Hi Tulika,

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

Thx.

0
Login to vote
Tulika Shrivastava's picture

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
Tulika Shrivastava's picture

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
jventurelli@itbroker.cl's picture

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
neptor's picture

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

0
Login to vote
devnish's picture

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
Symctec's picture

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
Lon Mok's picture

I'm getting error below.

Run-time error '429':

ActiveX component can't create object.

0
Login to vote
Lon Mok's picture

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
Satkay Satish's picture

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
jason_qb's picture

share

I hope it to be useful.

AttachmentSize
Policy_Status.xls 205.5 KB
0
Login to vote
TequilaYu's picture

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
Satkay Satish's picture

Hi TequilaYu, 

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

Thanks!

Satish

0
Login to vote
TequilaYu's picture

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
syedzeeshan's picture

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
Tanmoy's picture

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
Satkay Satish's picture

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
syedzeeshan's picture

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

AttachmentSize
1bppllist.txt 76.48 KB
0
Login to vote
Satkay Satish's picture

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

AttachmentSize
zeeshan.xlsx 15.54 KB
0
Login to vote
syedzeeshan's picture

HI Satkay,

Thank you very much :) 

it looks perfect,btw which policy was without schedule 

thank you 

0
Login to vote
ArturoCOBA's picture

Dear Satkay,

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

0
Login to vote
Raaavan's picture

" 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
ontherocks's picture

Thanks Satkay :)

OTR

0
Login to vote
sayedmackin's picture

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

AttachmentSize
Master1.txt 713.95 KB
Master2.txt 249.82 KB
0
Login to vote
abidghori's picture

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