cancel
Showing results for 
Search instead for 
Did you mean: 

NBU bppllist out in excel format

Javed_B
Level 3
Accredited Certified

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

1 ACCEPTED SOLUTION

Accepted Solutions

Yogesh9881
Level 6
Accredited

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

 

View solution in original post

9 REPLIES 9

revarooo
Level 6
Employee

How do you want it to look in Excel?

Exactly what information are you wanting to capture?

Javed_B
Level 3
Accredited Certified

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.

 

 

revarooo
Level 6
Employee

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

Yogesh9881
Level 6
Accredited

Javed,

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

revarooo
Level 6
Employee

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

Javed_B
Level 3
Accredited Certified

Yogesh,

 

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

Javed_B
Level 3
Accredited Certified

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

On Unix its easier, but this Windows.

Yogesh9881
Level 6
Accredited

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

 

Javed_B
Level 3
Accredited Certified

Thanks Yogesh I will try it out.