[mythtv-users] SQL Query for encoder status

[Phill Edwards]

Does anyone know the SQL or which table(s) need to be queried to get
the encoder status as per what appears in mythweb on the "Backend
Status" page? Eg:

<snip>
Encoder status
Encoder 1 is local on elm.edwards.home and is recording: 'Coupling' on
ABC TV. This recording will end at 01:15 am.
Encoder 2 is local on elm.edwards.home and is not recording.
</snip>

I'd like to do a little shell script that queries the data and puts in
on screen at the press of a remote control button.

Regards,
Phill