BusinessObjects Board

BO4 - Audit data one hour behind

other Auditor
#1

Hi,

Running some audit reports and finding that in audit report which uses audit universe from sap developer network forum showing all reports starting hour later than actually did.

e.g. If run query which uses
BOAUDIT.ADS_EVENT.START_TIME and query audit database directly shows data always one hour behind

if query select sysdate
from dual on database shows correct date but all date being written to BOAUDIT.ADS_EVENT.START_TIME 1 hour earlier than should be.

CMC/Auditing shows correct time

ADS Last Updated On 12/09/13 15:27:03 o’clock BST

just problem with data being written to BOAUDIT.ADS_EVENT.START_TIME
Any ideas?

Thanks

philipo (BOB member since 2005-07-22)

#2

Solution for SQL server available

nicothoen :netherlands: (BOB member since 2008-11-20)

#3

Interesting solution , BOE SAP support solution was to buy another watch to wear on my other wrist and set it to the audit date/time , that way I could tell what date time the audit value was on my right wrist and compare it to the time on my left wrist. Of course this is hugely exaggerated but close to there actual response.

Macroman :uk: (BOB member since 2002-11-13)

#4

Audit data is in GMT, so if you use Thoendra’s solution, it’ll be for your local time zone. His is 2 hours off, here in Iowa, it’s 5 hours.

pcgeekus :us: (BOB member since 2003-10-16)