OpsCenter 7.6.0.4 Report based on Retention Level

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