BusinessObjects Board

BO Audit Stats against Repository for BO 6.5.4 SP4

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 :ireland: (BOB member since 2006-07-26)

To get that information you will need the audit data: obj_a_event_log and obj_a_event_detl. If those tables are missing, then auditing is not enabled.

Joe


joepeters :us: (BOB member since 2002-08-29)

Hi Joe,
Thanks for your feedback. Do you recall how to turn this on?
If I was to turn user activity log on(from Admin Console) would this create these tables for me?
Many thanks,
Brian.


Sandman :ireland: (BOB member since 2006-07-26)

In the Admin Console, yes. That’s going back a ways, but I believe just turning on the User Log and System Log will do it.


joepeters :us: (BOB member since 2002-08-29)