cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Pruning Activities from File Access Manager

Pruning Activities from File Access Manager

To maintain the health of your database, it is recommended that you prune activities/events from the File Access Manager database.

You can prune activity data on an ad hoc basis or via a schedule. These instructions use 180 days of activities as the pruning threshold, as an example.

  1. In the File Access Manager Business Website (web client), click the Forensics tab.

    WebClientForensicsTab.PNG

     

  2. Build a Query to display all events for all Applications After X date:
    1. Leave all filters field blank OR set a filter only for the Application(s) you wish to prune activities from.
    2. In the Time Frame drop-down, select Advanced Options
      WebClientAdvancedOptions.png

       

    3. In Advanced Options, choose Last Period from the Time Frame drop-down.
    4. Set the Period field to Older Than and enter 180 Days as the value. (This value can be modified as required.)
      WebClientAdvancedOptions3.PNG
    5. Click Apply
  3. Click Apply on the Activity Forensics screen to see updated query results.
  4. Once results are displayed, click Actions in the top right corner, and select Delete Query Results.
  5. In the displayed window, select Once for ad hoc pruning, or Repeating to set a schedule.
    WebClientDeleteQueryResults.png

     

  6. If a schedule is set it will appear in the File Access Manager Admin Client under Scheduled Tasks. It can be modified or deleted there.
Comments

IS there a way to delete these data from the database itself(whiteops.events table) as this queries for me takes a very long time to complete

Version history
Revision #:
8 of 8
Last update:
‎Sep 15, 2023 04:11 PM
Updated by: