Like most of you I have found it somewhat frustrating that Ops-Center does not come with a Proper Media Used report.
The Media used report is a particular type of report that is very useful if not invaluable, when informing the operation teams w...
Check out my blogg at https://www-secure.symantec.com/connect/blogs/creating-media-usage-reports I think this is what you are looking for if not PM me and I will send you a list of tables, views and procedure for use with the custom SQL querys.
Check out my blogg on Media reports at https://www-secure.symantec.com/connect/blogs/creating-media-usage-reports
PM me If you would like me to send you a list of tables, views or procedures.