none
vw_DPM_Media no longer shows all tapes RRS feed

  • Question

  • We have a DPM 2012R2 server with tape backup.  Sometime around the RU5 update vw_DPM_Media stopped showing newly-written tapes.  We use vw_DPM_Media to prompt backup managers to bring tapes back on site when they expire.  I have 10 tapes in circulation, but vw_DPM_Media shows only five. 

    Running the following query correctly shows all 10 tapes:

    SELECT
    	BarcodeValue,
    	EarliestExpiryDate   = MIN(ExpiryDate),
    	LatestExpiryDate     = MAX(ExpiryDate),
    	EarliestCreationDate = MIN(CreationDate),
    	LatestCreationDate     = MAX(CreationDate)
    FROM
    	tbl_MM_Media
    	join
    	tbl_MM_MediaMap
    	on tbl_MM_Media.MediaId=tbl_MM_MediaMap.MediaId
    	join
    	tbl_MM_PhysicalDataset
    	on tbl_MM_MediaMap.DatasetId=tbl_MM_PhysicalDataset.DatasetId
    GROUP BY
    	BarcodeValue,tbl_MM_Media.MediaId
    ORDER BY
    	LatestExpiryDate

    I can also use the "Recovery" features of the GUI to find tapes not listed by vw_DPM_Media.

    This TechNet article indicates that vw_DPM_Media should contain "Information about state of all tapes known to DPM." 

    Is there someone running UR5 who can confirm whether vw_DPM_Media is working correctly on their installation?

    Thanks for your help,

    Alex

    Monday, March 9, 2015 11:01 PM

All replies