cancel
Showing results for 
Search instead for 
Did you mean: 

OpsCenter Report

ctorkington-cra
Level 3

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

 

1 ACCEPTED SOLUTION

Accepted Solutions

tom_sprouse
Level 6
Employee Accredited Certified

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

 

View solution in original post

2 REPLIES 2

tom_sprouse
Level 6
Employee Accredited Certified

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

 

ctorkington-cra
Level 3

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