Listing Netbackup 6.5 database clients

[Thomas_Anthony]

Hello,

We are preparing for the 6.x to 7.x upgrade.

Is there a command, or series of commands, that can be run from the Master server command line to identify which of the the NBU clients are being backed by a NBU Database extension product ?  

Preferably, would like to extract the client name, the database backup type and the database version... Optionally, extract the policy for each database client

I thought of maybe trying script a solution... list the backup policies, egrep the backup policies to isolate polices using database types, then extract the client names from the listed database policies.  Then for database versions, maybe use the client names to search threoung the backup logs to get the database version.   Which commands would work best ?

Master: Solaris 10 w NBU 6.5

Clients: Windows 2003 & 2008 & XP & Solaris w NBU 6.x

Thanks,

Thomas 

[Marianne]

NetBackup has no knowledge of database versions on clients.

Policy info has Policy type and Client name.

You can use this command to list all clients for a given policy type:

bpplclients -allunique -pt <policy_type>

Some valid values for policy_type:
Informix-On-BAR
Lotus-Notes
MS-Exchange-Server
MS-SharePoint
MS-SQL-Server
NDMP
Oracle
Sybase
DB2
 

bpplclients -allunique -pt Oracle
Hardware         OS               Client
---------------  ---------------  --------------
Solaris          Solaris9         sundemo

We normally know what database agents are being used, therefore it won't be necessary to work through the entire list of policy types.