Search for printername in all reports

[ZedEnter]

Hi -

Using: CE10

I want to search for a printername associated to a report object.

This code:

SELECT SI_PROCESSINFO.SI_PRINTER_INFO FROM CI_INFOOBJECTS WHERE  SI_PROGID='CrystalEnterprise.Report'

will get me all the information I need, but how do I get the SI_NAME='printername' for a proper result collection involved?

Tried:

SELECT SI_PROCESSINFO.SI_PRINTER_INFO FROM CI_INFOOBJECTS WHERE SI_PROGID='CrystalEnterprise.Report' 
AND SI_PRINTERINFO.SI_NAME='printername'

but with no effect. All I get is nothing, though the printername exists and I can see it in the result collection of the Query Builder.

Greetz - Chris.