SQL Query to get a total number of vulnerabilities per software

Hello

I have been asked whether I can provide a list of software with the most vulnerabilities from InsightVM. Is there a query I can use to get the name of software and the number of vulnerabilities that it has?

Software name = No of vulnerabilities

Thanks for your assistance.

We don’t have anything in the database that specifically maps the Software to a vulnerability in that fashion.