Post Author: jsanzone
CA Forum: Auditing
Seyin,
From what you are describing, it sounds like you're experiencing a nightmare. There are too many variables to describe here to determine what is going wrong, especially if one report runs intermittently and another not at all. To fully resolve your problem, I highly suggest contacting Tech Support and be prepared to have a WebEx session so that they can more expertly debug the problem. In the meantime, I'd like to suggest something that I did to make Auditor reporting more effective for me -- I wrote a view against the six tables and "flattened" it out. I set this view in my Auditor database and then started a new universe that simply called this new view in as its data source, and from that I wrote all of my own custom reports. Though the BO reports are useful, I decided that my own custom reports would serve me better in the long run. Best wishes in resolving your situation. Below is the view that I built which you can copy and paste to your system if you'd like:
CREATE view BOE_AUDIT_View asSELECT server_process.application_type_id as [Application_Type_ID], coalesce(cast(application_type.application_type_description as varchar(50)), cast(server_process.application_type_id as varchar(50))) as [Application_Type_Description], audit_detail.detail_id as [Detail_ID], audit_detail.detail_text as [Detail_Text], audit_detail.detail_type_id as [Detail_Type_ID], coalesce(cast(detail_type.detail_type_description as varchar(50)), cast(audit_detail.detail_type_id as varchar(50))) as [Detail_Type_Description], audit_event.Duration as [Duration], audit_Event.Error_Code as [Error_Code], cast(audit_event.Event_ID as varchar(32)) as [Event_ID], audit_event.Event_Type_ID as [Event_Type_ID], coalesce(cast(event_type.event_type_description as varchar(50)), cast(audit_event.Event_Type_ID as varchar(50))) as [Event_Type_Description], cast(audit_event.Object_CUID as varchar(32)) as [Object_CUID], audit_event.Start_Timestamp as [Start_Timestamp], cast(audit_event.User_Name as varchar(50)) as [User_Name], cast(audit_event.server_cuid as varchar(32)) as [Server_CUID], coalesce(cast(server_process.server_name as varchar(50)),'') as [Server_Name], coalesce(cast(server_process.server_fullname as varchar(50)),'') as [Server_Fullname], coalesce(cast(server_process.server_version as varchar(50)),'') as [Server_Version]FROM ((((AUDIT_EVENT RIGHT JOIN AUDIT_DETAIL ON (AUDIT_EVENT.Event_ID = AUDIT_DETAIL.Event_ID) AND (AUDIT_EVENT.Server_CUID = AUDIT_DETAIL.Server_CUID)) LEFT JOIN DETAIL_TYPE ON AUDIT_DETAIL.Detail_Type_ID = DETAIL_TYPE.Detail_Type_ID) LEFT JOIN EVENT_TYPE ON AUDIT_EVENT.Event_Type_ID = EVENT_TYPE.Event_Type_ID) LEFT JOIN SERVER_PROCESS ON AUDIT_EVENT.Server_CUID = SERVER_PROCESS.Server_CUID) LEFT JOIN APPLICATION_TYPE ON SERVER_PROCESS.Application_Type_ID = APPLICATION_TYPE.Application_Type_ID
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.