SQL for custom OVAL scan report
Is there a script that allows me to combine the two OVAL Scan reports (Device Compliance and summary results) so that it lists the machine name and then all of the vulnerabilities that machine has as a sub category underneath it?
I have searched and tried to create a custom report by racking my brain of SQL commands from years ago but I have not figured it out yet.
MACHINE.ID = MACHINE_ID
ANDOVAL_STATUS.OVAL_DEFINITION_ID = OVAL_DEFINITION.ID
ANDOVAL_STATUS.RESULT = 'VULNERABLE';Written by brucegoose03