XBMC Status

[bp_pbs]

Team, so I'm trying to get a status of all the information in my XBMC. Like movie count, album count, unwatched movie count, count of new movies , etc.
So I want to say "Vox give me XBMC Status | What's my XBMC Status for today"
Then I get a run down of all. Maybe have a pause in there where Vox ask me do I want to continue ( if she is giving me a lot of information)

I thought I could do this be querying Xsgl but I'm at a lost of how to retrieve it. Any Ideas?

[jitterjames]

I suggest you ask on the XBMC forum if there is a way to do this using json

[bp_pbs]

Ok I'll let you know how it goes. Thanks

[bp_pbs]

James can I ask you this while I'm waiting on XBMC people to respond to my forum. I have added sql code in Xsql. SO all results are in separate payloads. Is there a way I can get the results of each individual payload. I was thinking PayloadXML.GetValue but not sure how it works.

example
SELECT COUNT (idActor) as count FROM actors (Payload: xbmcActorsCount)

[bp_pbs]

Never-mind I think I figured it out