Sid1987
10 years agoLevel 6
Vault Reporting
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 on...
- 10 years ago
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'