Subversion Repositories SmartDukaan

Rev

Rev 5674 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5674 Rev 5759
Line 82... Line 82...
82 
<select id="getActiveAlertEntities" resultType="monitored_entity">
 82 
<select id="getActiveAlertEntities" resultType="monitored_entity">
83 
	SELECT *
83 
	SELECT *
84 
	FROM monitored_entity
 84 
	FROM monitored_entity
85 
	<where>
 85 
	<where>
86 
  		 warnExpiryTime &lt;= NOW()
 86 
  		 warnExpiryTime &lt;= NOW()
- 
 
 87 
  		 OR criticalExpiryTime &lt;= NOW()
87 
  	</where>
 88 
  	</where>
88 
</select>
 89 
</select>
89 
 
 90 
 
90 
<update id="updateEntityProcessedState" parameterType="map">
 91 
<update id="updateEntityProcessedState" parameterType="map">
91 
	UPDATE monitored_entity
 92 
	UPDATE monitored_entity