Hi There!
I'm currently try to visualize Icinga2 and Graphite Data (Monitoring Software)
Icinga2 Data:
The Icinga2 Data is in MySQL and I can create 2 Lists that look like the following:
- Statehistory -
timestamp; host; service; lastState; currentState
2017-05-04 08:56; MyServer; CPULoad; 2; 0;
2017-05-04 08:57; MyServer; CPULoad; 0; 1;
- Maintenance History -
startTimestamp; host; service; endTimestamp;
2017-05-04 07:30; MyServer; CPULoad; 2017-05-04 08:30;
And what I want to view is, per Host and Service a 100% daily bar chart which shows like:
2017-05-04: 10% state 3 not in maintenance, 20% state 1 in maintenance, 10% state 2 not in maintenance, 60 % state 0 not in maintenance
So somehow I would need to count the time between the last entry with the same host and service and add it to a daily summary for the different states (0-3)?
Graphite Data:
The Graphite data is like a performance data table with values in time. (just like Windows perfcounter)
I have RestAPI JSON Data with the following structure:
>root
|->target MyServer.CPULoad
|->datapoints
|->0
|-> linux timestamp
|-> value
|->1
|-> linux timestamp
|-> value
|->target MyServer.MemLoad
|->datapoints
...etc
And I want to view the data like the performance counters in Windows, just the different values in time.
Do you have any hint on how to drill this data and even merge somehow so that I can filter for a host and service and get the correct information displayed?
I currently builded a workaround with a powershell script that creates a csv file with the same data but it takes a long time and is not very accurate or scaleable.
Thank you very much for your tips!
best regards, Duffkess.
