Skip to Content
author's profile photo Former Member
Former Member

view audit reports..


I have few queries in regards to Audit reports..Before that my environment is

Unix SOlaris 10.2 (clustered with another box so 2Unix containers / Oracle 10.2 / BO XI 3.1)

1. I have enabled Auditing on both of the boxes but how do i figure it out if the auditing is acutally enabled.

I did enable Audit features for the servers that i want to be audited but still how to confirm this ?

2. Do I need enable auditing by going under each Crystal report under Audit folder and tick the box ?

3. I loaded ORACLE_AUDIT_BIAR file on server and then loaded the AUDIT_EN_BIAR files > this created an AUDIT folder and I can view all sections under it.

4. Will change the parameter for Acitivity Universe to point to my ORACLE DB... But i guess in doing so the option of DefaultBOAuditingDB will go away and get replaced by my ORACLEDB ?

5.How do I get more information on the metadata Schema of CMS (SI_infoobjects6 etc..) I tried to lookup and find any documentation which would say detail descriptions on what each table means but in vain.?

6. I just need 3 main Audit reports >>

a. Find the START TIme of the Report when Run and End TIME of REport when it finished populating records.

b. Find the number of Lines populated in the report after it has run ?

c. FInd the size of the report after it has run ?

How to go about just these 3 reports ?

please advise,


Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Feb 23, 2012 at 08:27 AM

    Hi Priyank,

    To verify if the Auditing has been enabled on both the servers or not, you'll have to check the properties of SIA on both the machines. Execute for this on both machines.

    To verify what all events are getting audited, it has to be checked under "Audit Events" section on each server properties in CMC.

    I am not sure what do you mean by this - "Will change the parameter for Activity Universe to point to my ORACLE DB... But i guess in doing so the option of DefaultBOAuditingDB will go away and get replaced by my ORACLEDB ?"

    If you have Oracle as your auditing db server, import the 'Activity' universe designed for Oracle DB from the 'Samples' directory and point it your Oracle Database.

    You'll also have to import the auditing reports, which I guess you already did.

    There is no way from which you can retrieve the metadata schema of the tables that you listed as these are virtual tables which can be read and written to by CMS only.

    For the three reports only, import the auditing reports from samples biar and delete all those reports which are not necessary or else you can create your own reports against the Activity universe.

    I hope this will help you.



    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Priyank,

      AUDIT_EVENT.DETAIL_TYPE_ID = 51 gives you information if the report content being viewed is 'Live' data or 'Saved' data.

      AUDIT_EVENT.START_TIMESTAMP for the event typeid 199609 gives you the information when the report was viewed (it is time when the report displays data, not when you click on 'View') and Duration gives you information about how long did the report run.

      I am not sure about the report size, I'll have to check again.

      Hope this helps.



  • Posted on Apr 30, 2012 at 02:41 PM


    I have few updates on your question.

    Let me explain about my information.

    we are on 4.0 SP2 and Oracle DB and we have all BICS adhoc reports.

    1. Through oracle db we cant find the report execution time as simple as by considering start time and end time. We need to consider view, refresh, prompt, retrieve events to get approximate time of report execution time. But we have too may bugs in those. ADS not able to capture correct event time like we see view, retrieve, prompts Event Duration as "0". Even SAP able replicate the issue on their end. They are in the process of analysis with Development team.

    2. We see event duration for refresh but it shows as MS but in reality it should be Seconds. SAP confirmed it as bug, I am waiting for ADPT number.

    3. Event Start time works perfectly in IDT but when I use the same dimension in webi reports it gives wrong data, SAP able to replicate the same issue on their end. waiting for ADPT number.

    finally i can clear say that we can not get the report execution time if we have BICS reports as ADHOC based, but we can get the report execution time only if reports are sechule. Run event gives an complete time.

    I went through a hard time to make sap to replicate the issues on there end. Now SAP accepted that they see same issues with few other clients too.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 30, 2012 at 11:28 PM

    Thanks Manu / Rahul for your thoughts. But honestly I guess that does not suffice in my present condition.

    We view reports through websphere API, so a customised webpage where users log on and run reports.

    I was wondering in that case what EVENT type do they get captured as certainly they are not DOCUMENT REFRESHED, I tried OBJECT CREATED / Report Created for "CRYSTAL REPORTS" but that did not return any values for NUMBER OR LINES in a REPORT or even values under DURATION FIELD as I guess DURATION FIELD get populated for DESKI reports only ? and if you run reports through INFOVIEW ?

    So yea Rahul - You suggested the timestamp field. But this field only displays in dd/mm/yyyy format and NOT the TIME.

    DURATION field for some event is displayed as 1 and in most cases its 0 or NULL. SO what does this 1 means ?

    IF you could provide ans with respect to webshpere based architecture ? and its BO XI 3.1 SP3 on UNIX box > with ORACLE 11g as DB.


    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      work around for date and time issue in 4.0,

      Write click on "event start time" dimension and selct edit date format, at the bottom you should be able to see one format where it represents in AM and PM (ex: 04/22/2012 10:45:56 PM), select it and save it.

      Now you can see the date and time on webi, crystal reports. Not sure about 3.1 sp3. you can try it.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.