SQL Query for Backup Exec 12 to check media for Report

I need to have the ability to query SQL on Backup Exec 2014 so that I can check that media Offline Tape Media. I have found tables [dbo].[Media]. 

Does anyone know of a way to find Offline Media Types ? 

Or I use the wrong table?