cravenl

Query data behind BO CMC Report History

Discussion created by cravenl on Nov 3, 2011
Latest reply on Nov 10, 2011 by Chris_Hackett
Greetings,

On our account, we are trying to get an idea of how often reports are being run and who is running them. I know you can see the history on the CMC but that it at an individual report level. We are executing standard reports as well as custom reports. I have tried the below SQL but that is not giving me the results for all of our reports. Is there a way to get the history for all reports?

Select sj.name, sr.first_name || ' ' || sr.last_name, count(*)
from cmn_sch_job_runs sjr
join cmn_sch_jobs sj on sj.id = sjr.job_id
join srm_resources sr on sr.user_id = sjr.user_id
where sjr.user_id <> 1
group by sj.name, sr.first_name || ' ' || sr.last_name

Thanks,

Lisa

Outcomes