C:\influxdb-1.6.3-1>influx_cleanup Deletes implausible values from Influx DB. by Andreas Nordvall USE AT YOUR OWN RISK. Always make a backup of your database before trying. Usage: influx_clean [database] [option] Options: -version Display the version and exit. -show Show all measurements, min values and max values from measurements.ini. -run-dry Test cleanup but without actually deleting anything. -run-with-summary WARNING: This will delete all measurement values less than "Min allowed" and greater than "Max allowed" as speficied in measurements.ini, and show a summary at the end. -run-verbose WARNING: This will delete all measurement values less than "Min allowed" and greater than "Max allowed" as speficied in measurements.ini, and show each step taken Examples: influx_clean -show influx_clean openhab -run-with-summary C:\influxdb-1.6.3-1>influx_cleanup -version Influx Cleanup version: 0.7 C:\influxdb-1.6.3-1>influx_cleanup -show Measurement Min allowed Max allowed ---------------------------------------------------------------- Temp_Outdoor -50 50 Temp_Outdoor_FrontSide -50 50 Temp_Outdoor_BackSide -50 50 Temp_WinterGarden -50 80 Temp_Poolwater -10 50 Temp_Garage -30 80 Temp_Storage -30 80 Temp_Attic_1 -50 50 Temp_Attic_2 -50 50 Temp_Guestroom 0 50 Temp_Bedroom 0 50 Temp_Livingroom 0 50 Temp_Kitchen 0 50 Temp_Kitchen_Fridge 0 30 Temp_Kitchen_WineFridge_Red -5 40 Temp_Kitchen_WineFridge_White -5 40 Temp_Hallway 0 50 Temp_Familyroom 0 50 Temp_Closet 0 50 Temp_Laundry 0 50 Temp_Bathroom 0 50 Temp_WC 0 50 Humidity_Outdoor 0 110 Humidity_WinterGarden 0 110 Humidity_Garage 0 110 Humidity_Storage 0 110 Humidity_Attic_1 0 110 Humidity_Attic_2 0 110 Humidity_Guestroom 0 110 Humidity_Bedroom 0 110 Humidity_Livingroom 0 110 Humidity_Kitchen 0 110 Humidity_Kitchen_Fridge 0 110 Humidity_Kitchen_WineFridge_Red 0 110 Humidity_Kitchen_WineFridge_White 0 110 Humidity_Hallway 0 110 Humidity_Familyroom 0 110 Humidity_Closet 0 110 Humidity_Laundry 0 110 Humidity_Bathroom 0 110 Humidity_WC 0 110 AirPressure_Outdoor 0 200 AirPressure_WinterGarden 0 200 AirPressure_Garage 0 200 AirPressure_Storage 0 200 AirPressure_Attic_1 0 200 AirPressure_Attic_2 0 200 AirPressure_Guestroom 0 200 AirPressure_Bedroom 0 200 AirPressure_Livingroom 0 200 AirPressure_Kitchen 0 200 AirPressure_Kitchen_Fridge 0 200 AirPressure_Kitchen_WineFridge_Red 0 200 AirPressure_Kitchen_WineFridge_White 0 200 AirPressure_Hallway 0 200 AirPressure_Familyroom 0 200 AirPressure_Closet 0 200 AirPressure_Laundry 0 200 AirPressure_Bathroom 0 200 AirPressure_WC 0 200 C:\influxdb-1.6.3-1>influx_cleanup -run-dry Invalid arguments. C:\influxdb-1.6.3-1>influx_cleanup openhab -run-dry influx.exe -database openhab -execute "SELECT value FROM Temp_Outdoor WHERE value < -50 OR value > 50" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Outdoor_FrontSide WHERE value < -50 OR value > 50" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Outdoor_BackSide WHERE value < -50 OR value > 50" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_WinterGarden WHERE value < -50 OR value > 80" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Poolwater WHERE value < -10 OR value > 50" Implausible value: 1603684703498000000 163.83 influx.exe -database openhab -execute "DELETE FROM Temp_Poolwater WHERE time = 1603684703498000000" influx.exe -database openhab -execute "SELECT value FROM Temp_Garage WHERE value < -30 OR value > 80" Implausible value: 1602886128369000000 -100 influx.exe -database openhab -execute "DELETE FROM Temp_Garage WHERE time = 1602886128369000000" influx.exe -database openhab -execute "SELECT value FROM Temp_Storage WHERE value < -30 OR value > 80" Implausible value: 1602462904382000000 -100 influx.exe -database openhab -execute "DELETE FROM Temp_Storage WHERE time = 1602462904382000000" Implausible value: 1602565417813000000 -100 influx.exe -database openhab -execute "DELETE FROM Temp_Storage WHERE time = 1602565417813000000" Implausible value: 1602576855553000000 -100 influx.exe -database openhab -execute "DELETE FROM Temp_Storage WHERE time = 1602576855553000000" influx.exe -database openhab -execute "SELECT value FROM Temp_Attic_1 WHERE value < -50 OR value > 50" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Attic_2 WHERE value < -50 OR value > 50" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Guestroom WHERE value < 0 OR value > 50" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Bedroom WHERE value < 0 OR value > 50" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Livingroom WHERE value < 0 OR value > 50" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Kitchen WHERE value < 0 OR value > 50" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Kitchen_Fridge WHERE value < 0 OR value > 30" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Kitchen_WineFridge_Red WHERE value < -5 OR value > 40" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Kitchen_WineFridge_White WHERE value < -5 OR value > 40" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Hallway WHERE value < 0 OR value > 50" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Familyroom WHERE value < 0 OR value > 50" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Closet WHERE value < 0 OR value > 50" Implausible value: 1601869888753000000 -100 influx.exe -database openhab -execute "DELETE FROM Temp_Closet WHERE time = 1601869888753000000" Implausible value: 1601937879707000000 -100 influx.exe -database openhab -execute "DELETE FROM Temp_Closet WHERE time = 1601937879707000000" Implausible value: 1602929507355000000 -100 influx.exe -database openhab -execute "DELETE FROM Temp_Closet WHERE time = 1602929507355000000" Implausible value: 1603017514259000000 -100 influx.exe -database openhab -execute "DELETE FROM Temp_Closet WHERE time = 1603017514259000000" influx.exe -database openhab -execute "SELECT value FROM Temp_Laundry WHERE value < 0 OR value > 50" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_Bathroom WHERE value < 0 OR value > 50" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Temp_WC WHERE value < 0 OR value > 50" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Outdoor WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_WinterGarden WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Garage WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Storage WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Attic_1 WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Attic_2 WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Guestroom WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Bedroom WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Livingroom WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Kitchen WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Kitchen_Fridge WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Kitchen_WineFridge_Red WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Kitchen_WineFridge_White WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Hallway WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Familyroom WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Closet WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Laundry WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_Bathroom WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM Humidity_WC WHERE value < 0 OR value > 110" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Outdoor WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_WinterGarden WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Garage WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Storage WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Attic_1 WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Attic_2 WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Guestroom WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Bedroom WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Livingroom WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Kitchen WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Kitchen_Fridge WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Kitchen_WineFridge_Red WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Kitchen_WineFridge_White WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Hallway WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Familyroom WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Closet WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Laundry WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_Bathroom WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. influx.exe -database openhab -execute "SELECT value FROM AirPressure_WC WHERE value < 0 OR value > 200" No implausible values. Nothing to delete. NOTE: This was a DRY RUN! Nothing was actually deleted. C:\influxdb-1.6.3-1>influx_cleanup openhab -run-with-summary DELETED VALUES Measurement # of deleted values Temp_Outdoor 0 Temp_Outdoor_FrontSide 0 Temp_Outdoor_BackSide 0 Temp_WinterGarden 0 Temp_Poolwater 1 Temp_Garage 1 Temp_Storage 3 Temp_Attic_1 0 Temp_Attic_2 0 Temp_Guestroom 0 Temp_Bedroom 0 Temp_Livingroom 0 Temp_Kitchen 0 Temp_Kitchen_Fridge 0 Temp_Kitchen_WineFridge_Red 0 Temp_Kitchen_WineFridge_White 0 Temp_Hallway 0 Temp_Familyroom 0 Temp_Closet 4 Temp_Laundry 0 Temp_Bathroom 0 Temp_WC 0 Humidity_Outdoor 0 Humidity_WinterGarden 0 Humidity_Garage 0 Humidity_Storage 0 Humidity_Attic_1 0 Humidity_Attic_2 0 Humidity_Guestroom 0 Humidity_Bedroom 0 Humidity_Livingroom 0 Humidity_Kitchen 0 Humidity_Kitchen_Fridge 0 Humidity_Kitchen_WineFridge_Red 0 Humidity_Kitchen_WineFridge_White 0 Humidity_Hallway 0 Humidity_Familyroom 0 Humidity_Closet 0 Humidity_Laundry 0 Humidity_Bathroom 0 Humidity_WC 0 AirPressure_Outdoor 0 AirPressure_WinterGarden 0 AirPressure_Garage 0 AirPressure_Storage 0 AirPressure_Attic_1 0 AirPressure_Attic_2 0 AirPressure_Guestroom 0 AirPressure_Bedroom 0 AirPressure_Livingroom 0 AirPressure_Kitchen 0 AirPressure_Kitchen_Fridge 0 AirPressure_Kitchen_WineFridge_Red 0 AirPressure_Kitchen_WineFridge_White 0 AirPressure_Hallway 0 AirPressure_Familyroom 0 AirPressure_Closet 0 AirPressure_Laundry 0 AirPressure_Bathroom 0 AirPressure_WC 0