2 of 2 people found this helpful
If you use Select syntax instead of Delete, it shows what the contents in value column.
Select * From [piarchive].[picomp2] Where tag = 'sinusoid' and time between '*-1h' and '*'
You will find minus values in status column instead of value column for these system digital states values. (In my environment, I/O Timeout shows -246 and Configure shows -240)
So syntax should be
Delete From [piarchive].[picomp2] Where ( status = -246 or status = -240 ) and tag = 'sinusoid' and time between '*-1h' and '*'
Thank you very much Kenji, solution is working excellent.