Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: MythTV: Users

SQL Query for encoder status

 

 

MythTV users RSS feed   Index | Next | Previous | View Threaded


philledwards at gmail

May 31, 2005, 8:13 AM

Post #1 of 2 (956 views)
Permalink
SQL Query for encoder status

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
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


carlfongheiser at gmail

May 31, 2005, 8:28 AM

Post #2 of 2 (844 views)
Permalink
Re: SQL Query for encoder status [In reply to]

On 5/31/05, Phill Edwards <philledwards[at]gmail.com> wrote:
> 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.

You might find it easier to grab the XML from the backend's HTTP
server at http://backendhost:6544/xml. It's pretty easy to parse, and
you don't need to go rooting through a lot of tables.

Carl Fongheiser
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

MythTV users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.