Video Screencast Help
Search Video Help Close Back
to help

NBU bppllist out in excel format

Created: 09 Nov 2012 | Updated: 20 Nov 2012 | 9 comments
Javed B's picture
0 0 Votes
Login to vote
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?

0
Login to vote
  • Actions
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.

 

 

0
Login to vote
  • Actions
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.

0
Login to vote
  • Actions
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.....  ;-)

0
Login to vote
  • Actions
revaroo's picture

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

0
Login to vote
  • Actions
Javed B's picture

Yogesh,

 

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

0
Login to vote
  • Actions
Javed B's picture

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

On Unix its easier, but this Windows.

0
Login to vote
  • Actions
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
0
Login to vote
  • Actions
Javed B's picture

Thanks Yogesh I will try it out.

0
Login to vote
  • Actions