[dwids]

Hi. I have Kodi on a Shield and also on a Laptop and RPi on a spare TV. I take the laptop away with me. I'm looking for a simple way to export - on any system - the Resume-Time of the TV Shows and Movies...as some sort of Report. This means i can manually check the Report so I can pick up on another Kodi system.

On a 4th box - Windows PC - I've got the basic SQL working, something like (for the last 14 days):

Code:

select lastPlayed, strTitle, c12 as s_, c13 as e_, c00 as 'epTitle', round(ResumeTimeInSeconds /60,2) as 'R T Mins', strFileName from episode_view
    where lastplayed >date('now','-14 day')
    order by datetime(lastPlayed)  desc;

Plus a batch file which invokes this SQL and converts it to HTML for saving to Dropbox.
Is there any way I can get Kodi per se to do this type of thing? Even just dumping the raw SQL output as plain text? Maybe a plug in?

Thanks.