Query Deployed Integrations

This query will list all deployed MDR Integrations.

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