What is the query to find vulnerable softwares installed on IVM assets

InsightVM SQL Queries
1

What should be the query in Rapid7 to identify the vulnerable softwares installed in assets