SQL query with relevant solution

InsightVM
1

HI Team,
Needed sql query for below:
Vulnerability Title
Vulnerability Description
Vulnerability Solution(Exact solution)
Vulnerability Proof
Vulnerability CVSSv3 Score(7 to 10 only)
Vulnerability CVE URLs
Asset IP Address
Asset Names
Operating system

  1. I am always getting solution suggesting for multiple OS. For example if vulnerability related to missing patch solution consist of suggesting for all the OS rather than for the relevant os.

  2. Vulnerability description and solution needed to be combined to one.

  3. CVSSV3 score for only 7 to 10.

Thank you for the help.