07-19-2013 08:33 AM
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
Solved! Go to Solution.
07-19-2013 07:05 PM
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
07-19-2013 07:05 PM
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
07-22-2013 01:36 AM
We use just a basic vltrun command so the closest template report that returned data was the Vault Media Usage but it was quite what I was after.
However the SQL script was perfect!
Thanks