OpsCenter Report
I'd like an OpsCenter report that is the equivalent of the eject.list file.
We have a daily Vault job and I would like to auto email from OpsCenter the list of media ejected that day so that the hands-on guys can double check what they are boxing and sending off-site. Possibly even include the report in the archive boxes.
I cant see a template report that does this.
Does anyone have a custom SQL script??
cheers
ctorkington-craven
Here is a SQL script, maybe a little unpolished, but it should work...
SELECT id AS "Media", utcbiginttoutctime(unixDateOffSiteSent) AS "Sent OffSite", utcbiginttoutctime(unixDateOffSiteReturn) AS "Return Date" FROM nb_media WHERE utcbiginttoutctime(unixDateOffSiteSent) > GETDATE() - 1
However, I highly recommend using the Vault Reports in NetBackup... you will want to send the Picking List report to the required recipients.
NetBackup 7.5 Vault Admin Guide - http://www.symantec.com/docs/DOC5192
page - 189
If you have any questions, please let me know.
-Tom