SELECT
			HEX(hi.exporter_id) AS exporter_hex,
			IF(SUBSTRING_INDEX(MAX(ti.nametag),':',-1) IN('asa','sonicwall','flowalyzer','mailinizer','enterasys','paloalto','barracuda','vitals') ,
				SUBSTRING_INDEX(MAX(ti.nametag),':',-1),
					'flow') AS icon_type
		FROM plixer.distributed_history_index hi
		JOIN plixer.distributed_template_names ti ON hi.template_hash_int = ti.template_hash_int
		WHERE interval_len = 1
		AND ti.nametag NOT LIKE '%:'
		GROUP BY exporter_id