OPSCenter - custom report for Oracle backups

[mrmadej]

Hi,

I am looking for solution how to prepare the report for backups of Oracle databases.
I need the report which will have the columns:

PolicyName | AvgWrittenSize | ClientName | MediaServerName | AvgTimeDuration

I can get AvgTimeDuration based on data in OPSCenter in the easy way. The job which fires the rest of the jobs (RMAN channels) should not has less than all jobs toghether. So this is simple.

But I have a big problem with size written. All channels generate another image with another timestamp and JodID. There are no common ParentJobId for all job which was fired by the main job. All jobs have as ParentJobId their own JobId. So I can't sum the size for all jobs with specific ParentJobId.

Maybe someone have something ready or idea how to solve my problem?

I am not very familiar with SQL but I can have a support from someone.

I attached sample which is the piece of result of:

select * from domain_Job where domain_Job.policyType='4'

You can see the JobId and ParentJobId. I don't know how to match the child jobs with parent job.

Regards

Madej

[mrmadej]

I spend few days on analyzing the data from OPSC database and I can't find the possibility to prepare report like this.

There is no way to aggregate rows which belong to the same parent job.

If someone know how to achive this goal it would be great.

Maybe the support request will be good idea?

Regards

Madej