Client/Policy/Schedule report

I've checked OCA 7.1.0.2 & 7.5.0.3, and they don't seem to produce any report like you are looking for.  However, the NBU command "bppllist -allpolicies -L" will produce the output you are looking for.

Thanks..that's what I was looking for..now for some way to make the info a little more palatable...

Hi

Please follow the below steps, as it will produce the detailed view of the policy attributes, schedules information in to an excel format.

1. Convert attached Policy List Parser_0.txt into Policy List Parser_0.exe 

2. Run following command to redirect entire policy details to a text file:

/usr/openv/netbackup/bin/admincmd/bppllist -allpolicies -U > /tmp/allpolicies.txt

3. Save the file on your desktop. e.g policy_output.txt

4. Run Policy List Parser_0.exe, Select  the input file e.g policy_output.txt and provide the destination file. 

5. You will get the detailed view of the policy details in excel format. 

Try this (tested on OpsCenter 7.1.0.2):

select distinct p.servername, 
                              p.policyname, 
                              l.name, 
                              p.clienthostname, 
                              p.filelist, 
                              p.ScheduleName, 
                              p.ScheduleTypeName
from nom_NBPolicy p, lookup_policyType l
where p.policystatus = 0
  and p.active = 1
  and l.id = p.policyType