View ESEC.ESECDBA.VULN_CALC_SEVERITY_RPT_V | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Tue May 04 17:09 EDT 2010 |
View SQL:
SELECT B.RSRC_ID , MAX(B.IP) IP , MAX(B.HOST_NAME) HOST_NAME , MAX(B.CRITICALITY) CRITICALITY , MAX(C.ASSIGNED_VULN_SEVERITY) ASSIGNED_VULN_SEVERITY , COUNT(C.VULN_ID) VULN_COUNT , COUNT(C.VULN_ID) * C.ASSIGNED_VULN_SEVERITY * (CASE WHEN MAX(B.CRITICALITY) >20 THEN 2.3 WHEN MAX(B.CRITICALITY) BETWEEN 16 AND 20 THEN 1.94 WHEN MAX(B.CRITICALITY) BETWEEN 11 AND 15 THEN 1.56 WHEN MAX(B.CRITICALITY) BETWEEN 6 AND 10 THEN 1.28 ELSE 1 END) CALC_SEVERITY FROM VULN_RSRC B, VULN C WHERE B.RSRC_ID = C.RSRC_ID AND C.END_EFFECTIVE_DATE >= SYSDATE GROUP BY B.RSRC_ID, C.ASSIGNED_VULN_SEVERITY |
|