Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

NBU bppllist out in excel format

Created: 09 Nov 2012 • Updated: 20 Nov 2012 | 9 comments
Javed B's picture
This issue has been solved. See solution.

Hello,

 

I have NBU running on version 7.0.1 and I need to collect the all policy information. I need some help so that the output can be transferred to excel file.

I used the "bppllist -allpolicies -U > C:\policy.txt"

The output is huge as there are about 200 policies some active and some deactivated. So I need batch file to get a formattable out put.

 

Regards

Javed

Comments 9 CommentsJump to latest comment

revaroo's picture

How do you want it to look in Excel?

Exactly what information are you wanting to capture?

Javed B's picture

Hi,

I need to capture all the data that is available through the output of command "bppllist -U -allpoicies.

for e.g Policy Name, Type of Policy, Client, Schedule. Whether policy is Active or Not and so on.

The reason for excel is for better formatting.

I do not have any symantec reporting tool.

Is this possible ?

Any help would be appreciated.

 

 

revaroo's picture

Would be easier with unix, Windows not so easy. Its possible. I just don't know how to do that with Windows.

Yogesh9881's picture

Javed,

You can achive this only by insatlling java console.....

If this post has helped you, please vote or mark as solution.

Before break-up, make sure you have a good backup.....  ;-)

revaroo's picture

Yogesh, how does that work because you can't export the policy information (not that I can see).

Javed B's picture

Yogesh,

 

How can you get it by Java Console. Please explain.

Javed B's picture

What I'm looking for any batch script to get this done.

On Unix its easier, but this Windows.

Yogesh9881's picture

Hi Javed,

No need to export any thing ..... Adjust filters according to your need in Java console & and copy (cntl+c) & paste it in exelsheet.  thats all....smiley

 

If this post has helped you, please vote or mark as solution.

Before break-up, make sure you have a good backup.....  ;-)

SOLUTION
Javed B's picture

Thanks Yogesh I will try it out.