Opscenter SQL query All scheduler + policies

[r4mzeso]

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?

[CeyhunBayraksan]

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

[Ravi_Kasturi]

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