KACE Product Support

Hello, I am new to the K1000 management appliance and do not have much experience with SQL. I am attempting to create a custom report for OVAL scanning. I've scanned the machines and they have reported back the vulnerabilities. The canned reports only seem to give you two options.

1) Report listing each vulnerability and the number of machines that have the vulnerability

2) Report listing each machine and the number of vulnerabilities that it has

What I would like to do is create a report that lists each vulnerability and lists each machine name that has that specific vulnerability.

Any help would be much appreciated.

Thanks