Tabular Custom Report OpsCenter from Image Information
Hi Everyone!
We are using Netbackup 7.6.0.4 and OpsCenter 7.7.
We are working with custom report but we are having problems to create report. We need a report like BPIMAGELIST but using VIEWS, because there are many groups of clients that we need create these reports. I need client name and Total Job Protected Size or sizeInBytes from images.
We had to create a new OpsCenter so we don´t have history jobs only information from Images from catalog. I´m trying to create a report from images but OpsCenter does not show what I want from tabular custom report.
I am trying to create:
Custom Report > Tabular > No Time Basis / Image Copy Expiration Time or Image Expiration Time > Select Client Name and Job Protected Size.
Any help will be appreciated!
Thanks!
Regards,
Tominaga
Try this one. I added another VIEW (only had 1) and tested again. Each view has different amount of clients. Seems ok now.
select
domain_jobimage.clientname as "Client",
sum(domain_imagefragment.size) as "Size"
from view_node, view_tree, domain_jobimage, domain_imagefragment
where
view_node.treeid=view_tree.id
and
domain_jobimage.clientid=view_node.entityid
and
domain_jobimage.imageid=domain_imagefragment.imageid
and
view_tree.name like '%riaan%' and view_tree.type in (8)
group by
"Client"
