# SQL Query to show specific scan results

**URL:** <https://discuss.rapid7.com/t/sql-query-to-show-specific-scan-results/41724>\
**Category:** SQL Queries\
**Tags:** InsightVM, sql, queries\
**Created:** [August 28, 2024, 6:44pm UTC](https://discuss.rapid7.com/t/sql-query-to-show-specific-scan-results/41724 "2024-08-28T18:44:52Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![guy\_incognito](https://discuss.rapid7.com/letter_avatar_proxy/v4/letter/g/eb8c5e/32.png) [@guy\_incognito](https://discuss.rapid7.com/u/guy_incognito)\
**Post date:** [August 28, 2024, 6:44pm UTC](https://discuss.rapid7.com/t/sql-query-to-show-specific-scan-results/41724/1 "2024-08-28T18:44:52Z")

</div>

Hi, I am looking for a very basic query to run against the data warehouse to list the contents of a specific scan\_id.

We have the default “Rapid 7 Insights Agents” site with its default site\_id. Everyday we have various agent import events and for each of these, I want to list the vulnerabilities found for each system.

We have problems determining what is strictly from agent based assessment versus the unauthenticated network scan that hits it.

This needs to be run from against the database so we can ingest it everyday, we can’t generate reports for this.

I appreciated any advice or insights you might have.