Vault Reporting

[Sid1987]

Hi Techiz,

  I am trying to look for an automated vaulting report for a month. Means how many and what all medias were ejected for an entire month. I tried looking into opscenter, there is only one report for vault which just tells the count. Then I looked into Opscenter tables, I could only find tables like nom_NBJob and nom_NBVolume which could give me few information.

I am looking for a report for a month containing columns Date on which offsiting was done(can be found in nom_NBVolume), number of tapes vaulted, mediaid of the tapes vaulted, expiration date of the media(domain_Media), mediaid of medias which are expired on that date as per vault.

Thanks

Sid

[Ananya_Bhattach]

Hi Sid,

Which version of NetBackup are you using?

Here are the links to Symantec OpsCenter 7.5 Reporting Guide and Symantec NetBackup OpsCenter 7.6 Reporting Guide These guides list the various reports that can be run using the OpsCenter. 

Let us know if it helps.

[Sid1987]

Hi Ananya,

  Thanks for the reply. My opscenter is at 7.6.0.3. I have checked all the report templates there aren't any report which would provide me the details I am looking for.

I am looking for a monthly report containing columns Date on which offsiting was done(can be found in nom_NBVolume), number of tapes vaulted, mediaid of the tapes vaulted, expiration date of the media(domain_Media), mediaid of medias which are expired on that date as per vault.

Thanks

Sid

[Ananya_Bhattach]

I do not think we can create reports outside the one's predefined by Opscenter. You can log a formal support case to confirm this.

[RiaanBadenhorst]

Ananya, you can create custom SQL queries using the OpsCenter interface.

Sid, I'll take a look at this and get back to you (don't have any vaulting configured now)

[Ananya_Bhattach]

Thank you Riaan, I had a doubt, hence advised to open a support case.

[RiaanBadenhorst · Accepted solution]

Hi Sid

Try this (change the dates as required). [Keep in mind I don't have vault configured so I"m guessing what the result would be :) ]

select nom_nbvolume.mediaid as "Media ID", UTCBigIntToNomTime(nom_nbvolume.DateVaulted) as "Vaulted Date", UTCBigIntToNomTime(nom_nbvolume.ExpirationDate) as "Expiration Date", UTCBigIntToNomTime(nom_nbvolume.ReturnDate) as "Return Date"
from nom_nbvolume
where UTCBigIntToNomTime(nom_nbvolume.DateVaulted) between 'Feb 12, 2015 12:00:00 AM' and 'Feb 13, 2015 12:00:00 AM'

[Sid1987]

Hi Riaan,

  Thanks for your response, we are close. I changed the query a bit as expiration date wasn't coming up from nom_nbvolume table. One further request would be can it be generated for 30 days or for a month so? Not by specifying start and end date of the month.

Would below work, I didn't try though.

DATEDIFF(day,UTCBigIntToNomTime(DJ.startTime),GETDATE())>=30

select 
nom_nbvolume.mediaid as "Media ID",
UTCBigIntToNomTime(nom_nbvolume.DateVaulted) as "Vaulted Date", 
UTCBigIntToNomTime(domain_media.expirationTime) as "Expiration Date",
domain_media.usedCapacity/1024/1024/1024 as "Used Capacity in GB"
FROM
nom_nbvolume, domain_media
WHERE nom_nbvolume.barcode=domain_media.barcode
AND UTCBigIntToNomTime(nom_nbvolume.DateVaulted) between 'Feb 11, 2015 12:00:00 AM' and 'Feb 12, 2015 12:00:00 AM' 

[RiaanBadenhorst]

Nice, I noticed that but thought it might just be something on my test system

Use this for AND instead

AND DATEDIFF(day,UTCBigIntToNomTime(nom_nbvolume.DateVaulted), GETDATE()) <= 30

[RiaanBadenhorst]

Hi Sid,

Did that help?