How to purge events from a specific vendor after a set period of time.

We are running into disk space issues on our OrionLog database. While we work through creating rules to reduce the amount of messages being stored we would like to purge all messages from a specific vendor after a set number of days. Does anyone have any experience with SQL or SWQL in order to remove records from the Orion Log database?

We do not want to reduce the overall number of days for retention for all records.