DPM2010 - Identifying expired/Unused offsite tapes

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.

Cheers,

May 14th, 2013 9:00pm
Closing for housekeeping.
Free Windows Admin Tool Kit Click here and download it now
June 26th, 2013 8:08am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics