Need help with CSP Query Builder syntax

[rorymo]

Hi,
I am trying to query the CE(9) database using the
CSP query builder.
What I want to obtain is the report name, when the report
was last run and the user who ran it.

Here is the query I have so far:
Select SI_NAME, SI_USERFULLNAME
FROM
CI_SYSTEMOBJECTS
Where SI_PROGID='CrystalEnterprise.User'

I need to know how to include the SI_PROGID 'CrystalEnterprise.Report'

Also, I need to know which field to query to give the
last "on demand" run time, not the "last scheduled" run time, since most of our reports are on demand.

Thanks in advance for any help.
Rory