Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Extract SI_Runtime duration through Query Builder?

Hi All,


Using query builder we are using the following query find reports run between

a set of dates using :-

select SI_NAME, SI_OWNER, SI_AUTHOR, SI_SCHEDULEINFO.SI_STARTTIME from

CI_INFOOBJECTS where SI_SCHEDULEINFO.SI_OUTCOME<2 and

SI_SCHEDULEINFO.SI_STARTTIME>='2013.10.21 04.00.00'

and SI_SCHEDULEINFO.SI_STARTTIME<='2013.10.21 09.00.00'

order by SI_SCHEDULEINFO.SI_STARTTIME

What we need, is the Runtime duration added to this. Is it possible to get this Information from Query Builder?

Regards,
Sandeep

Former Member
Not what you were looking for? View more on this topic or Ask a question