Forum Discussion

George_Dicu's avatar
George_Dicu
Level 4
10 years ago

OpsCenter 7.6.0.4 Report based on Retention Level

Hi,

So I got this 5 pictures.Basicaly I want to create a report with no time bassis on retention level.

I want it to show me  Client Name, Policy name,  Job protected size, Retention Level, Retention Period of the jobs only wiht a retention of >45 days.

Simple right? see how I got retention level setted up in host properties(the interval, see picture 1) and add condition in the report.

 

If the retention level is low than 45 days which in term of Opscenter mean Retention Level = interval(0,3) in my case (picture 1 + picture 2) with some simple columns like in picture 3 but I got no results.

If I remove the condition Retention Level, and add  time bassis like: 45 day before(picture 4+picture 5), I got data, but if I want to add Retention Level condition and play with it I get nothig, why? what i`ve done wrong?

Any info you need to figure this out?

And what the heck mens retention level -1, No retention? :))) expired? or can I set up a schedule without retention period?

//George

 

Backup and Recovery
Configuring
Error messages
Features
OpsCenter
Rules
Tip-How to
Training
Troubleshooting
Windows Server (2003-2008)
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    Level 6
    10 years ago

    Hi,

     

    Try this SQL Query.

     

    SELECT
    domain_image.policyname as "Policy Name",
    domain_image.sizeOfImageInKBytes as "Protected Size",
    domain_imagecopy.retentionLevel as "Retention Level",
    nb_retentionLevel.Label as "Unit",
    domain_jobimage.clientName as "Client Name"
    FROM
    domain_image, domain_jobimage, domain_imagecopy, nb_retentionLevel
    WHERE
    domain_jobimage.imageid=domain_image.id
    AND
    domain_jobimage.imageid=domain_imagecopy.imageid
    AND
    nb_RetentionLevel.id=domain_imagecopy.retentionLevel