cancel
Showing results for 
Search instead for 
Did you mean: 

Media Utilization Report in Ops Center

gangasdhar
Level 2

I am new to Opscenter/Netbackup and would like to pull a media utilization report for the last 1 or 3 months. The report should have the following consolidated details:

Master Server Name - Media Backedup- Media Available

I tried digging into Opscenter in using report templates and customizing it, but couldnt get what I wanted. Appreciate if someone can help me in this.

Regards,

Gangs

1 ACCEPTED SOLUTION

Accepted Solutions

MilesVScott
Level 6
Certified

This should do the trick:

 

SELECT dms.networkName
        , SUM(bytesWritten) AS 'B Written'
        , SUM(bytesWritten)/1042 AS 'kB Written'
        , SUM(bytesWritten)/1048576 AS 'MB Written'
        , SUM(bytesWritten)/1073741824 AS 'GB Written'
        , SUM(bytesWritten)/1099511627776 AS 'TB Written'
FROM domain_JobArchive ja
INNER JOIN domain_MasterServer dms
ON ja.masterServerId = dms.id
WHERE storageUnitType = 2
GROUP BY dms.networkName
 

View solution in original post

5 REPLIES 5

MilesVScott
Level 6
Certified

When you say "Media Backedup", are you refering to full Media or something else?

MilesVScott
Level 6
Certified

If you have OpsCenter Analytics this might do the trick:

 

SELECT    ms.networkName
        , dm.id
        , lms.name
        , dm.totalCapacity
        , dm.usedCapacity
        , CASE (dm.usedCapacity / dm.totalCapacity) 
            WHEN 1 THEN 'FULL' 
            WHEN 0 THEN 'AVAILABLE'
            END
FROM domain_Media dm
INNER JOIN lookup_MediaStatus lms
ON dm.status = lms.id
INNER JOIN domain_MasterServer ms
ON dm.masterServerId = ms.id
 

gangasdhar
Level 2

HI Scott,

Thanks for your reply.

I believe, I am not clear in my first post. The report that I am looking for is a consolidated report of how much media in (GB/TB/PB) has been used for a given date range for the entire master Server. We have several master servers on which this needs to be run using Opscenter Analystics. This will help us in planning our capacity for the future needs

FOr Eg:

Masterservername      Total Amount of media used (GB)

Master1                               100000

Master2                                500000

....

I am looking for a report which is something of this sort. There is a report template under capacity planning, but that doesnt generate Master Server wise. Can you please help.

MilesVScott
Level 6
Certified

This should do the trick:

 

SELECT dms.networkName
        , SUM(bytesWritten) AS 'B Written'
        , SUM(bytesWritten)/1042 AS 'kB Written'
        , SUM(bytesWritten)/1048576 AS 'MB Written'
        , SUM(bytesWritten)/1073741824 AS 'GB Written'
        , SUM(bytesWritten)/1099511627776 AS 'TB Written'
FROM domain_JobArchive ja
INNER JOIN domain_MasterServer dms
ON ja.masterServerId = dms.id
WHERE storageUnitType = 2
GROUP BY dms.networkName
 

MilesVScott
Level 6
Certified

Did that query get what you needed? Or was there something missing?