SQl Query for monthly reports

Hello Everyone…

I am looking for a query that will give the latest solution for that vulnerability and the particular asset type(like if it 2016 server then I should get only 2016 latest solution )
There are queries that give all the solutions. Here is the list I am looking for:

  1. Hostname
  2. Vulnerability title
  3. Severity
  4. Aging
  5. Proof
  6. Solution (latest KB number if it is Microsoft OS vulnb)
  7. Exploit
  8. OS description