-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If you're alright doing command line loops or writing short shell scripts, here
you go:

for i in `bppllist` ; do
  printf "$i:"
  bpplclients $i -l | awk '{printf $2":"}'
  printf "\n"
done

That will give you an output of

policy1:clientA:clientB:
policy2:clientC:clientd:


etc...  Just replace the ":" with a "," or whatever separator you want
This is for bash or sh, modify the loop syntax for csh/tcsh
If you are running windows, install cygwin....

Thanks
Peter

Peter DrakeUnderkoffler
Xinupro, LLC
617-834-2352



Koster, Phil wrote:
> We ended up just using a bppllist and hand creating a file.  We were
> hoping for something more parsable without re-writing the NBU reporting
> module but in the end we couldn't figure out any better way to do it. 
>  
> Thanks.
>  
> Phil Koster
> Network Administrator
> City of Grand Rapids
> Direct: 616-456-3136
> Helpdesk: 456-3999
> 
> ------------------------------------------------------------------------
> *From:* WEAVER, Simon [mailto:simon.weaver at astrium.eads.net]
> *Sent:* Thursday, September 21, 2006 4:15 AM
> *To:* Koster, Phil; veritas-bu
> *Subject:* RE: [Veritas-bu] Policy Auditing: How to
> 
> */Do you mena BPPLList command perhaps?/*
> */It gives an output and you can use the > to write to a file if it
> helps :-)/*
>  
>  
> 
> /Regards/
> 
> /Simon Weaver
> *3rd Line Technical Support
> Windows Domain Administrator*/
> 
> /EADS Astrium Limited, B23AA IM (DCS)/
> /Anchorage Road, Portsmouth, PO3 5PU/
> 
> /Email: //Simon.Weaver at Astrium-eads.net/
> <mailto:Simon.Weaver at Astrium-eads.net>
> 
>     -----Original Message-----
>     *From:* "Koster, Phil" [mailto:pkoster at ci.grand-rapids.mi.us]
>     *Sent:* 18 September 2006 14:14
>     *To:* veritas-bu
>     *Subject:* [Veritas-bu] Policy Auditing: How to
> 
>     NBU 6 MP2 on Win2K Srvr
> 
>     Me and the other "backup admin" inherited the NBU system from
>     someone else. We want to audit the policies. I think I already know
>     the answer but is there any "easy" way to get a list of which
>     servers are in which back up policies without having to do this one
>     policy or one client at a time? It'd be nice to get it dumped to
>     like a csv or something we can process to look for duplicates etc.
> 
>     I have a feeling I am going to have to do some combination of
>     bplist, and bpplclients and probably more.
> 
>     Basically we just want to do a full audit of the nBU policies
>     including schedules and which servers are in the policies etc. Seems
>     to me there should be a relatively easy way to do this but maybe I
>     am wrong. Anyone at least already have a script or something that
>     can do this?
> 
>     Thanks.
> 
>     Phil Koster
>     Network Administrator
>     City of Grand Rapids
>     Direct: 616-456-3136
>     Helpdesk: 456-3999
> 
> This email is for the intended addressee only.
> If you have received it in error then you must not use, retain,
> disseminate or otherwise deal with it.
> Please notify the sender by return email.
> The views of the author may not necessarily constitute the views of
> Astrium Limited.
> Nothing in this email shall bind Astrium Limited in any contract or
> obligation.
> 
> Astrium Limited, Registered in England and Wales No. 2449259
> Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS,
> England
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu at mailman.eng.auburn.edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (FreeBSD)

iD8DBQFFEpOPl+lekZRM55oRAiDmAKCtvfxWW4XfO+QnaDS79/zyOv7E6ACgy2WW
0ZkWbXcMlIYX5IaNgaOg+ZE=
=KzK5
-----END PGP SIGNATURE-----