Hello everyone, i want to calculate the storage volume used by each log type in Google SecOps.
For this, i have used the below query to create a dashboard, and this gives me the volume for each ingestion component (Ingestion API, Normalizer, Out-of-Band Processor)
I want to know, if i want to calculate the storage volume used, which ingestion component/s should be considered?
$comp = ingestion.component
ingestion.log_type != ""
$Log_Type = ingestion.log_type
$Date = timestamp.get_date(ingestion.end_time)
match:
$Log_Type, $comp
outcome:
$Count = math.round(sum(ingestion.log_volume) / (1000 * 1000 * 1000), 2)
$eventc = math.round(sum(ingestion.log_count))
order:
$Count desc