06:40:50 &nbsp-&nbspfetchTriggers<br><br>06:40:50 &nbsp-&nbspSELECT trigger_id, trigger_source_spk, trigger_dest_spk FROM pp_trigger_active ORDER BY trigger_id<br><br>
06:40:50 &nbsp-&nbspRow Count:0<br><br>06:40:50 &nbsp-&nbspSELECT trigger_source_spk, trigger_dest_spk FROM pp_trigger_mst WHERE trigger_dest_spk IN (0)<br><br>06:40:50 &nbsp-&nbspRow Count:0<br><br>06:40:50 &nbsp-&nbspSELECT sensor_pk, a.node_id as node_id, sensor_active, sensor_index, sensor_type, report_group_id, sensor_name, sensor_debounce_delay_in_seconds, sensor_enabled_set_points, sensor_very_low_setpoint, sensor_low_setpoint, sensor_high_setpoint, sensor_very_high_setpoint, sensor_setpoint_hysterisis, sensor_very_low_message, sensor_low_message, sensor_high_message, sensor_very_high_message, sensor_healthy_message, sensor_over_sample_count_averaging_filter, sensor_output_value_unit_suffix, sensor_rate_of_update, sensor_very_low_message_id, sensor_low_message_id, sensor_high_message_id, sensor_very_high_message_id, sensor_healthy_message_id, sensor_data_type, sensor_offset, sensor_scaling_ratio_numerator, sensor_scaling_ratio_denominator, sensor_decimal_precision, sensor_modbus_speed, sensor_modbus_databits, sensor_modbus_parity, sensor_modbus_stopbits, sensor_modbus_command, sensor_modbus_timeout_millisecs, sensor_modbus_retries, sensor_port_index, sensor_logging_type, sensor_logging_tolerance, sensor_discard_values_flag, sensor_discard_low_limit, sensor_discard_high_limit, sensor_last_reading_time, sensor_last_reading_value, sensor_last_reading_value_ascii, sensor_last_reading_error, sensor_last_comm_error, sensor_scp_change_flag, sensor_scp_change_sent_flag, sensor_modbus_address, sensor_modbus_function, sensor_modbus_start_reg_addr, sensor_modbus_reg_count, sensor_data_byte_order_index, sensor_filter_type, sensor_filter_paramter, sensor_mbr_data_offset, post_process_id, post_process_inputs, enabled_escalation_level, current_error_escalation_state, current_error_trigger_time, sms_alert_enabled_setpoints, a.service_mobile_ids AS service_mobile_ids, level_1_escalation_delay, level_1_mobile_ids, level_2_escalation_delay, level_2_mobile_ids, level_3_escalation_delay, level_3_mobile_ids, level_4_escalation_delay, level_4_mobile_ids, a.trigger_sms_from_server AS sensor_trigger_enabled_flag, sms_alert_count_today, COALESCE( sms_alert_count_date, '0000-00-00') as sms_alert_count_date, sms_alert_per_day_max, b.node_name as node_name, b.node_dead_flag as node_dead_flag, b.trigger_sms_from_server AS node_trigger_enabled_flag, a.comm_error_escalation_state, a.sms_alert_on_comm_error_enable, sms_alert_on_comm_error_delay, a.sms_alert_on_comm_error_levels, a.last_comm_error_trigger_time, c.customer_short_code AS customer_short_code, c.trigger_sms_from_server AS custmer_trigger_enabled_flag, a.mbr_cmd_pk AS mbr_cmd_pk, d.mbr_cmd_name AS mbr_cmd_name, a.sensor_name_display_type_id, a.data_push_sequence AS data_push_sequence, a.pre_process_id AS pre_process_id, a.preprocess_value_1 AS preprocess_value_1, a.preprocess_value_2 AS preprocess_value_2, a.sensor_ams_enable AS sensor_ams_enable, a.recovered_from_comm_error AS recovered_from_comm_error, b.customer_id AS customer_id, b.node_odp_enabled_flag AS node_odp_enabled_flag, c.customer_active FROM node_sensor_dtl a LEFT JOIN node_mbr_dtl d ON (a.mbr_cmd_pk = d.mbr_cmd_pk), node_mst b, customer c WHERE b.node_id = a.node_id AND c.id = b.customer_id AND a.sensor_pk IN (0)<br><br>