02-05-2015 05:14 AM
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
Solved! Go to Solution.
02-12-2015 02:24 AM
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'
02-10-2015 10:41 PM
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.
02-11-2015 04:26 AM
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
02-11-2015 11:09 PM
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.
02-12-2015 01:30 AM
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)
02-12-2015 02:03 AM
Thank you Riaan, I had a doubt, hence advised to open a support case.
02-12-2015 02:24 AM
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'
02-13-2015 06:08 AM
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'
02-13-2015 07:54 AM
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
02-16-2015 09:17 PM
Hi Sid,
Did that help?