[mythtv-users] Email notifier of recorded shows

[Josh Burks]

 > mysql -u mythtv -pyourpw -e "select title, subtitle, description,
 > starttime, CONCAT(hour(endtime-starttime), ':',
 > minute(endtime-starttime)) length, channum, callsign from recorded r,
 > channel c where r.chanid = c.chanid AND DATE_SUB(CURDATE(),INTERVAL 24
 > HOUR) <= starttime;" mythconverg

add this to the end of that command:

| mail -s "Recorded by MythTV" your_email at your_domain.com

It's raw data straight out of the db, oh and sendmail has to be running.

Almost all you need in a one-liner.

Josh Burks



Adam Lewandowski wrote:
> This isn't exactly what you're looking for, but here's a quick mysql 
> query command that will return all of the shows recorded in the last 24 
> hours. It could be run as a cron job for a pretty crude report.
> Obviously, use your own mythtv database user id and password.
> 
> mysql -u mythtv -pyourpw -e "select title, subtitle, description, 
> starttime, CONCAT(hour(endtime-starttime), ':', 
> minute(endtime-starttime)) length, channum, callsign from recorded r,
> channel c where r.chanid = c.chanid AND DATE_SUB(CURDATE(),INTERVAL 24 
> HOUR) <= starttime;" mythconverg
> 
> 
> 
> Tim Ahpee wrote:
> 
>> Hi All,
>>
>> I've had a look through the mailing list archives and also thrown a few
>> queries at Google but haven't yeilded anything.
>>
>> What I'm after is a script that will send me a mail once a day with 
>> what shows
>> have been recorded, what are to be recoreded etc. Does one exist? If 
>> not I
>> might be off to write one.
>>
>> Thanks in advance,
>>
>> Tim
>>  
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>  
>>
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users