Needed sql query for below:
Vulnerability Solution(Exact solution)
Vulnerability CVSSv3 Score(7 to 10 only)
Vulnerability CVE URLs
Asset IP Address
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.
Vulnerability description and solution needed to be combined to one.
CVSSV3 score for only 7 to 10.
Thank you for the help.