Forum Discussion

Sid1987's avatar
Sid1987
Level 6
10 years ago

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...
Backup and Recovery
OpsCenter
Reporting
Windows Server (2003-2008)
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    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'

     

RiaanBadenhorst's avatar
RiaanBadenhorst
Level 6
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'