Screencasts - Hilfsvideos

NBU bppllist out in excel format

Created: 09 Nov. 2012 • Aktualisiert: 20 Nov. 2012 | 9 Kommentare
das Bild der Javed Bs
Dieses Problem wurde gelöst. Siehe Lösung.

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

Kommentare KommentareZum neuesten Kommentar

das Bild der revarooos

How do you want it to look in Excel?

Exactly what information are you wanting to capture?

das Bild der Javed Bs

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.

das Bild der revarooos

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

das Bild der Yogesh9881s

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

das Bild der revarooos

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

das Bild der Javed Bs

Yogesh,

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

das Bild der Javed Bs

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

On Unix its easier, but this Windows.

das Bild der Yogesh9881s

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

LÖSUNG
das Bild der Javed Bs

Thanks Yogesh I will try it out.