Absent Member.
Absent Member.
260 views

How to access ad.actionDetail in reports?

Hi *,

I've a Logger with several ORACLE SmartConnectors. Those SmartConnectors use the field "ad.actionDetail" to store the executed SQL query (from the ORACLE audit log). However, this field seems not available in the SQL design interface (to generate reports based on information present in the SQL queries).

Any idea?

Best Regards,

Xavier

Labels (2)
0 Likes
2 Replies
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

Xavier - to report on a field, it must be part of the Logger schema.  You can add ad.actionDetail as a Custom Field to add it to the Logger schema.  Do a search for Custom Field in the Logger help or in the docs to find out more about it. 

0 Likes
Absent Member.
Absent Member.

Another way: map this field to one of the available fields like deviceCustomString1 at Smart Connector level.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.