Questions on auditing universe in BO 4.1

[former_member253234]

Hi all,

I have 2 questions regarding the auditing universe:

1. How can I extract the IP address of the machine from where the user has done an action?

2. Can I get the query and/or parameters (values in input prompts) used for each refresh?

Thanks.

[DellSC]

In the Auditing configuration in the CMC, there are some options for setting additional details to include in the audit. I always turn on Property Value Details and Folder Path Details for my clients. The first will get you the parameters and the second gives you the folder in BOBJ where the report is located.

You can also turn on "Query" to get the SQL details. However, this data will vastly increase the size of your audit database and slow down audit processing. We usually only turn it on if there's a problem report - we turn it on, run the report to see what's happening in the query, and then turn it off.

-Dell

[former_member185603]

Did you use the Audit Universe given by SAP? There is some pre built in reports which can extract the IP address of the machine. Below is the Object definition in Audit Universe based on oracle Audit DB.

dbms_lob.substr(DetailCHostRepByClient.EVENT_DETAIL_VALUE,dbms_lob.getlength(DetailCHostRepByClient.EVENT_DETAIL_VALUE)-1)

You cannot get the SQL