Changes between Initial Version and Version 1 of influxdb


Ignore:
Timestamp:
05/05/22 10:20:56 (3 years ago)
Author:
krit
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • influxdb

    v1 v1  
     1= Influxdb =
     2
     3Export data to csv
     4{{{
     5OMD[monitor@3aa1bf04cbdd]:~$ influx -database nagflux -execute 'SELECT * FROM metrics' -format csv > test.csv
     6}}}
     7
     8Select the lastest 2 value from metrics
     9{{{
     10OMD[monitor@1f46579684ec]:~/etc$ influx
     11Connected to http://127.0.0.1:8086 version 1.8.10
     12InfluxDB shell version: 1.8.10
     13> use nagflux
     14Using database nagflux
     15> SELECT * FROM metrics ORDER BY DESC LIMIT 2
     16name: metrics
     17time                 command          crit crit-fill host      max min performanceLabel service unit value warn warn-fill
     18----                 -------          ---- --------- ----      --- --- ---------------- ------- ---- ----- ---- ---------
     192022-05-05T10:18:27Z check-host-alive                localhost         rtmin            ping    ms   0.014     
     202022-05-05T10:18:27Z check-host-alive 5000 none      localhost     0   rta              ping    ms   0.028 3000 none
     21>
     22
     23}}}