Auditing user log in and log out

You can use this feature to audit all successful DMP Client log ins and log outs to the DMPVersion database on the TenantOptions table. All user log-ins are recorded by inserting the user details into the database. A function is included in the workflow that allows you to export the audit table to CSV and run a query to ensure the number of users and the number of times they log in.

You can enable or disable the settings for the user audit on Tenant Settings.

  1. Select Menu > Data Administration > Tenant Settings.
  2. On Subsystem ID, select 41 - Tenant Settings.
  3. Click Reload.
  4. On the PropKey column, find UserAudit and specify this information:
    PropValue
    Specify 1 to enable user audit and 0 to disable user audit.
  5. Click OK.
  6. Restart the application.

To export the audit table, you can run the audit report in the workflow to export the CSV file or log the query on the log file.

  1. Select Menu > Data > Workflows.
  2. On the Action column, select Run Audit.

    The Run Audit dialog box is displayed.

  3. In Run Audit, specify this information:
    Configuration
    Name
    Specify the configuration name.
    File name/Folder
    Specify the folder of file name of the output.
    Output
    Select Export to CSV or Log File.
    Audit Action
    Optionally, specify a value in this field.

    Click OK.

  4. Optionally, click View log file to open the event log file of the workflow.
  5. Click Run.
  6. Click Close.