Удаление

USE icinga2

#Просмотр серий
SHOW SERIES FROM "powershell" WHERE "hostname" = 'uk012.ukrgo.local'

#Удаление серий
DROP SERIES FROM "powershell" WHERE "hostname" = 'uk012.ukrgo.local' AND "service" = 'temperature-cpu'
DROP SERIES FROM "powershell" WHERE "service" = 'print-job-audit'

DROP SERIES FROM "check_cisco_asa" WHERE "service" = 'cisco-asa-sessions'

Просмотр измерений

> SHOW MEASUREMENTS
name: measurements
name
----
apt
check-elasticsearch
check_asterisk_peer
check_cisco_firewall
check_cisco_ips
check_ilo_hpasm
check_snmp_cisco_envmon
check_unifi
cluster-zone
disk
dummy
hostalive
http
icinga
icinga_reload_config
interfacetable
load
memory-windows
my-mysql
network-windows
ping
ping4
ping6
powershell
powershell-bypass
procs
snmp
speedtest
ssh
swap
tcp
uptime-windows
users
> SHOW SERIES FROM "powershell" WHERE "hostname" = 'ups-ippon1000.hv4.mkucou.local'
key
---
powershell,hostname=ups-ippon1000.hv4.mkucou.local,metric=Out-File\ $NUTOuputFile\ 'ups.load',service=ups-load
powershell,hostname=ups-ippon1000.hv4.mkucou.local,metric=battery.charge,service=battery-charge
powershell,hostname=ups-ippon1000.hv4.mkucou.local,metric=battery.charge,service=ups-details
powershell,hostname=ups-ippon1000.hv4.mkucou.local,metric=battery.voltage,service=battery-voltage
powershell,hostname=ups-ippon1000.hv4.mkucou.local,metric=battery.voltage,service=ups-details
powershell,hostname=ups-ippon1000.hv4.mkucou.local,metric=input.voltage,service=input-voltage
powershell,hostname=ups-ippon1000.hv4.mkucou.local,metric=input.voltage,service=ups-details
powershell,hostname=ups-ippon1000.hv4.mkucou.local,metric=ups.load,service=ups-details
powershell,hostname=ups-ippon1000.hv4.mkucou.local,metric=ups.load,service=ups-load
powershell,hostname=ups-ippon1000.hv4.mkucou.local,metric=ups.temperature,service=ups-details
powershell,hostname=ups-ippon1000.hv4.mkucou.local,metric=ups.temperature,service=ups-temperature
powershell,hostname=ups-ippon1000.hv4.mkucou.local,service=battery-charge
powershell,hostname=ups-ippon1000.hv4.mkucou.local,service=battery-voltage
powershell,hostname=ups-ippon1000.hv4.mkucou.local,service=input-voltage
powershell,hostname=ups-ippon1000.hv4.mkucou.local,service=ups-details
powershell,hostname=ups-ippon1000.hv4.mkucou.local,service=ups-load
powershell,hostname=ups-ippon1000.hv4.mkucou.local,service=ups-temperature

if you still want to have the old data, i would rename the old measurement. In the InfluxDB docs is a workaround for renaming, maybe this can solve your problem.

SELECT * INTO new_name FROM old_name
DROP MEASUREMENT old_name