Graph Custom Logfile
hey guys and gals,
i'll start from the top.
i have a SQL query that counts number of actions (for example, phones that have been sold) in the last hour, devided by minutes.
the query runs once a hour for the hour that passed and looks like this:
20140911220000,12
20140911220100,204
20140911220200,5
20140911220300,13
20140911220400,841
...
...
...
explanation - between 10:00PM and 10:01PM, of the 11th of September 2014 we sold 12 phones.
between 10:01PM and 10:02PM, of the 11th of September 2014 we sold 204 phones... and so goes 60 times.
the wuery runs once a hour and adds the new 60 lines with the relevant timestamp in a logfile (C:\sells.log).
Now, i want to use zabbix to somehow put this in a graph.
THE PROBLEM, is off course that the SQL query runs only once a hour, and so does zabbix, and all the new 60 lines are being written in a specific time, and not the actual time i have in the log file.
Things i already tried:
1. use log monitoring and then use calculated item to take the last data of the lof monitoring. doesn't work off course because it takes only the data of the last minute of every hour.
2. i tried to use the Log Time Format but i didn't really understand the use of it.
when i use RegExp to take only the actual number from the log file it doesn't put anything in the "Local Time" field, and if i don't it does, but also put all the line from the log file in the data (20140911220000,12), which is really not what i need.
im really frustrated
please help
Thanks.
i'll start from the top.
i have a SQL query that counts number of actions (for example, phones that have been sold) in the last hour, devided by minutes.
the query runs once a hour for the hour that passed and looks like this:
20140911220000,12
20140911220100,204
20140911220200,5
20140911220300,13
20140911220400,841
...
...
...
explanation - between 10:00PM and 10:01PM, of the 11th of September 2014 we sold 12 phones.
between 10:01PM and 10:02PM, of the 11th of September 2014 we sold 204 phones... and so goes 60 times.
the wuery runs once a hour and adds the new 60 lines with the relevant timestamp in a logfile (C:\sells.log).
Now, i want to use zabbix to somehow put this in a graph.
THE PROBLEM, is off course that the SQL query runs only once a hour, and so does zabbix, and all the new 60 lines are being written in a specific time, and not the actual time i have in the log file.
Things i already tried:
1. use log monitoring and then use calculated item to take the last data of the lof monitoring. doesn't work off course because it takes only the data of the last minute of every hour.
2. i tried to use the Log Time Format but i didn't really understand the use of it.
when i use RegExp to take only the actual number from the log file it doesn't put anything in the "Local Time" field, and if i don't it does, but also put all the line from the log file in the data (20140911220000,12), which is really not what i need.
im really frustrated
please help
Thanks.
Comment