Hello!
We are using nagios for monitoring and now I want to built a table for some of my serves with 2 colums like this.
Server | rta | pl
-----------------------
Server 1 | 0.1 | 0
Server 2 | 0.3 | 1
I get the data from influxdb.
> show measurements
name: measurements
name
----
messages
metrics
> show tag keys
name: messages
tagKey
------
author
host
service
type
name: metrics
tagKey
------
command
crit-fill
downtime
host
performanceLabel
service
unit
warn-fill
> show field keys
name: messages
fieldKey fieldType
-------- ---------
message string
name: metrics
fieldKey fieldType
-------- ---------
crit float
crit-max float
crit-min float
max float
min float
value float
warn float
SELECT last(“value”) FROM “metrics” WHERE (“host” =~ /master/ OR “host” =~ /slave/) AND (“performanceLabel” = ‘pl’ OR “performanceLabel” = ‘rta’) GROUP BY “host”, “performanceLabel”
Is it possible to get the data in two columns?
rg
Hansi