Skip to main content

FS_SDD_DELETE Job

The FS_SDD_DELETE instant job deletes Sensitive Data Discovery (SDD) data from the Tier 1 database for specified criteria, hosts, or combinations thereof. This job is available in the Instant Job Library under the File System library.

FS_SDD_DELETE Job

Runtime Details​

  • Dependencies: Run the 0.Collection Job Group successfully before running this job
  • Target Hosts: None (select Local host)
  • Scheduling: Run as needed, typically on an ad-hoc basis
  • History Retention: Not supported. Turn off history retention before running this job.
  • Multi-console Support: Not supported
  • Additional Notes: This job performs permanent data deletion with no undo capability. Access Analyzer disables all analysis tasks by default to prevent accidental data loss.

The FS_SDD_DELETE instant job provides a controlled method for removing Sensitive Data Discovery data from your Tier 1 database. Use this job to delete SDD data for specific criteria, remove data associated with decommissioned hosts, or delete specific host-and-criteria combinations. Because this job permanently deletes data with no recovery option, Access Analyzer disables all analysis tasks by default as a safety measure.

Analysis Tasks for the FS_SDD_DELETE Job​

To see the analysis tasks for this job, navigate to Jobs > Instant Job Library > File System > FS_SDD_DELETE and select the Analysis Tasks tab.

warning

This job permanently deletes data from the database. You can't undo this action. Access Analyzer disables all analysis tasks by default to prevent accidental data loss. Carefully review the data to be deleted before enabling and running any analysis task.

The following analysis tasks are available for the FS_SDD_DELETE job:

  • Delete Criteria – Deletes all SDD data for specified criteria from all hosts. Use this task to remove all occurrences of specific criteria across your entire environment.
  • Delete Host – Deletes all SDD data related to a specific host. Use this task when decommissioning a host or removing all SDD data associated with a particular system.
  • Remove Host & Criteria – Deletes all SDD data for a specific host and criteria combination. Use this task to remove SDD data for a specific criterion on a specific host.

Configuring the Analysis Tasks​

Each analysis task requires manually populating temporary database tables before execution:

  1. Open SQL Server Management Studio and connect to your Tier 1 database.
  2. Determine which analysis task you need to run based on the data you want to delete.
  3. Populate the required temporary tables:
    • For Delete Criteria: Populate the #Criteria temporary table with the criteria names you want to delete
    • For Delete Host: Populate the #hosts temporary table with the host names you want to delete
    • For Remove Host & Criteria: Populate both the #hosts and #Criteria temporary tables with the specific host and criteria combinations
  4. In the Access Analyzer console, navigate to Jobs > Instant Job Library > File System > FS_SDD_DELETE.
  5. Select the Analysis Tasks tab.
  6. Right-click the appropriate analysis task and select Enable.
  7. Review the enabled task to verify it will delete the correct data.
  8. Run the job by clicking Run Job and selecting Local as the target host.
  9. After the job completes, verify the job deleted the data as expected.
  10. Disable the analysis task to prevent accidental future deletions.