How to Delete Specific Records from the DB?

paregupt / ucs_traffic_monitor

Cisco UCS traffic monitoring using Grafana, InfluxDB and Telegraf

MIT License

80 stars 25 forks source link

How to Delete Specific Records from the DB? #64

Closed mnagy7 closed 2 years ago

mnagy7 commented 3 years ago

Is there is an easy way to delete a couple of locations and UCS domains I added by mistake from the DB?.. I have removed it from the configuration test files but I still can see it on the dashboard!

Great work by the way :)

paregupt commented 3 years ago

Check #63 for the delete syntax. Then, use where keyword with location, such as location='US', . Check the syntax here for more details: https://docs.influxdata.com/influxdb/v1.8/query_language/manage-database/#delete-series-with-delete Be careful with anything with data delete. You may lose the data if done wrongly.

paregupt commented 3 years ago

Did it work?

mnagy7 commented 3 years ago

I did not have time to test it yet. I will let you know once I do. Thanks for asking.

paregupt commented 2 years ago

Closing this issue. Feel free to open it again if the problem persists or a newer issue for a newer problem.