Admit it, Netbackup Java Console can’t do everything. Assuming you know which backup policy with what client.

In this example, I am looking for client which belong to “MS-SQL-Server” policy, there are some other type like “Standard” , “Oracle”, “MS-Windows”, “NDMP”….etc

If your master server is a SUN OS, then modify the code below to grep “Client/HW/OS/Pri/DMI” .

#!/bin/bash
cli_path="/usr/openv/netbackup/bin/admincmd"
for POLICY in `$cli_path/bppllist`
do
   TYPE=`$cli_path/bppllist $POLICY -L | grep "Policy Type" | awk '{print $3}'`
   if [ "$TYPE" = "MS-SQL-Server" ]
   then
   echo "POLICY: $POLICY  TYPE: $TYPE "
   for HOSTNAME in `$cli_path/bppllist $POLICY -L | grep "Client/HW/OS/Pri/DMI/CIT" | awk '{print $2}'`
      do
      echo "----"$HOSTNAME
      done
    fi
done

Expected output:

POLICY: GLOBAL-EV-SQL  TYPE: MS-SQL-Server
----SERVERSQL01
POLICY: GLOBAL-PRD-PP  TYPE: MS-SQL-Server
----SERVERSQL02
POLICY: GLOBAL-PRD-PP1  TYPE: MS-SQL-Server
----SERVERSQL03