Auditing Keyword Variables

Interactive Reporting Studio provides keyword variables (see Table 243) that can be used to help define audit events. The keywords can be inserted into audit event SQL statements to return specific data each time the event is triggered.

Tip:	When entering an auditing keyword variable, always precede it with a colon (:) and enter all keyword text in uppercase. Other items in the SQL statement may also be case sensitive, depending on your database software.

Table 243. Auditing Keyword

Keyword Variable	Description
:ROWSRETRIEVED	Number of rows retrieved by the most recently executed query.
:REPOSITORYNAME	Name of the repository object in use (data model or standard query with reports).
:QUERYSQL	(Pre Process, Limit: Show Values, and Detail View only) Complete SQL text of the most recently executed query statement. Tip: Consider the maximum column length when using :QUERYSQL. You may want to use a substring function to limit the length of the SQL being logged. For example: SUBSTR(:QUERYSQL,200)
:SILENT	Restricts display of the audit-generated SQL statement within the user’s SQL Log. When the :SILENT keyword variable is included in the audit statement, the SQL Log output reads “Silent SQL sent to server…” instead of the SQL statement. This keyword variable provides a security feature when the triggered SQL statement is sensitive or should remain undetected.