Hello!
I have 2 wrong values in my database and want to overwrite them:
I have tried this.
but an insert did not overwritten the value:
> SELECT "value" FROM "NRPE_Windows_Check_StoreOnce_Store_FilesStore" WHERE "host" = 'StoreOnce' AND "label" = 'HPCZ3651HG01 FilesStore used' and time=1512997793000000000
name: NRPE_Windows_Check_StoreOnce_Store_FilesStore
time value
---- -----
1512997793000000000 4.200907450199e+12
> SELECT "value" FROM "Filestore" WHERE "host" = 'StoreOnce' AND "label" = 'FilesStore used' and value > 5000
name: Filestore
time value
---- -----
1512997793000000000 4.200907450199e+12
1512998093000000000 4.200907450199e+12
> insert Filestore,host=StoreOnce value=4200.91 1512997793000000000
> insert NRPE_Windows_Check_StoreOnce_Store_FilesStore,host=StoreOnce value=4200.91 1512998093000000000
> SELECT "value" FROM "Filestore" WHERE "host" = 'StoreOnce' AND "label" = 'FilesStore used' and value > 5000
name: Filestore
time value
---- -----
1512997793000000000 4.200907450199e+12
1512998093000000000 4.200907450199e+12
>
You can see that nothing was written to influx.
how can I overwrite the 2 values?
rg
Hansi