Detectors SQL

  1. Select a detector button and cut-n'-past to dbForge Studio SQL Editor.
  2. Select the database (local or remote) and execute the script
Detector SQL
Action Cut'n Past SQL
ScanWithFlag no Hit /* Selects scan table entries that have the hit flag set but no corresponding entry in the hit table */
USE setine5_seti
SELECT scans.Scan_ID, scans.Target_ID,scans.Hits FROM scans,hits WHERE NOT EXISTS
(SELECT scans.Scan_ID FROM scans WHERE scans.Scan_ID = hits.Scan_ID) AND scans.Hits != 0
Hit-NoScan /* Selects hits table where there is no corrosponding scan table entry */
USE setine5_seti
SELECT * FROM hits WHERE NOT EXISTS (SELECT * FROM hits WHERE hits.Scan_ID = Hit_ID)
Hit-NoSETI Data /* Selects hits table where no setidata exists - ERROR */
USE setine5_seti
SELECT * FROM hits WHERE NOT EXISTS (SELECT * FROM setidata WHERE setidata.Hit_ID = hits.Hit_ID )
SETI Data - No Hit /* Selects SETI Data table where no Hit entry exists */
USE setine5_seti
SELECT * FROM setidata WHERE NOT EXISTS (SELECT * FROM hits WHERE hits.Hit_ID = setidata.Hit_ID )