NIM

Auditing queries

NIM records operations performed in target Systems in a SQLite database. You can then write auditing queries on this data, and insert them into Notification templates. This is useful for formal or informal audits.

To get started, Create an auditing query.

Caution

Currently, only operations executed as part of Mappings are stored in this database. Operations related to Roles are not yet included.

The database is stored at C:\ProgramData\Tools4ever\NIM\sysdata\nimDb.db. You can use the freeware application DB Browser for SQLite to explore this file.

Note

This database does not contain any information from source systems. It only contains changes written into target systems.

If you want to include source system data in your query output (e.g., employee information which is available in the source/HR system but has not been mapped into the target accounts), you must create a filter that joins the source and target data. Filters can be used in SQL queries as if they were SQL tables. They are prefixed with f_, and are listed in the Tables dropdown.