Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Client/Policy/Schedule report

Created: 10 Jul 2012 | 5 comments

Hello,

Is there a way to create a report showing all clients, their backup policy, and the policy's corresponding schedules via Opcenter 7.5?  Thanks.

Discussion Filed Under:

Comments 5 CommentsJump to latest comment

RonCaplinger's picture

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.

rsbst19's picture

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

vedara's picture

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. 

AttachmentSize
Policy List Parser_0.txt 156 KB
Zenshai's picture

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
cengizanil's picture
Hello,
Same select, differnt not joined to lookup_PolicyType
Thanks
 
 
select 
ClientHostname,FileList,ClientOS,PolicyName,PolicyTypeName,ScheduleName, ScheduleTypeName
from nom_NBPolicy p
where p.policystatus=0
and p.Active=1