I think you will need to query the DB to get that information. You can only query the views provided but I would have thought that information would be available. I am unable to check at the moment but I would try querying the following views to see if you can get what you need.
vw_DPM_Media
vw_DPM_TapeStat
Hope that helps.
David