DPM2010 - Identifying expired/Unused offsite tapes RRS feed

  • Question

  • We renamed/reshuffled 6 protection groups down to 2 before the end of last year to take better advantage of Co-Location. I suspect that I have a lot of unused tapes that are now offsite and stranded there.

    I am showing 44 entries in  vw_DPM_Media (all looking like recognizable entries), and 88 entries in tbl_MM_Media.
    Are the 44 extra entries in tbl_MM_Media tapes that I can bring back as free tapes?  

    Can I use the following to identify expired tapes that have "slipped off the edge" during our PG shuffle, and safely return them to use?:

    SELECT BarcodeValue, Label, Location
    FROM tbl_MM_Media WHERE BarcodeValue NOT IN 
    (SELECT MediaBarcode FROM vw_DPM_Media)
    ORDER BY BarcodeValue

    I see this also identifies my free,expired tapes on site here (Location=1) which is a good thing, but I also am showing a couple tapes that have been in the drive apparently doing nothing for a long time.  It's 37 tapes I can't otherwise account for, so I'd like to start working through those before putting brand new tapes into my library to get eaten as free tapes.



    Tuesday, May 14, 2013 6:00 PM


  • Closing for housekeeping.

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, June 26, 2013 5:08 AM