---
sourceDocument: Australia Security Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/security-management

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia Security Management

ft:clusterId :

    - security

bundleId :

    - security

workflow :

    - Technology


---

# Deduplicate Rapid7 Vulnerability Integration data warehouse records

# Deduplicate Rapid7 Vulnerability Integration
data warehouse records {#ariaid-title1}

* Release version: Australia
* 
* Updated March 12, 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

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://servicenow-prod.fluidtopics.net/msi8kaFkGNjyRib_XBHEzQ "Assign the Vulnerability Response persona roles to groups or users with Setup Assistant."). For more information about managing granular roles, see [Manage persona and granular roles for Vulnerability Response](https://servicenow-prod.fluidtopics.net/WeKNf9YHNMJmJIA6yCsRvA "After you complete your initial assignment of persona roles using Setup Assistant, manage additional granular role assignments to users or groups from the User Administration module in your instance.").

## 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 AllRapid 7Integrations.
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.  
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.

*[\>]: and then