This issue has been solved.

NBU bppllist out in excel format

Created: 09 Nov 2012 | Updated: 20 Nov 2012
Javed B's picture
Javed B Certified
Login to vote
0 0 Votes

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

Quick Look Solution

Hi Javed, No need to export

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

 

Filed Under

Tags:
, , , ,

Comments

revaroo
Symantec Employee
10
Nov
2012
Votes
0

How do you want it to look in

How do you want it to look in Excel?

Exactly what information are you wanting to capture?

Javed B
Accredited
Certified
10
Nov
2012
Votes
0

Hi, I need to capture all the

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
Symantec Employee
11
Nov
2012
Votes
0

Would be easier with unix,

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

Yogesh9881
Partner
Accredited
11
Nov
2012
Votes
0

Javed, You can achive this

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
Symantec Employee
11
Nov
2012
Votes
0

Yogesh, how does that work

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

Javed B
Accredited
Certified
11
Nov
2012
Votes
0

Yogesh,   How can you get it

Yogesh,

 

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

Javed B
Accredited
Certified
11
Nov
2012
Votes
0

What I'm looking for any

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

On Unix its easier, but this Windows.

Yogesh9881
Partner
Accredited
20
Nov
2012
Votes
0
SOLUTION

Hi Javed, No need to export

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

Javed B
Accredited
Certified
20
Nov
2012
Votes
0

Thanks Yogesh I will try it

Thanks Yogesh I will try it out.