cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Media Utilization Report in Ops Center

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 Solution

Accepted Solutions
Highlighted
Accepted Solution!

This should do the

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
Highlighted

When you say "Media

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

Highlighted

If you have OpsCenter

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
 
Highlighted

HI Scott, Thanks for your

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.

Highlighted
Accepted Solution!

This should do the

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

Highlighted

Did that query get what you

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