---
title: Rapid7 Nexpose Tag Report Setup Guide
slug: rbvm-help/rapid7-nexpose-tag-report-setup-guide
createdAt: 2026-10-26T13:51:24.193Z
---

Summary: How to set up a tag report in Rapid7 Nexpose.

### Rapid7 Nexpose Overview

Rapid7 Nexpose provides vulnerability management software to discover and prioritize vulnerabilities found in your environment. RiskSense supports the Nexpose CSV-formatted tag export report. This report allows the user to import their defined tags from Nexpose to RiskSense.

### Rapid7 Nexpose CSV-Formatted Tag Export Report Setup

Log into the Nexpose web application.

::Image[]{src="https://api.archbee.com/api/optimize/9rfvxhrv8FA-8bxcK2IRv/-UlsJSbj7miHcTrfI976S_rapid7-nexpose-tag-report.png" alt="Nexpose Tag Report - Login Screen" position="flex-start" size="65" width="454" height="442" initialPath="Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report.png" githubPath="RBVM_14.70_help/Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report.png" showCaption="false"}

Navigate to the *Reports* dashboard and click the blue **New** button.

::Image[]{src="https://api.archbee.com/api/optimize/9rfvxhrv8FA-8bxcK2IRv/RfOZP4SFmmWkZ4s7zvB0-_rapid7-nexpose-tag-report.jpg" alt="Nexpose Tag Report - New Button Location" position="flex-start" size="98" width="684" height="122" initialPath="Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report.jpg" githubPath="RBVM_14.70_help/Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report.jpg" showCaption="false"}

Enter a report title (e.g., CSV Tag Report-RiskSense) and select the **SQL Query Export** template from the *Export* tab.

::Image[]{src="https://api.archbee.com/api/optimize/9rfvxhrv8FA-8bxcK2IRv/fmLQ7y_DVyZDzGyzYsys8_rapid7-nexpose-tag-report1.jpg" alt="Nexpose Tag Report - SQL Query Export" position="flex-start" size="98" width="687" height="346" initialPath="Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report_1.jpg" githubPath="RBVM_14.70_help/Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report_1.jpg" showCaption="false"}

Click the **Query** box. Copy the query from this document’s appendix and paste it into the **Define a SQL Query** dialog that appears.

::Image[]{src="https://api.archbee.com/api/optimize/9rfvxhrv8FA-8bxcK2IRv/Y7-xzl4bfIJMceN7Oi8kV_rapid7-nexpose-tag-report2.jpg" alt="Nexpose Tag Report - SQL Query Export Configuration" position="flex-start" size="98" width="686" height="145" initialPath="Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report_2.jpg" githubPath="RBVM_14.70_help/Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report_2.jpg" showCaption="false"}

After pasting the CSV tag query from the appendix, click the **Validate** button to confirm the query is valid and then click **Done**.

::Image[]{src="https://api.archbee.com/api/optimize/9rfvxhrv8FA-8bxcK2IRv/_3W_1XTBn9D_hW4YqA5DX_rapid7-nexpose-tag-report3.jpg" alt="Nexpose Tag Report - Define a SQL Query" position="flex-start" size="98" width="686" height="342" initialPath="Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report_3.jpg" githubPath="RBVM_14.70_help/Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report_3.jpg" showCaption="false"}

The following screen appears after validating the query and clicking the **Done** button.

::Image[]{src="https://api.archbee.com/api/optimize/9rfvxhrv8FA-8bxcK2IRv/W5saKLe5NQ_UFNljB5cyT_rapid7-nexpose-tag-report4.jpg" alt="Nexpose Tag Report - SQL Query Export Configuration - Post Validation" position="flex-start" size="98" width="688" height="184" initialPath="Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report_4.jpg" githubPath="RBVM_14.70_help/Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report_4.jpg" showCaption="false"}

Next, schedule the CSV tag export’s run frequency.

::Image[]{src="https://api.archbee.com/api/optimize/9rfvxhrv8FA-8bxcK2IRv/CM4NQavevirSVWHviW6O0_rapid7-nexpose-tag-report5.jpg" alt="Nexpose Tag Report - Schedule Run Frequency" position="flex-start" size="84" width="587" height="171" initialPath="Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report_5.jpg" githubPath="RBVM_14.70_help/Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report_5.jpg" showCaption="false"}

Once the cadence has been established, click either **Save & Run the Report** or **Save the Report**.

::Image[]{src="https://api.archbee.com/api/optimize/9rfvxhrv8FA-8bxcK2IRv/wwvEk6Za6OKKkvk1BN-JC_rapid7-nexpose-tag-report6.jpg" alt="Nexpose Tag Report - Save and Run the Report" position="flex-start" size="47" width="327" height="104" initialPath="Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report_6.jpg" githubPath="RBVM_14.70_help/Resources/Images/RS KB Mirror for Ivanti - 2022/Rapid7 Nexpose Tag Report_6.jpg" showCaption="false"}

### Appendix: Query

WITH custom\_tags AS
  (SELECT asset\_id, CSV(tag\_name ORDER BY tag\_name) AS custom\_tags
   FROM dim\_tag
   JOIN dim\_tag\_asset USING (tag\_id)
   WHERE tag\_type = 'CUSTOM'
   GROUP BY asset\_id),
location\_tags AS
  (SELECT asset\_id, CSV(tag\_name ORDER BY tag\_name) AS location\_tags
   FROM dim\_tag
   JOIN dim\_tag\_asset USING (tag\_id)
   WHERE tag\_type = 'LOCATION'
   GROUP BY asset\_id),
owner\_tags AS
  (SELECT asset\_id, CSV(tag\_name ORDER BY tag\_name) AS owner\_tags
   FROM dim\_tag
   JOIN dim\_tag\_asset USING (tag\_id)
   WHERE tag\_type = 'OWNER'
   GROUP BY asset\_id),
criticality\_tags AS
  (SELECT asset\_id, CSV(tag\_name ORDER BY tag\_name) AS criticality\_tags
   FROM dim\_tag
   JOIN dim\_tag\_asset USING (tag\_id)
   WHERE tag\_type = 'CRITICALITY'
   GROUP BY asset\_id)
SELECT asset\_id,
       ct.custom\_tags,
       lt.location\_tags,
       ot.owner\_tags,
       crt.criticality\_tags
FROM dim\_asset
LEFT OUTER JOIN custom\_tags ct USING (asset\_id)
LEFT OUTER JOIN location\_tags lt USING (asset\_id)
LEFT OUTER JOIN owner\_tags ot USING (asset\_id)
LEFT OUTER JOIN criticality\_tags crt USING (asset\_id)