Forum Discussion

ctorkington-cra's avatar
12 years ago
Solved

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

     

2 Replies

  • 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

     

  • 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