Custom report for OpsCenter

[KBrygger]

Hi everyone.

Can anyone supply me with some help creating a custom report which contains a column with "days since last successfull backup"?

It must contain:

Date	Environment (Master Server)	Client name	Policy	Status code	Days since last successfull backup
xxx	xxx	xxx	xxx	xxx	xxx
xxx	xxx	xxx	xxx	xxx	xxx

My thoughts are that some SQL query has to dig into the DB and fetch the data, but I'm lacking knowledge. Anyone?

Regards

[Jean-Pierre_Bai]

You can get similar information from recovery Point Objective report, under template reports, Client reports, Risk Analysis. I would edit it to remove code 1 as well as code zeros.