cancel
Showing results for 
Search instead for 
Did you mean: 

OpsCenter 7.6.0.4 Report based on Retention Level

George_Dicu
Level 4

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

 

2 REPLIES 2

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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

paulo_trindade
Level 1
Partner Accredited

Yes, it is ok to me!