With Zabbix 4.4.6 i have a item from zabbix Agent "logrt["C:\Kataloge\Slot2_Terex_MP\Tomcat Instanz\logs\tc10mp-stdout.*.log","New amount of sessions:",,,,]".
This will work great an in zabbix - Monitoring - Latest Data - History - Values i see all entrys only once.
But in the database table history log i have two mostly identically entrys only the clock entry is different.
I have to make some calls directly into database for Grafana and wondering why the entrys are occur twice ?
Why this is happend?
How to get the Right Information when i use a Statement like
SELECT clock, FROM_UNIXTIME(timestamp, '%d.%m.%Y'), itemid, value FROM zabbix.history_log
where FROM_UNIXTIME(timestamp, '%d') = '01' and FROM_UNIXTIME(timestamp, '%m') = '03' and itemid = '31580';
This will work great an in zabbix - Monitoring - Latest Data - History - Values i see all entrys only once.
But in the database table history log i have two mostly identically entrys only the clock entry is different.
I have to make some calls directly into database for Grafana and wondering why the entrys are occur twice ?
Why this is happend?
How to get the Right Information when i use a Statement like
SELECT clock, FROM_UNIXTIME(timestamp, '%d.%m.%Y'), itemid, value FROM zabbix.history_log
where FROM_UNIXTIME(timestamp, '%d') = '01' and FROM_UNIXTIME(timestamp, '%m') = '03' and itemid = '31580';