BusinessObjects Board

BI 4.0 Audit Reports Codes

other Auditor
#1

Hi All

Please confirm me which code should I use for failure and successful jobs while developing SAP audit reports in webI.
I have considered failure - 1006 - delete event and successful - 1014 - logon event. I am not sure of this. Help me in finding out the code from the list below:

Event Type Id Event Type Name
1002 View
1003 Refresh
1004 Prompt
1005 Create
1006 Delete
1007 Modify
1008 Save
1009 Search
1010 Edit
1011 Run
1014 Logon

Thanks in advance.
Surbhi

surbhichugh6 (BOB member since 2012-08-06)

#2

Go to your BO Auditing database
look for Event_Type_Description “Scheduling Failed” in table called Event_type, and note down corresponding Event_Type_ID.

In BO XI 3.1 case Event_Type_ID is “327682”

hopefully this will help!!

Thanks,

mohsin30 (BOB member since 2016-11-01)

#3

In BI4 the final status of an event action is available via the ads_status_str table. Ex:

select
    object_folder_path,
    object_name,
    user_name,
    start_time,
    status_name
from
    ads_event ae
    join ads_status_str st on ae.status_id = st.status_id
    	and ae.event_type_id = st.event_type_id
       and st.language = 'EN'

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