Functions Data

AuditLog

The audit log contains data pertaining to the usage which is channeled through Quintessence by users. The auditlog() function retrieves the records and associated information for all and any requests made to Quintessence for a specified range of dates.

Syntax


AuditLog(AuditType, StartDate, EndDate, View, Application, User)

AuditType The audit type can be either “function” (returns entries for each function that was used) or “source” (shows sources for which information was requested). Note: custom sources need to be configured to log
StartDate The date delimiting the start of the range of value dates under consideration.
EndDate

The date delimiting the end of the range of value dates under consideration.

View

This parameter takes the form ‘DataView(*):Headers’.

To return specific columns, reference them by name, for example, “DataView(Entity,ValueDate)”.

Using (*) returns all columns.

The value for Headers can be:

    • column (show column headers)
    • row (show row headers, if any)
    • both (show both row and column headers)
    • none (show no headers).

For example, “DataView(*):column” or “DataView():none”

More on Views…

Application

This parameter allows you to filter the result according to an application. The options are:

    • Excel
    • WebAPI
    • Studio
    • R
AuditType This parameter allows you to filter the results according to a specific user. The domain username must be used