Fastest way to purge data of things

[TanmeyTWX]

Hi,

What is the fastest and reliable way to purge data of Things with logged Properties?

doing Value Stream purging from Composer either gets timeout or long ending execution. E.g. PurgeAllPropertyHistory

Is there any way to Purge logged property data of all the Things in one go? 

Any postgres query can be triggered from Thingworx to purge all the data?

[odukiya]

Hello @TanmeyTWX 

Please follow the following article :

https://www.ptc.com/en/support/article/CS271772

Let me know if it doesn't resolve your query.

Thanks

Om Dukiya

[TanmeyTWX]

Already tried this but since I have huge data, it is getting timed out for the service execution.

[Ciprian-Traian]

Hello @TanmeyTWX,

Have you seen the following posts on community:

https://community.ptc.com/t5/ThingWorx-Developers/Purge-stream-entry-and-purge-all-property-values-services-are/td-p/616952

https://community.ptc.com/t5/ThingWorx-Developers/Unable-to-cleanup-value-stream-in-loop/m-p/515277

Hope it helps,

[abhiramk]

If you're looking for fastest way, login to db and delete entries by query. From thingworx query transaction and delete and commit will take little time.