Auditing

You can quickly build charts in your piDashboard that can be used to audit who is using your Dashboard and also what they’re using. This is particularly useful when you’re considering deleting charts and users.

Your piDashboard contains a data connection called ‘Dashboard Repos’ and in here you’ll find the MIS_AUDITS table that can be used to quickly build charts and data tables to give you a good understanding of how your Dashboard is being used.

The following column descriptions should help you understand the data stored in the table:

• USER_CODE - The usercode/identifier of the user generating the audit record

• AUDIT_DATE_TIME - The date/time of the audit record

• AUDIT_TYPE - The type of audit record eg “Saved DataSource”

• DESCRIPTION - Additional information, for example a name

• RUN_TIME - For some features the run or execution time is recorded

• FORMER_VALUE - No longer used

• CURRENT_VALUE - No longer used

• CHART_POSITION - Position in the hierarchy (eg chart level 2)

• SEARCH_FILTERS - Additional filter information

• SEARCH_REF_CODE - No longer used

• CONTAINS_ERROR - No longer used

• ERROR_MESSAGE - Contains certain recorded error messages

• DETAIL_INFO - Additional metadata where useful

• CATEGORY_FILTERS - Information on the category filters in use

• USER_IP - End user ip for some actions

• REQUESTED_BY_USERCODE - The usercode of the user requesting, for example when using login as this can differ from USER_CODE

• NODE_ID - Node id generating the audit record for some actions

The following is a selection of audit records currently produced, however we are adding new ones all the time:

Please note when usage volume is high the audit table can get very large. You may wish to clear this down as a regular maintenance task.