Hello,
I'm not seeing any syslogs being collected correctly please advise?
- I’m not seeing logs from Cisco Firepower?
- Any logs coming into the Syslog from Meraki are being filtered, is this by design?
SELECT
sensor_type Integration_Category,
sensor_vendor Vendor,
COUNT(*) Records,
CAST(CAST(SUM(upload_size)/1024.0 AS DECIMAL(10,2)) AS VARCHAR)||'KB' Data_uploaded,
CAST(DATE_DIFF('hour',MAX(ioc_created_at), NOW()) AS VARCHAR)||' Hours ago' Last_Update,
ioc_worker_name
FROM mdr_ioc_all
GROUP BY 1,2,6
ORDER BY 1,2,6
Edited TAGs
[edited by: Gladys at 10:35 AM (GMT -8) on 19 Jan 2023]