Syslogs for Cisco Firepower/Meraki

Hello,

I'm not seeing any syslogs being collected correctly please advise?

  1. I’m not seeing logs from Cisco Firepower?
  2. 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]