回答編集履歴

回答を修正

2022/03/04 08:46

投稿

スコア98

test CHANGED Viewed

@@ -1,6 +1,6 @@
 以下で対応でできました。
 ```sql
-SELECT DISTINCT SUBSTRING_INDEX(REGEXP_REPLACE(zabbix.history_str.value, '@.+',''), '|', 1) AS 'TAG' FROM    zabbix.history_str    LEFT JOIN zabbix.items USING(itemid) WHERE AND from_unixtime(zabbix.history_str.clock) BETWEEN  '2022-03-02T17:46' AND  '2022-03-05T18:46';
+SELECT DISTINCT SUBSTRING_INDEX(REGEXP_REPLACE(zabbix.history_str.value, '@.+',''), '|', 1) AS 'address' FROM    zabbix.history_str    LEFT JOIN zabbix.items USING(itemid) WHERE  from_unixtime(zabbix.history_str.clock) BETWEEN  '2022-03-01T17:46' AND  '2022-03-05T18:46';
 ```