Index: trunk/ippTools/share/warptool_scmap.sql
===================================================================
--- trunk/ippTools/share/warptool_scmap.sql	(revision 27737)
+++ trunk/ippTools/share/warptool_scmap.sql	(revision 29349)
@@ -7,6 +7,10 @@
     chipRun.state,
     chipProcessedImfile.data_state,
+    chipProcessedImfile.fault AS chip_fault,
     chipProcessedImfile.magicked,
-    rawImfile.magicked AS raw_magicked
+    rawImfile.magicked AS raw_magicked,
+    IFNULL(magicDSRun.magic_ds_id, 0) AS magic_ds_id,
+    IFNULL(magicDSRun.state, 0) AS dsRun_state,
+    IFNULL(magicDSFile.fault, 0) as dsFile_fault
 FROM warpRun
 JOIN warpSkyCellMap
@@ -26,4 +30,9 @@
     ON chipRun.exp_id = rawImfile.exp_id
     AND chipProcessedImfile.class_id = rawImfile.class_id
+LEFT JOIN magicDSRun
+    ON chipRun.chip_id = magicDSRun.stage_id AND magicDSRun.stage = 'chip'
+LEFT JOIN magicDSFile
+    ON magicDSFile.magic_ds_id = magicDSRun.magic_ds_id 
+        AND chipProcessedImfile.class_id = magicDSFile.component
 WHERE
     1