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.