Clients by policy:

bppllist -allpolicies | awk '$1=="CLASS" {print "Policy: " $2} ;
$1=="CLIENT" {print "  " $2}'

For the other thing, making sure everything is covered, Netbackup cannot
know if there's a database on the server so no command is going to indicate
that.

The closest thing is the "bpcoverage -c <client>" that'll let you know if
any filesystems/drive letters are being skipped.

A neat reverse, policies by client can be done with this little script:

#!/bin/ksh
PATH=$PATH:/usr/openv/netbackup/bin:/usr/openv/netbackup/bin/admincmd
for c in `bpplclients -allunique -noheader|awk '{print $3}'|sort|uniq`
do
  bppllist -byclient $c|\
      awk 'NR==1 && $1=="CLASS" {printf "%20s\t%s\n","'$c'",$2}
           NR>1  && $1=="CLASS" {printf "%20s\t%s\n"," ",$2}'
  echo
done

If you know what your SQL servers are, you can see if there's more than one
policy serving it.

HTH - Mark

 
 -----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]On Behalf Of
Steve.Bally AT radisys DOT com
Sent: Thursday, October 27, 2005 9:44 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Client list to Policy / Class report


All,
 
I am trying to audit the policies in my environment, and need to get a
listing of what clients are in what policy, and compare that with the
current list of servers.  Is there a command that can output the data that I
need.
 
Basically if a client is a Windows box and has a SQL database on it, I want
to make sure that the OS and the DB are being backed up.
 
Regards, 
 
Steve Bally
Systems Engineer
RadiSys Corporation
www.radisys.com
steve.bally AT radisys DOT com
Desk: 503-615-1207 
Cell: 503-970-6201
 
This electronic message (Email) contains information which may be
confidential, privileged or otherwise protected from disclosure. The
information is intended to be used solely by the named recipient(s). If you
are not a named recipient, any review, disclosure, copying, distribution or
use of this transmission or its contents is prohibited. If you have received
this transmission (Email) in error, please notify me immediately.