---
title: Deduplicate Rapid7 Vulnerability Integration data warehouse records
description: When migrating to the InsightVM integration type from the Data Warehouse integration type, you can deduplicate existing data warehouse vulnerable items as long as they belong to the same source data as your Rapid7 InsightVM data.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/security-management/vulnerability-response/dedup-data-warehouse.html
release: australia
product: Vulnerability Response
classification: vulnerability-response
topic_type: task
last_updated: "2026-03-12"
reading_time_minutes: 1
breadcrumb: [Install the Rapid7 Vulnerability Integration, Understanding the Rapid7 Vulnerability Integration, Vulnerability Response integrations, Vulnerability Response, Unified Security Exposure Management, Security Operations]
---

# Deduplicate Rapid7 Vulnerability Integration data warehouse records

When migrating to the **InsightVM** integration type from the **Data Warehouse** integration type, you can deduplicate existing data warehouse vulnerable items as long as they belong to the same source data as your Rapid7 InsightVM data.

## Before you begin

Role required: sn\_vul\_r7.admin or, sn\_vul.vulnerability\_admin or sn\_vul.admin \(deprecated\)

Persona and granular roles are available to help you manage what users and groups can see and do in the Vulnerability Response application. For an initial assignment of the persona roles in Setup Assistant, see [Assign the Vulnerability Response persona roles using Setup Assistant](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/security-management/vulnerability-response/vr-assign-personas_SA.md). For more information about managing granular roles, see [Manage persona and granular roles for Vulnerability Response](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/security-management/vulnerability-response/vr_manage_granular-roles.md).

## About this task

This deduplication only works when migrating from the Rapid7 Nexpose data warehouse to the Rapid7 InsightVM Vulnerable Item integration.

## Procedure

1.  Navigate to **All** > **Rapid 7** > **Integrations**.

2.  Set all Rapid7 Nexpose data warehouse integrations **Active** column settings to **False**, disabling the integrations.

3.  Enter `sys_properties.list` in the left navigation panel.

4.  Search for the **Name**: `sn_vul_r7.deduplicate_DW_vulnerable_item`.

5.  Change the **Value** field to **True**.

    \[Omitted image "r7-sys-property.png"\] Alt text: System property example

6.  Select the green checkmark icon.

    During the next Rapid7 InsightVM vulnerable item integration import, any match with existing data warehouse records prevents a duplicate vulnerable item from being created.