Is there an sql query to make "backup selections" in Netbackup a filterable selection when creating a custom report?

[ebrebr]

Hi all, I basically need to be able to enter a parameter when creating a custom report to allow "backup selection" to be filtered on.

It's the only common factor for the list of policies for this intended report.

Thanks in advance!

[payners]

first off you have to have breakup jobs enabled for that module...


then just use the following in a query:


select

directoryobject.objectprimarydisplayname as 'Backup Selection'

from

backupsubjob,
object as directoryobject

where

backupsubjobdirectoryobject=directoryobject.objectid