Yes sorry for the confusion I’ll try to explain as good as I can.
Please can you explain what you mean by “two merges”. Maybe give us an
example to show what you would like to achieve?
I would like to have 2 “squares” where each one of them represents multiple
windows services monitorized, if I would want only one “square” I should
just transform and merge all, but can I only merge for example 4 of the 6
queries that are inside the panel and then merge the other 2 in another
Here is an image to try to clear the “square” thing:
Imgur: The magic of the Internet
No, I’m sorry but I still don’t understand what you want to do, and that link
shows me a dark grey background in my browser and nothing else.
I have monitorized some hosts and services with Nagios and then using PNP
included to Grafana, the thing is that I don’t know how to make variable
queries because most of the other examples are from PostgresSQL/InfluxDB etc.
which I dont have. I tried to know/understand from where I’m getting all the
data but it seems like the MariaDB that I have installed doesnt collect any
data, is there any option to know that?
If you have installed Nagios and PNP4Nagios in “the standard way” then the
data being shown in PNP4Nagios is being stored in an RRD database, which:
a) I do not believe can be queried by Grafana
b) strikes me as a bad choice for a data store to use with Grafana queries
(even if it were possible), because RRD inherently deletes / amalgamates older
data to conserve storage space. If you store one data point per minute in
RRD, then the data from a year ago probably only exists as one point per hour
or one point per day.
It sounds to me that you need to select a data store which is supported by
Grafana, and can be written to by Nagios (since that’s where your data is
ultimately coming from), then you will have data coming in from your service
checks, being displayed in Nagios, also being fed into RRD for PNP4Nagios, and
going to a data store which Grafana can use.
I hope that helps,