Accessing the audit information¶
As all the audit files are related bewtween then, and being SQL a convenient language to relate tables, we provide access to the audit information (read only tables) with the Sculptor SQL engine. The tables will belong to the special “AuditInfo” schema:
AuditInfo.Transactions
AuditInfo.AuditRecords
AuditInfo.AuditFields
AuditInfo.FileTable
AuditInfo.FileTableField
The information can be accessed via the sql command line tool, the sql command inside sculptor programs, which can be executed on the Sculptor server or via ODBC. In this way we have the sql syntax flexibility to perform the required query.
To be able to work with different Audit databases the new SQL command AUDIT DATABASE “AuditDb” can be used.
RELATED TOPICS |