[mythtv-users] List of recordings by disc drive

[Mike's JdJ]

I wonder if someone has already written a MySQL query to extract 
a list of recordings by disc drive?

When I am using Dolphin to manage a device, the file name 
appears to be a channel number plus a time stamp.  Having to 
play the video for minutes to identify the show/movie and 
episode is tedious.  It would be helpful to have a list that I 
could look up 1382_2012011303000.mpg and find that it is Back To 
The Future IV, or the Simpsons episode where Homer becomes 
intelligent.

The ideal query would extract a file with the:  device, file 
name, and the recording information (series name, episode 
title...).

I've been reluctant to write my own, as I'm concerned about 
unintentionally modifying the database.

Has anyone done this who would like to share it?  If not, maybe 
a hint about the tables to access and linkage?

Mike