view audit reports..

[#1]

hi,

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,

regards

[Former Member]

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.

Regards

[Former Member]

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.