Query Builder 2

[Edie0802]

I would like to use the Query Builder to pull a list of reports that have failed. I know the status = 3, but don't know the rest of the query. I am unable to use the Instance Manager. Instance Manager appears to be corrupt.

Thanks.

 

[jedownsjr]

select * from ci_infoobjects where si_schedule_status='3'


If you want less output, try just the basic properties:

select si_id, si_name from ci_infoobjects where si_schedule_status='3'

 

[Edie0802]

thank you very much! that is exactly what I needed.