Deleting Risk-based Authentication and Device Fingerprint Entries from the Database

If you have enabled user history, details for all login attempts using a risk-policy or a device fingerprint policy are recorded in the database. This might result in huge data and occupy a large space. It is recommended to delete the entries periodically after you complete the analysis.

Deleting Entries from MS SQL Server

  1. Go to Start > All Programs > Microsoft SQL Server 2016 > SQL Server Management Studio.

  2. Connect to the database engine.

  3. Expand Databases, you can see the netiq_risk database.

  4. Click New Query.

  5. To check the number of entries in the usrtransaction table, select the following command and click Execute.

    Select * from dbo.risk_usrtransaction;

  6. To delete entries, select the following command and click Execute:

    Delete from dbo.usrtransaction;

    NOTE:This command deletes all entries in the table. If you want to delete a specific range of entries, use the appropriate SQL command.

  7. Perform step 5 and 6 for the device fingerprint table (device_fingerprint) also.

Deleting Entries from MySQL Server

  1. Connect to MySQL Server installed on Linux by using the MySQL client:

    mysql -u root -p password

  2. Connect to the use netiq_risk database.

    use netiq_risk;

  3. List the tables. The usrtransaction table is listed in the list of tables.

    show tables;

  4. Delete entries.

    delete from usrtransaction;

    NOTE:This command deletes all entries in the table. If you want to delete a specific range of entries, use the appropriate SQL command.

  5. Perform step 4 for the device fingerprint table (device_fingerprint) also.

Deleting Entries from Oracle Server

  1. Open Oracle SQL Developer.

  2. Right-click Connections and select New Connection.

  3. Connect to the database engine.

  4. Expand Connections, you can see the netiq_risk database under.

  5. To check the number of entries in the usrtransaction table, select the following command and execute:

    Select * from usrtransaction;

  6. To delete entries, select the following command and execute:

    Delete from usrtransaction;

    NOTE:This command deletes all entries in the table. If you want to delete a specific range of entries, use the appropriate command.

  7. Perform step 5 and 6 for the device fingerprint table (device_fingerprint) also.