diff --git a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
index 127b676..0869697 100644
--- a/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
+++ b/casic-alarm/src/main/java/com/casic/missiles/modular/system/dao/mapping/StatisticMapper.xml
@@ -35,6 +35,7 @@
               AND BWI.DEPTID IN (${deptIds})
             GROUP BY BD.DEVICE_TYPE
         ) A ON BDT.ID = A.deviceType
+        WHERE bdt.`VALID`=1
     </select>
 
     <select id="deviceStaticsByDept" resultType="map">