Rsyslog config to grep and replace text for incoming syslog and save to sql as well

Job ID: 36838130

Budget: $10 – $30 USD

I have ubuntu vm
I have rsyslog agent running and saving the incoming syslog messages to syslog file

Task-
I want to configure Rsyslog config file to regex grep and replace text “red” and “10.10” and replace them with “blue” and “20.30” in the syslog messages respectively before saving to syslog file and then also save the logs to microsoft sql server with columns- time and message and device name for incoming network syslog messages
Related categories: System Admin Linux Microsoft SQL Server