01-07-2016 12:10 PM
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
Solved! Go to Solution.
01-07-2016 03:28 PM
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
01-07-2016 03:28 PM
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
01-21-2016 06:42 AM
Thank you Arenik, I will test this out shortly & get back to you. Thank you