I want to delete the wrongly inserted values like 'Configure, I/O Timeout etc...' from PI Archive through PI OLEDB using c# code.
For this I tried the below command but it is not working.
Delete From [piarchive].[picomp2]
Where ( value = 'Configure' or value = 'I/O Timeout' ) and tag = 'sinusoid' and time between '*-1h' and '*'
Can anyone provide me the solution to delete the data based on the value column.