Hi . This is the first entry in google when searching for this topic and I had to hunt around a bit. It seems that since the hosts are stored in the measurements, you have to remove the series that have the host. Thanks to this post I was able to put this together using the influxdb command line:
> use telegraf
Using database telegraf
>
>
> show series where host='skynet'
key
---
cpu,cpu=cpu-total,host=skynet
cpu,cpu=cpu0,host=skynet
cpu,cpu=cpu1,host=skynet
cpu,cpu=cpu2,host=skynet
cpu,cpu=cpu3,host=skynet
disk,device=rootfs,fstype=rootfs,host=skynet,path=/
disk,device=sda1,fstype=ext4,host=skynet,path=/
disk,device=sda1,fstype=ext4,host=skynet,path=/var/lib/docker/aufs
diskio,host=skynet,name=sda
diskio,host=skynet,name=sda1
diskio,host=skynet,name=sda2
diskio,host=skynet,name=sda5
kernel,host=skynet
mem,host=skynet
processes,host=skynet
swap,host=skynet
system,host=skynet
>
>
> drop series where host='skynet'
>
>
> show series where host='skynet'
>
>