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.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
rockdj
3 years ago
SELECT
MACHINE.NAME,
OVAL_STATUS.RESULT,
OVAL_DEFINITION.SOURCE,
OVAL_DEFINITION.OVALID,
OVAL_DEFINITION.DESCRIPTION
FROM
OVAL_STATUS,
MACHINE,
KBSYS.OVAL_DEFINITION OVAL_DEFINITION
WHERE
MACHINE.ID = MACHINE_ID
ANDOVAL_STATUS.OVAL_DEFINITION_ID = OVAL_DEFINITION.ID
ANDOVAL_STATUS.RESULT = 'VULNERABLE';Written by brucegoose03
MACHINE.NAME,
OVAL_STATUS.RESULT,
OVAL_DEFINITION.SOURCE,
OVAL_DEFINITION.OVALID,
OVAL_DEFINITION.DESCRIPTION
FROM
OVAL_STATUS,
MACHINE,
KBSYS.OVAL_DEFINITION OVAL_DEFINITION
WHERE
MACHINE.ID = MACHINE_ID
ANDOVAL_STATUS.OVAL_DEFINITION_ID = OVAL_DEFINITION.ID
ANDOVAL_STATUS.RESULT = 'VULNERABLE';Written by brucegoose03