Quick & dirty but this'll do it

>cat rpt_policybyclient

#!/bin/ksh
PATH=$PATH:/usr/openv/netbackup/bin/admincmd

for client in `bpplclients -allunique -noheader|awk '{print $3}'`
do
  echo "$client:\c"
  bppllist -byclient $client | awk '$1=="CLASS" {printf("%s ",$2)}'
  echo ""
done 
exit


Not sure what you mean by "active" clients so I just took this to be
just "clients in policies".  If you mean clients in active policies
only, then let me know, it's a small tweak.

-M


-----Original Message-----
From: veritas-bu-bounces at mailman.eng.auburn.edu
[mailto:veritas-bu-bounces at mailman.eng.auburn.edu] On Behalf Of
Courteney, Jonathan
Sent: Thursday, July 20, 2006 8:50 AM
To: veritas-bu at mailman.eng.auburn.edu
Subject: [Veritas-bu] Generating list of all active clients !!

  
Hi

I am about to start a migration to new tape silo's and as part of this I
would like to tidy up the clients and policies as I migrate. I want to
generate a list from Netbackup of all active clients and the policies
they are currently in? I have played about with bpdbjobs , bpclclients
but cannot seem to achieve this.

Any help would be gratefully received.

Currently I have 98 policies with about 1700 clients.

Master server - Solaris 8 - Netbackup 5.1 MP3a

Many thanks

Jonathan



------------------------------------------------------------------------
--------
The information contained herein is confidential and is intended solely
for the
addressee. Access by any other party is unauthorised without the express

written permission of the sender. If you are not the intended recipient,
please 
contact the sender either via the company switchboard on +44 (0)20 7623
8000, or
via e-mail return. If you have received this e-mail in error or wish to
read our
e-mail disclaimer statement and monitoring policy, please refer to 
http://www.dresdnerkleinwort.com/disc/email/ or contact the sender. 
------------------------------------------------------------------------
--------


_______________________________________________
Veritas-bu maillist  -  Veritas-bu at mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu