Hi,
I am trying to retrieve some stats on number of times reports have been run and the last run time of reports from the repository. My current query returns last saved date of the webi reports but I’m unable to see where I can get the other bits. Note: I have no tables in the repository that begin with OBJ_A.
My current query is as follows:
SELECT
OBJ_M_DOCATVAR.M_SRC_C_NAME,
OBJ_M_DOCUMENTS.M_DOC_N_ID,
OBJ_M_DOCATVAR.M_DOCATV_C_DPNAME,
MD_DOCUMENTS.M_DOC_C_NAME,
MD_DOCUMENTS.M_DOC_N_TYPE,
MD_DOCUMENTS.M_DOC_N_PERSISTENT,
to_date(‘15-dec-1970’,‘dd-mon-yyyy’)+(max(MD_DOCUMENTS.M_DOC_N_LAD) / 86400) Latest_Saved_date
FROM
OBJ_M_DOCATVAR,
OBJ_M_DOCUMENTS,
OBJ_M_DOCUMENTS MD_DOCUMENTS
WHERE
( MD_DOCUMENTS.M_DOC_N_ID=OBJ_M_DOCATVAR.M_DOC_N_ID(+) )
AND ( OBJ_M_DOCATVAR.M_DOC_N_ID=OBJ_M_DOCUMENTS.M_DOC_N_ID )
AND ( OBJ_M_DOCUMENTS.M_DOC_N_LAT!=1 )
and MD_DOCUMENTS.M_DOC_N_PERSISTENT = 1
group by OBJ_M_DOCATVAR.M_SRC_C_NAME, OBJ_M_DOCUMENTS.M_DOC_N_ID, MD_DOCUMENTS.M_DOC_C_NAME, OBJ_M_DOCATVAR.M_DOCATV_C_DPNAME, MD_DOCUMENTS.M_DOC_N_TYPE,
MD_DOCUMENTS.M_DOC_N_PERSISTENT
order by MD_DOCUMENTS.M_DOC_C_NAME
Thanks in advance,
Brian
Sandman (BOB member since 2006-07-26)