You sbould be getting error 41's from everyone that doesn't exist
anymore.

However, if you want to see all clients that have valid backups for some
time frame, use bpimagelist.  

bpimagelist -d <start date> | awk '$1=="IMAGE" {print $2}' | sort -u

you could diff this against the output of bpplclients and delete
everything that's not in both lists. 

-M

-----Original Message-----
From: Courteney, Jonathan
[mailto:Jonathan.Courteney at dresdnerkleinwort.com] 
Sent: Friday, July 21, 2006 12:15 AM
To: Donaldson, Mark - Broomfield, CO
Subject: RE: [Veritas-bu] Generating list of all active clients !!

Hi Mark

Thanks for your response, by active I mean currently backing up every
night. Over the last couple of years clients have been decommissioned,
renamed etc but have been left in the policies hence I want to remove
these and only migrate the clients which are being backed up at present.


Jon 

-----Original Message-----
From: Mark.Donaldson at cexp.com [mailto:Mark.Donaldson at cexp.com] 
Sent: 20 July 2006 19:01
To: Courteney, Jonathan; veritas-bu at mailman.eng.auburn.edu
Subject: RE: [Veritas-bu] Generating list of all active clients !!

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


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