Skip to Content
Former Member
Feb 23, 2012 at 07:09 AM

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,