Do you have usage tracking configured / enabled?
From memory have a look in there - I am fairly sure you can see the difference between a 'normal' user use of a report and the i-Bot equivalent.
And yes, you are correct there is also a table that holds the i-Bot data, in 10g it used to be nq_scheduler or something similar - not sure what it is now.
This might help you to know scheduled reports
SELECT NAME,USER_ID,LAST_RUNTIME_TS,NEXT_RUNTIME_TS FROM S_NQ_JOB
WHERE NEXT_RUNTIME_TS IS NOT NULL
If helps mark. Did you check my query?
Edited by: Srini VEERAVALLI on Mar 22, 2013 10:11 AM
Scratch that, S_NQ_JOB_PARAM doesn't contain the analysis reference, you're right.
Still, have a look at the SampleApp. I haven't gotten it up and running right now, but it does contain a huge load of such material under 9.31 - Webcat Analysis.
s_nq_job, s_nq_job_param - these tables from RCU schema will give you ibot/agent name and the path where it stored. There is no database table to extract delivery content.
you can extract delivery content using agent/ibot xml -> you may write shell script to extract the agent name, and referencing content.
hope this helps..
I just had a look into the SampleApp scripts and analyses and unfortunately the Agents aren't covered in there yet.
Manual alternative: Use catalog manager to create a report on all objects of type "Agent" to get the XMLs. Then check the saw:reportRef element which will contain the path and name of the analysis in the delivery content.