View ESEC.ESECDBA.UNASSIGNED_INCIDENTS_RPT_V | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Tue May 04 17:09 EDT 2010 |
View SQL:
SELECT "INC_ID","NAME","SEVERITY","STT_ID","SEVERITY_RATING","VULNERABILITY_RATING","CRITICALITY_RATING","DATE_CREATED","DATE_MODIFIED","CREATED_BY","MODIFIED_BY","INC_DESC","INC_CAT","INC_PRIORITY","INC_RES" FROM INCIDENTS IN1 WHERE NOT EXISTS (SELECT NULL FROM ASSOCIATIONS WHERE TABLE1 = 'INCIDENTS' AND ID1 = IN1.INC_ID AND TABLE2='USERS' ) |
|