Help finding table that holds hostname of netbackup clients

[Backup_Man]

Hi

I have recently implemented VBR in our environment and now im looking to customise for our environment porta;. Im looking to produce a report that lists all clients there backup speeds for the previous night. Im stuggling to find the table that holds the list of clients hostanmes

using interactive SQL, i run the following query:

SELECT objectPrimaryDisplayName
FROM "ccsvc"."Object"

This is where i think the server names are held but running the query, the objectPrimaryDisplayName columns also contain information relating to sample reports. So im thinking im in the wrong place

Can anyone help me out??

[payners]

use backupfinaljobclientobjectid=objectid in your where clause.

Now when you call objectprimarydisplayname it will be the host name. If you want to also report master and media server name you can add the following:



from

object as clientobject,
object as mediaobject,
object as masterobject

where

backupfinaljobclientobjectid=clientobject.objectid and
backupfinaljobmasterserverobjectid=masterobject.objectid and
backupfinaljobmediaserverobejctid=object.objectid



You would call these like so:

clientobject.objectprimarydisplayname

mediaobject.objectprimarydisplayname

masterobject.objectprimarydisplayname