Clients in active policies only.
 
#!/bin/ksh
PATH=$PATH:/usr/openv/netbackup/bin/admincmd
 
activeclients () {
bppllist -allpolicies | awk '$1=="CLASS" {pl=$2;set=0}
                             $1=="INFO" && $12==0 {set=1}
                             $1=="CLIENT" && set==1 {print $2}' | sort
-u
}
 
for client in `activeclients`
do
  echo "$client:\c"
  bppllist -byclient $client | awk '$1=="CLASS" {printf("%s ",$2)}'
  echo ""
done


________________________________

From: Sto Rage(c) [mailto:netbacker at gmail.com] 
Sent: Thursday, July 20, 2006 6:14 PM
To: Donaldson, Mark - Broomfield, CO
Subject: Re: [Veritas-bu] Generating list of all active clients !!


and what would the smal tweak be?
thanks for the script BTW.
-G


On 7/20/06, Mark.Donaldson at cexp.com < Mark.Donaldson at cexp.com> wrote: 

        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
<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
        
        _______________________________________________
        Veritas-bu maillist  -  Veritas-bu at mailman.eng.auburn.edu
<mailto:Veritas-bu at mailman.eng.auburn.edu> 
        http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu