View ESEC.ESECDBA.VULN_CALC_SEVERITY_RPT_V Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
RSRC_ID varchar2 108
VULN_RSRC.RSRC_ID Implied Constraint
IP varchar2 96  √  null
HOST_NAME varchar2 765  √  null
CRITICALITY number 22  √  null
ASSIGNED_VULN_SEVERITY number 22  √  null
VULN_COUNT number 22  √  null
CALC_SEVERITY number 22  √  null

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

Close relationships: