Ram Ram

SQL Query for Asset Best Solution

Discussion created by Ram Ram on Jul 14, 2017
Latest reply on Aug 10, 2017 by Chris Ackerman

Hello,

We are trying to run SQL query which selects all information about the scanned host.

However, we getting thousands of multiplied rows for each IP address that has Windows vulnerabilities.

This happens since the query grabs all vulnerability solutions, instead of the best solution.

1.png

 

1.png

Is there any way to make SQL Query only for asset best solution?

Thanks

David

Outcomes