Forum Discussion

r4mzeso's avatar
r4mzeso
Level 3
10 years ago

Opscenter SQL query All scheduler + policies

I have to make full report of whole netbackup env. One step is to make full list of schedulers which belongs to policies.

 

I need something like this

 

Policy name Type Schedule Type Daily   Weekly   Monthly  
      start time end time start time end time start time end time
policy1 standard Calendar 12:00 14:00 15:00 16:00 17:00 20:00

 

Is it possible to do sql query?

  • netbackup master server 

    bppllist -allpolicies -L -U -verbose | egrep '^(Policy Name|  HW/OS/Client|  Include|            |    Schedule|    Type|    Retention Level|      Sunday|      Monday|      Tuesday|      Wednesday|      Thursday|      Friday|      Saturday|          Sunday|          Monday|          Tuesday|          Wednesday|          Thursday|          Friday|          Saturday)' >allpolicies.txt

  • Hi, Any one can Suggest OPS center SQL Query for the above or else same command to execute in WINDOWS platform.