Multiple audit records per one report refresh
We use BO XI R3 on Windows with CMS on DB2.
I need to create audit reports on BO report usage with following data:
username, timestamp, duration, report name for DeskI and WebI reports.
I use auditing on DesktopIntelligenceCacheServer and WebIntelligenceProcessingServer.
The problem is that I'm getting multiple records in AUDIT_EVENT table with different event_ids and timestamps per one refreshed report.
Following SQL brings 2 records from WebI server all the time (first with duration=0) and from 1 to 5 records from DeskI server, all of them with real report duration.
FROM BO_XI_R3.AUDIT_EVENT ae,
order by 1;
How to separate unique refresh info?
Edited by: Valentin Volk on Oct 3, 2008 9:03 PM
Prasanna Kumar replied
The BO CMS stores the audit record for the reports with refresh duration = 0 by default. We had the similar situation and always we used to append REFRESH_DURATION != 0 in our audit sql, thus removing the duplicates from the audit query output.