There are no metrics available for device level monitoring. If you have access to BigQuery then you can run this (example that you will customize for your needs):
SELECT principal.hostname as device, MAX(metadata.event_timestamp.seconds) as maxtime, count(*)
FROM `datalake.events` as events
WHERE DATE(hour_time_bucket) > DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
AND metadata.vendor_name = "Microsoft"
group by 1
having count(*) > 1000
and (unix_seconds(current_timestamp()) - maxtime ) > 60*60
ORDER BY device
LIMIT 100;
Hi Raju,
Can this be achieved by Writing YARA L rules?
Can it be done using Sliding window
https://cloud.google.com/chronicle/docs/detection/yara-l-2-0-syntax#sliding_window