locked
Missing tapes in DPM 2010 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have 33 tapes showing as free in the tape utilization report. The problem is I don't which 33 tapes they are. I know I have tapes in the library marked as free right now, but not 33 of them.

    Usually I use the tape management report overdue tapes area to chose the tapes to move back into the library out of our vault. My concern is that tapes that have never been written to will never show as overdue.

    How can I get a list of the tapes that DPM has marked as free? It would also be nice to get a list of all of the tapes that DPM is aware of and the protection group data that is known to exist on those tapes (preferably without having to catalog/load them in the library).

    Friday, May 27, 2011 8:18 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    You can use this SQL script to list all tapes BarCodes and slot number that are in the free media pool

    Use dpmdb
    select mm.BarcodeValue, MM.SlotNum, mp.Name from dbo.tbl_MM_Media MM
    join dbo.tbl_MM_Global_ArchiveMedia gar
    on MM.GlobalMediaId = gar.MediaId
    join dbo.tbl_MM_MediaPool mp
    on mp.GlobalMediaPoolId = gar.MediaPoolId
    Where mp.Name = 'Free Media Pool'
    -- Slotnum is Zero based - NULL means it's not in the library.

    Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, May 31, 2011 4:34 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I cannot account for the number of free tapes on the report being greater than the actual number, however, only tapes that DPM has written to will show up in the tape management report.  I would basically ignore the free tapes section from a tape management perspective.

    For the tape list and details issue, I think this http://cid-b03306b628ab886f.office.live.com/self.aspx/.Public/DPMjobs-v3.0.zip will help you.  It's only good for last 30 days since that is the history window for previous jobs.  So you would need to run it once a month to keep long term tape usage history.

    Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Saturday, May 28, 2011 8:27 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thank you, I've seen that script and was hoping for a more complete result.

    We can load all of the tapes into the library and do a fast inventory to identify tapes that are free, then we will be sure to use those tapes first before any overdue tapes. After we've worked through the stack of free tapes we can go back to using the overdue tapes area to determine the tapes to load.

    Let me know if this plan seems flawed.

    Monday, May 30, 2011 1:42 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    You can use this SQL script to list all tapes BarCodes and slot number that are in the free media pool

    Use dpmdb
    select mm.BarcodeValue, MM.SlotNum, mp.Name from dbo.tbl_MM_Media MM
    join dbo.tbl_MM_Global_ArchiveMedia gar
    on MM.GlobalMediaId = gar.MediaId
    join dbo.tbl_MM_MediaPool mp
    on mp.GlobalMediaPoolId = gar.MediaPoolId
    Where mp.Name = 'Free Media Pool'
    -- Slotnum is Zero based - NULL means it's not in the library.

    Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, May 31, 2011 4:34 PM