BusinessObjects Board

Audit report

general discussion
#1

Hi,

I am using a report to know who is using which report. The query is

SELECT 
decode(instr(OBJ_A_EVENT_DETL.A_EVDET_C_OBJNAME,'.'),0,OBJ_A_EVENT_DETL.A_EVDET_C_OBJNAME,substr(OBJ_A_EVENT_DETL.A_EVDET_C_OBJNAME,1,instr(OBJ_A_EVENT_DETL.A_EVDET_C_OBJNAME,'.')-1)), 
OBJ_A_OBJECT_TYPE.A_OTYPE_C_NAME, 
OBJ_A_EVENT_LOG.A_EVLOG_C_USER, 
OBJ_A_EVENT_NAME.A_EVNAM_C_NAME, 
OBJ_A_APPLICATION.A_APPLI_C_NAME, 
COUNT(OBJ_A_EVENT_LOG.A_EVLOG_N_TYPEID) 
FROM 
OBJ_A_EVENT_DETL, 
OBJ_A_OBJECT_TYPE, 
OBJ_A_EVENT_LOG, 
OBJ_A_EVENT_NAME, 
OBJ_A_APPLICATION 
WHERE 
( OBJ_A_EVENT_LOG.A_EVLOG_N_ID=OBJ_A_EVENT_DETL.A_EVDET_N_ID(+) ) 
AND ( OBJ_A_EVENT_LOG.A_EVLOG_N_TYPEID=OBJ_A_EVENT_NAME.A_EVNAM_N_ID ) 
AND ( OBJ_A_EVENT_DETL.A_EVDET_N_OBJTYPID=OBJ_A_OBJECT_TYPE.A_OTYPE_N_ID(+) ) 
AND ( OBJ_A_EVENT_LOG.A_EVLOG_N_APPID=OBJ_A_APPLICATION.A_APPLI_N_ID ) 
AND ( 
( OBJ_A_EVENT_LOG.A_EVLOG_N_TYPEID IN ('19','25') 
AND OBJ_A_EVENT_DETL.A_EVDET_N_OBJTYPID = '8' ) 
) 
GROUP BY 
decode(instr(OBJ_A_EVENT_DETL.A_EVDET_C_OBJNAME,'.'),0,OBJ_A_EVENT_DETL.A_EVDET_C_OBJNAME,substr(OBJ_A_EVENT_DETL.A_EVDET_C_OBJNAME,1,instr(OBJ_A_EVENT_DETL.A_EVDET_C_OBJNAME,'.')-1)), 
OBJ_A_OBJECT_TYPE.A_OTYPE_C_NAME, 
OBJ_A_EVENT_LOG.A_EVLOG_C_USER, 
OBJ_A_EVENT_NAME.A_EVNAM_C_NAME, 
OBJ_A_APPLICATION.A_APPLI_C_NAME

It is working fine . I get the data from 2002. If i need data from 2004, What are the modifications to be done above. Please advice.

Thanks in advance
Regards
Suamnth

sumanth (BOB member since 2004-09-24)

#2

and also for specific month

sumanth (BOB member since 2004-09-24)

#3

Hi,

I think your audit tables are not feeded ! I mean did you activate the webi trace under admin console ?

Regards

#4

Hi,

Webi traces are enabled in Webi pannel. From the above query i am getting data fine but to know from the year 2004 what changes need to be done in the query.

Regards
Sumanth

sumanth (BOB member since 2004-09-24)

#5

I don’t see what the problem is in your query !

Try under toad or something else to run this query by putting away links / tables step by step and you will find your problem !

Regards

#6

There is no problem in the query. Its working fine. it is giving all the data. But i would like to see the data from 2004 and a specific month. Can we get this

sumanth (BOB member since 2004-09-24)

#7

Hi

OK sorry i didn’t understand your need :wink: :wink: !
Cannot you make a filter in your report or put a condition on the year ?

OBJ_A_EVENT_log.A_EVLOG_D_STARTIME>'01/01/2004'

Regards

#8

TOPIC LOCKED (Please don’t Crosspost)

Continue Here: Audit Tables

Chris Pohl :us: (BOB member since 2002-06-18)