SQL script to delete syslog messages from Syslog Viewer tables

tlu

I have a device that sent massive syslog messages to my Syslog Viewer.  I am looking for an SQL script to delete all Syslog Viewer messages for a device.  In the old version of syslog, it is an easy task since all messages are in a single table called Syslog. But with the newer Syslog Viewer, messages are stored across multiple tables.  Just wonder if you have any luck deleting these messages.

mesverrum

Probably best to just wait them out, the new tables use columnstore indexes and with the way they bundle up data you really don't want to be making inserts or deletes after the fact.  Notably deleting a record from a column store just adds a tag in SQL that the data is "deleted" but doesnt even remove it from disk, so nothing you do is really going to reclaim that disk space back until it ages out.

https://malapatidatabase.wordpress.com/2018/09/14/adding-updating-and-deleting-data-in-columnstore-indexes/