cancel
Showing results for 
Search instead for 
Did you mean: 

Help with Opscenter backup size report

Dollypee
Moderator
Moderator
   VIP    Certified

Hello All,

Opscenter version : Analytic/version 7.7

I'm tasked to set up an opscenter report to generate backup sizes per application names. I have created a view  as each of the APP names & add each corresponding clients to there respective views. Now, at the moment - am only able to set up each report per view which means every morning I'll be sending out numerous report per views .

But my mangement want to have this report group together on a single report rather than sending out separately.

I need help with how to pull this off either by using query or opscenter conventional tamplate. Thank you

Here are the names of the views:

PeopleSoft
MDM
ECOM
DW
BMC
BI

Thank you all 

1 ACCEPTED SOLUTION

Accepted Solutions

areznik
Level 5

I think you're looking for something like this: 

select y.viewName as Application, round(sum((x.bytesWritten*1.0)/1024/1024/1024),2) as sumGB
from domain_JobArchive x,
    (SELECT distinct t.name as viewName, e.name as viewNode
    FROM view_tree t, view_node n, domain_Entity e
    where t.name in ('PeopleSoft','MDM','ECOM','DW','BMC','BI') 
    and t.id = n.treeId
    and n.entityId = e.id) y
where x.clientName = y.viewNode
and UTCBIGINTTONOMTIME(x.startTime) > getdate() - 1
and x.type = 0
group by y.viewName

 

I couldnt really test this properly as my OpsCenter only has one default view.  This is looking at the last 24hrs, backup jobs only (no snapshots, duplications or restores). 

 

Hope this helps

 

View solution in original post

2 REPLIES 2

areznik
Level 5

I think you're looking for something like this: 

select y.viewName as Application, round(sum((x.bytesWritten*1.0)/1024/1024/1024),2) as sumGB
from domain_JobArchive x,
    (SELECT distinct t.name as viewName, e.name as viewNode
    FROM view_tree t, view_node n, domain_Entity e
    where t.name in ('PeopleSoft','MDM','ECOM','DW','BMC','BI') 
    and t.id = n.treeId
    and n.entityId = e.id) y
where x.clientName = y.viewNode
and UTCBIGINTTONOMTIME(x.startTime) > getdate() - 1
and x.type = 0
group by y.viewName

 

I couldnt really test this properly as my OpsCenter only has one default view.  This is looking at the last 24hrs, backup jobs only (no snapshots, duplications or restores). 

 

Hope this helps

 

Dollypee
Moderator
Moderator
   VIP    Certified

Thank you Arenik, I will test this out shortly & get back to you. Thank you