Auditing time and connection

system · October 13, 2009, 7:56am

hi all!

i would just like to know where i can edit the time in auditing universe. because it is not displaying the time that i set to the services.

and 1 more thing, my auditing database is in SQL Server, but after i enable the auditing to all services, the connection in the auditing changed, it doesn’t point to the database that i set when i installed it. it now points to Business Object Auditing Database which i can’t see in my sql server and in any odbc connection. please help!

thanks,
r.A.

R.A. (BOB member since 2008-10-28)

system · October 14, 2009, 1:03am

Hi R.A,

Do you mean to say, edit the Audit Timestamps ? if yes, is that for converting UTC Audit timestamps to your local time zone ?
Here is the solution to convert the UTC AuditTimestamps to Local Time

lgonzalez:

Yes, I discovered this myself about the Audit timestamps just recently. The audit database is on SQL Server, so here is what I did wherever AUDIT_EVENT.Start_Timestamp was found:
dateadd(hour,-datediff(hour,getdate(),getutcdate()),AUDIT_EVENT.Start_Timestamp)

Edit the Object Called “Action Time” in Actions Class with the above code.
You need to edit the objects in “SessionTime” and “Action Time” Class too.

Thanks
-Satish

forgotUN (BOB member since 2006-12-13)

system · October 14, 2009, 1:47am

hi satish!

i tried your recommendation but when i parse the object i get an error. and then i changed the data source to the original but after that it won’t run anymore…

i’ll try this again, on a different test server…

thank you very much!
r.A.

R.A. (BOB member since 2008-10-28)