Scan status report

[john_hartman]

If you’re referring to the scan as a whole then you could use a similar query like the one mentioned here that Holly gave you:

Querying information from my last scan

Hello, I am looking to see if within my sql query I could just run the query against the very last scan that was run on the asset group / asset / whatever is best. Basically I’d like to query the last scan for any vulnerabilities with the word ‘exploit’ or ‘remote’ or ‘malware’ (for examples) in the title. Thank you.

In her query that she provided you could remove the WHERE statement and add that column to your query

SELECT site_id, MAX(scan_id) as scan_id, status_id
    FROM dim_site_scan
       JOIN dim_scan USING (scan_id)
    GROUP BY site_id, status_id

The status_id would be of the of the whole scan though of course and not specific to an asset. Not sure if this is what you were referring to.