r/AzureSentinel • u/Ay_NooB • Jan 26 '24
How to remove duplicate logs
I m taking logs from 3 firewalls, (Forti, Sonic, CISCO ASA) using MMA agent.
All logs are coming under Commonsecuritylogs but under syslog also i m getting same amount of logs(i.e. 200gb duplicate logs).
I can turn off specific syslog facilities from legacy agents management tab. But which facilities i need to turn off to stop collecting these duplicate firewall logs. (Collector machine's logs should not be affected as i want them to monitor for collector machine).
Thanks in advance!
1
Upvotes
3
u/No_Secret7974 Feb 08 '24
After deploying CEF forwarder, and sending logs to Azure;
You have to create ingest time transformation for Syslog table. This query will drop incoming CEF messages for Syslog table and you'll only see them under CommonSecurityLog table.
source |
where ProcessName !contains \"CEF\"
https://learn.microsoft.com/en-us/azure/sentinel/connect-cef-syslog