BusinessObjects Board

Audit Free-Hand SQL

I am currently used 4.1 and in the Audit database I cannot query the free-hand sql stored against each report. I am wanting for example to identify all webi reports using a specific table.
Wondering whether this is possible in 4.3. Has the auditing improved?

Auditing of SQL isn’t on by default. You have to check the Query option under Event Details on the audit configuration page.

Keep in mind, even with this enabled, events only hit the database when the report is run. If you have a report sitting out there that hasn’t been run, it won’t show up.

Yeah I do have it on, however seems to only pick up SQL from reports based off a universe not free-hand SQL.