Hello,
I’m using checkmk raw edition, and I’d like to know how to export the CPU load metrics data which I can later interpolate to my needs?
Well, what format do you need? We do not know your needs, so a little context might help answering this.
csv format will be fine
When I’m doing export CSV, getting the following csv file as
sitealias;“host_with_state”;“service_description”;“service_graphs”
Local site checkMktrssite;“achievers”;“CPU load”;“NOT_CSV_EXPORTABLE”
I did a quick look on my raw installation.
The Export CSV / JSON on mine feels like it’s exporting the config of the graph, but not the cpu data.
I fear that if you need an export of the actual data, never done that myself, that you have to do this with the RRDs files directly.
On my server I found these files per host folder in ~/var/pnp4nagios/perfdata/.
The docs (Performance data and graphing - Evaluating measured values in Checkmk quickly and easily) suggest the open source tool RRDTool (RRDtool - RRDtool Documentation) which has module rrdxport to export the data as XML or JSON.
Correct, the way @supadhy did it, basically exports the current view as CSV.
What one can do is click on the hamburger menu on the lower left of the graph itself, scroll to the very bottom, and export as JSON. Not CSV, but I am sure there is an easy way to convert it.
This is not an option on my 2.1.0p5 cre. Only options to add graph to a collection.
Huh, seems to be a feature of the commercial editions then. I was not aware, apologies.
One possible way to get the wanted data is a livestatus query for the performance data.
In this Metrics with livestatus old post you find some important information you need for fetching performance data over a livestatus query.
1 Like