/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: rockdj 1 month ago
Senior White Belt
0
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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ