My data just looks plain wrong!
I went down this route as you sugested. Selected Distinct Media Id stacked bar for my Y Axis; then selected Backup Media Allocation Time for my X Axis; grouped by 1 day with a timeframe of 1 month.
I then filtered Backup Media based on the "scratch" volume pool name.
When I run the report the counts are just plain wrong!
I'm not sure which time frame to use; according to the definition I have; Backup Media Allocation Time is the date/time that a piece of media was first allocated or had it's first backup written to it. Once the media expires it will have a new allocation date/time when it is resued. Thus, as a scratch tape this is not the write timeframe to use.
Backup Media Expiration Time and Physical Expiration Time produce zero results.
There doesn't appear to be a time based record that I can select that is appropriate for a scratch tape or is there?