AnsweredAssumed Answered

SQL Query - Vulnerabilities by High Level OS?

Question asked by johnc2k on Apr 10, 2017
Latest reply on Apr 11, 2017 by johnc2k

Hi,

 

Please can you advise the correct SQL query to produce to report on the number of vulnerabilities per "High Level" OS?

 

E.g. I would like to group all MS Server 2008, 2012, 2016, etc under "Window Server", and similarly with Workstations (Win7, Win8, etc) and create a catch all "Misc Group" to cover the other weird and wonderful things out there (e.g. Firewalls, Printers, etc).

 

Thanks

 

John

Outcomes