I believe if you just type: <br><br>$ mythbackend --printexpire<br><br>it will give a list of programs and the date/time they're eligible to be expired. <br><br><div><span class="gmail_quote">On 5/15/06, <b class="gmail_sendername">
Phill Edwards</b> <<a href="mailto:philledwards@gmail.com">philledwards@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
> I suspect some of my TV shows have automatically expired to make space<br>> for New recordings is there a method to report on programs which HAVE<br>> expired or will soon expire based on current recording schedule so I can
<br>> take preventative action.<br>><br>> I know these are listed in information page but I don't visit this page<br>> on a daily basis, but is there a simple SQL or script I can run to<br>> report the on above criteria?
<br><br>You could do something like this:<br><br>$ grep "autoexpire:" /var/log/mythtv/mythbackend.log<br><br>which give this output:<br><snip><br>2006-05-14 20:30:37.981 autoexpire: Expiring Program: Expiring:
<br>Swordfish Sat May 6 21:30:00 2006 2824 MBytes<br>2006-05-15 00:55:46.852 autoexpire: Expiring Program: Expiring: Cecil<br>B. DeMille: American Epic Sun May 7 15:00:00 2006 1228 MBytes<br>2006-05-15 01:20:47.624 autoexpire: Expiring Program: Expiring: At the
<br>Movies Sun May 7 18:00:00 2006 664 MBytes<br>2006-05-15 01:30:48.043 autoexpire: Expiring Program: Expiring: Big<br>Brother Sun May 7 18:30:00 2006 1377 MBytes<br>2006-05-15 02:15:50.037 autoexpire: Expiring Program: Expiring: Lost
<br>Worlds Sun May 7 19:30:00 2006 1140 MBytes<br>2006-05-15 02:55:51.808 autoexpire: Expiring Program: Expiring: The<br>League of Extraordinary Gentlemen Sun May 7 20:30:00 2006 2640 MBytes<br></snip><br><br>and then email it to yourself. You could use cut or awk or perl to
<br>pretty it all up a bit.<br><br>Regards,<br>Phill<br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></div><br>