Skip to Content
0
Former Member
Aug 18, 2008 at 04:17 AM

BO Audit database in Oracle

442 Views

Hi,

Does anyone have BO Audit Database running in Oracle. I want the Oracle script to create tables, indexes, constraints etc. Can anyone send me the script? How can I get those scripts.

Thanks for your help.

Regards,

Tanveer.

N.B. I have already created a script but not confident whether it will work for all situations.

CREATE TABLE application_type (

Application_Type_ID number(10,0),

Application_Type_Description varchar2(50)

);

CREATE TABLE audit_detail (

Event_ID varchar2(64),

Detail_ID number(10,0),

Server_CUID varchar2(56),

Detail_Type_ID number(10),

Detail_Text varchar2(4000)

)

CREATE TABLE audit_event (

Event_ID varchar2(64),

User_Name varchar2(64),

Start_Timestamp date default to_date('01-01-1000','dd-mm-yyyy') ,

Duration number(10,0),

Event_Type_ID number(10,0),

Server_CUID varchar2(56),

Object_CUID varchar2(56),

Error_Code number(11,0)

)

CREATE TABLE detail_type(

Detail_Type_ID number(10,0),

Detail_Type_Description varchar2(50)

);

CREATE TABLE event_type (

Event_Type_ID number(10,0),

Event_Type_Description varchar2(50)

);

CREATE TABLE server_process (

Server_CUID varchar2(56) ,

Server_Name varchar2(50),

Application_Type_ID number(10,0),

Server_FullName varchar2(100),

Server_Version varchar2(100)

)

alter table application_type add constraint application_type_uk1 unique (Application_Type_ID);

alter table audit_detail add constraint audit_detail_uk1 unique (Event_ID,Detail_ID,Server_CUID);

alter table audit_event add constraint audit_event_uk1 unique (Event_ID,Server_CUID);

alter table audit_event modify (Start_Timestamp NOT NULL);

alter table detail_type add constraint detail_type_uk1 unique (Detail_Type_ID);

alter table event_type add constraint event_type_uk1 unique (event_type_ID);

alter table server_process add constraint server_process_uk1 unique (Server_CUID);

INSERT INTO application_type VALUES (1,'Unknown application');

INSERT INTO application_type VALUES (8,'Web Intelligence Report Server');

INSERT INTO application_type VALUES (10,'CMS');

INSERT INTO application_type VALUES (11,'Cache Server');

INSERT INTO application_type VALUES (12,'Report Job Server');

INSERT INTO application_type VALUES (13,'RAS');

INSERT INTO application_type VALUES (14,'Event Server');

INSERT INTO application_type VALUES (15,'Program Job Server');

INSERT INTO application_type VALUES (17,'Destination Job Server');

INSERT INTO application_type VALUES (18,'Web Intelligence Job Server');

INSERT INTO application_type VALUES (19,'DCP Job Server');

INSERT INTO application_type VALUES (20,'Question Engine Server');

INSERT INTO application_type VALUES (21,'Desktop Intelligence Job Server');

commit;

INSERT INTO detail_type VALUES (40,'Event ID');

INSERT INTO detail_type VALUES (41,'Event Filename');

INSERT INTO detail_type VALUES (42,'User Groups');

INSERT INTO detail_type VALUES (43,'Object Folder Path');

INSERT INTO detail_type VALUES (44,'Object Category Path');

INSERT INTO detail_type VALUES (45,'Session ID');

INSERT INTO detail_type VALUES (46,'Enterprise Error Text');

INSERT INTO detail_type VALUES (47,'ODBC SQLSTATE');

INSERT INTO detail_type VALUES (48,'ODBC Error Text');

INSERT INTO detail_type VALUES (49,'BOE UserID');

INSERT INTO detail_type VALUES (50,'Object Type');

INSERT INTO detail_type VALUES (51,'Report Data Type');

INSERT INTO detail_type VALUES (2,'Universe name');

INSERT INTO detail_type VALUES (3,'Object Name');

INSERT INTO detail_type VALUES (6,'Number of lines');

INSERT INTO detail_type VALUES (7,'Number of elements');

INSERT INTO detail_type VALUES (8,'Document name');

INSERT INTO detail_type VALUES (9,'Document size');

INSERT INTO detail_type VALUES (14,'Description');

INSERT INTO detail_type VALUES (15,'Category name');

INSERT INTO detail_type VALUES (16,'Keywords');

INSERT INTO detail_type VALUES (17,'Refresh options');

INSERT INTO detail_type VALUES (18,'Overwrite');

INSERT INTO detail_type VALUES (19,'SQL value');

INSERT INTO detail_type VALUES (21,'Document type');

INSERT INTO detail_type VALUES (22,'Report name');

INSERT INTO detail_type VALUES (23,'Prompt name');

INSERT INTO detail_type VALUES (24,'Prompt value');

commit;

INSERT INTO event_type VALUES (6,'Get list of universes');

INSERT INTO event_type VALUES (9,'Save document to repository');

INSERT INTO event_type VALUES (11,'Read Document');

INSERT INTO event_type VALUES (13,'Selection of universe');

INSERT INTO event_type VALUES (19,'Document refresh');

INSERT INTO event_type VALUES (21,'List of values');

INSERT INTO event_type VALUES (22,'Edit document');

INSERT INTO event_type VALUES (28,'Apply format');

INSERT INTO event_type VALUES (40,'Get page');

INSERT INTO event_type VALUES (41,'Generate SQL');

INSERT INTO event_type VALUES (42,'Drill out of scope');

INSERT INTO event_type VALUES (43,'Select prompt');

INSERT INTO event_type VALUES (65537,'Concurrent Logon Event');

INSERT INTO event_type VALUES (65538,'Named User Logon Event');

INSERT INTO event_type VALUES (65539,'User Logon Fails');

INSERT INTO event_type VALUES (65540,'User Logoff');

INSERT INTO event_type VALUES (65541,'Password Change');

INSERT INTO event_type VALUES (65542,'Object is Created');

INSERT INTO event_type VALUES (65543,'Object is Deleted');

INSERT INTO event_type VALUES (65544,'Object is Modified');

INSERT INTO event_type VALUES (65545,'Unresponsive Scheduling');

INSERT INTO event_type VALUES (65546,'Rights on an object have been modified');

INSERT INTO event_type VALUES (131073,'Report Viewed Successfully');

INSERT INTO event_type VALUES (131074,'Report Viewing Attempt Failed');

INSERT INTO event_type VALUES (196609,'Report Viewed Successfully');

INSERT INTO event_type VALUES (196610,'Report Viewing Attempt Failed');

INSERT INTO event_type VALUES (262145,'Event is Registered');

INSERT INTO event_type VALUES (262146,'Event is Unregistered');

INSERT INTO event_type VALUES (262147,'Event is Updated');

INSERT INTO event_type VALUES (262148,'Event is Triggered');

INSERT INTO event_type VALUES (327681,'Scheduling Succeeded');

INSERT INTO event_type VALUES (327682,'Scheduling Failed');

INSERT INTO event_type VALUES (327683,'Scheduling Failed but will be reattempted');

INSERT INTO event_type VALUES (458753,'Report is Opened');

INSERT INTO event_type VALUES (458754,'Object is Published/Saved Successfully (4 or 6)');

INSERT INTO event_type VALUES (458755,'Report is Created');

INSERT INTO event_type VALUES (458756,'Report Fails to Open');

INSERT INTO event_type VALUES (458757,'Object Publish/Save attempt Fails (4 or 6)');

INSERT INTO event_type VALUES (458758,'Report fails to get Created');

INSERT INTO event_type VALUES (655361,'Question Succeeded');

INSERT INTO event_type VALUES (655362,'Question Failed');

commit;

And some server specific values to server_process table.